• Title PostgreSQL Notes for Professionals
• Author(s) Stack Overflow Contributors
• Publisher: Goalkicker (2018, updated weekly)
• License(s): Creative Commons BY-SA
• Hardcover/Paperback N/A
• eBook PDF
• Language: English
• ISBN-10: N/A
• ISBN-13: N/A
• Share This:  

Book Description

This book is the definitive guide to undocumented and partially-documented features of the PostgreSQL server. It helps you learn to apply the right solution at the right time, about avoiding risk, about making robust choices related to PostgreSQL databases. It is packed with of experience over decades deep to lay out real-world techniques.

It highlights the newly introduced features in PostgreSQL, and shows you how you can build better PostgreSQL applications, and administer your PostgreSQL database more efficiently. We begin by explaining advanced database design concepts in PostgreSQL, along with indexing and query optimization. You will also see how to work with event triggers and perform concurrent transactions and table partitioning, along with exploring SQL and server tuning.

PostgreSQL Notes for Professionals book is compiled from Stack Overflow Documentation, the content is written by the beautiful people at Stack Overflow. Text content is released under Creative Commons BY-SA. See credits at the end of this book whom contributed to the various chapters. Images may be copyright of their respective owners unless otherwise specified

• N/A

• Amazon
• Amazon (PostgreSQL: Up and Running: A Practical Guide to the Advanced Open Source Database)

• PostgreSQL
• SQL - The Structured Query Language
• MySQL Databases
• Oracle Databases

• PostgreSQL Notes for Professionals
• The Mirror Site (1) - Download only

• The Internals of PostgreSQL (Hironobu Suzuki)

  This book describes the internals of PostgreSQL for database administrators and system developers. The main purposes of this book are to explain how each subsystem works, and to provide the whole picture of PostgreSQL.

• Postgres Succinctly (Peter Shaw)

  This book provides a concise overview to help you quickly understand and use PostgreSQL's unique features. It guides you from installing Postgres, to creating your first database, to using Postgres in a .NET application with ADO .NET and Entity Framework.

• PostgreSQL: An Introduction (WikiBooks)

  The purpose of this book is an introduction to the PostgreSQL specific aspects: its architecture, installing procedure, maintenance and optimization tasks. Thus it is primarily aimed to database administrators.

• O'Reilly® Practical PostgreSQL (John C. Worsley, et al)

  This comprehensive new volume shows you how to compile PostgreSQL from source, create a database, and configure PostgreSQL to accept client-server connections. It also covers the many advanced features.

• PostgreSQL: Introduction and Concepts (Bruce Momjian)

  The book is designed to lead the reader from their first database query through the complex queries needed to solve real-world problems. No knowledge of database theory or practice is required.

• PostgreSQL Tutorials

  These tutorials offer readers a thorough overview of database basics, starting with an explanation of why you might need to use a PostgreSQL database, and following with a summary of what different database types have to offer when compared to alternatives like spreadsheets.