PostgreSQL Notes for Professionals

A small book for your first steps with PostgreSQL. It covers installation on Linux and Windows, writing queries on a demo database, transactions, basic server setup, and useful extensions.

Pavel Luzanov, Egor Rogov and Igor Levshin

A deep look at how PostgreSQL works under the hood. It explains isolation and MVCC, the buffer cache and WAL, locks, query execution and planning, and every index type from B-tree to BRIN.

Egor Rogov

The official PostgreSQL manual in a single file. It includes the tutorial, the full SQL language reference, server administration, client interfaces, and server programming.

PostgreSQL Global Development Group