Editor's top PostgreSQL books
3PostgreSQL: Up and Running
Regina Obe, Leo Hsu · O'Reilly · 167 pages · ~4 hrs to read
The standard PostgreSQL reference book — covers data types, queries, performance, replication, extensions, and PostGIS. Written by two PostgreSQL contributors. The most practical single volume for working with PostgreSQL in production.
The Art of PostgreSQL
Dimitri Fontaine
The advanced PostgreSQL book — teaches SQL as a high-level programming language, covering window functions, CTEs, recursive queries, and JSONB manipulation. Written by a PostgreSQL contributor and focused on the SQL patterns that eliminate application-layer complexity.
PostgreSQL Query Optimization
Henrietta Dombrovskaya, Boris Novikov & Anna Bailliekova · Apress · 280 pages · ~7 hrs to read
The most focused book available on reading and reshaping PostgreSQL query plans — indexing choices, join algorithms, and how to rewrite a slow query once EXPLAIN ANALYZE tells you where the cost lives. Written by an active member of the Chicago PostgreSQL User Group.
PostgreSQL Books for Beginners
5PostgreSQL: Up and Running
Regina Obe, Leo Hsu · O'Reilly · 167 pages · ~4 hrs to read
The standard PostgreSQL reference book — covers data types, queries, performance, replication, extensions, and PostGIS. Written by two PostgreSQL contributors. The most practical single volume for working with PostgreSQL in production.
Learning PostgreSQL
Salahaldin Juba, Achim Vannahme & Andrey Volkov · Packt · 464 pages · ~12 hrs to read
Covers PostgreSQL from installation and DDL/DML through concurrency control (MVCC), stored functions, and triggers in a structured, classroom-style progression. A solid alternative entry point with more worked exercises than Up and Running provides.
Practical PostgreSQL
John Worsley & Joshua Drake · O'Reilly · 639 pages · ~16 hrs to read
An older but still useful installation-through-administration guide covering compiling from source, transactions, PL/pgSQL, and backup and recovery. Best suited to readers who want the full administrative picture.
Learn PostgreSQL, 2nd Edition
Luca Ferrari & Enrico Pirozzi · Packt · 745 pages · ~19 hrs to read
Written by a founder of the Italian PostgreSQL Community, this updated edition covers PostgreSQL 16 installation, configuration, and secure, scalable database design and development.
Beginning Databases with PostgreSQL, 2nd Edition
Neil Matthew & Richard Stones · Apress · 650 pages · ~16 hrs to read
A from-scratch database design book that happens to use PostgreSQL as its teaching database — useful for readers who need normalization and schema-design theory alongside PostgreSQL syntax.
Intermediate & Advanced PostgreSQL Books
5The Art of PostgreSQL
Dimitri Fontaine
The advanced PostgreSQL book — teaches SQL as a high-level programming language, covering window functions, CTEs, recursive queries, and JSONB manipulation. Written by a PostgreSQL contributor and focused on the SQL patterns that eliminate application-layer complexity.
Mastering PostgreSQL 15
Hans-Jürgen Schönig · Packt · 523 pages · ~13 hrs to read
Covers advanced PostgreSQL topics — stored procedures, partitioning, replication, logical decoding, and performance tuning. Good for engineers who need to operate PostgreSQL at scale and want more depth than introductory texts.
PostgreSQL Query Optimization
Henrietta Dombrovskaya, Boris Novikov & Anna Bailliekova · Apress · 280 pages · ~7 hrs to read
The most focused book available on reading and reshaping PostgreSQL query plans — indexing choices, join algorithms, and how to rewrite a slow query once EXPLAIN ANALYZE tells you where the cost lives. Written by an active member of the Chicago PostgreSQL User Group.
PostgreSQL 14 Administration Cookbook
Simon Riggs & Gianni Ciolli · Packt · 608 pages · ~15 hrs to read
Over 175 task-oriented recipes for the DBA side of PostgreSQL — monitoring, replication for high availability, security, and fine-tuning — written by a major contributor to the PostgreSQL project itself.
Mastering PostgreSQL in Application Development
Dimitri Fontaine · self-published · 332 pages · ~8 hrs to read
A companion to Fontaine's The Art of PostgreSQL that leans further into application-side patterns — using PostgreSQL as more than a dumb data store. Written for developers, not DBAs.
PostgreSQL resources