PostgreSQL 17 Documentation

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 compact reference with working examples: data types, window functions, common table expressions, JSON support, triggers, PL/pgSQL, backups, roles, and high availability.

GoalKicker

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