postgres

Scope

Covers PostgreSQL itself: schema and type selection, constraints, indexes and index maintenance, plan reading and query rewriting, transactions and locking, MVCC and vacuum, row-level security, online schema change, connection limits and pooling, JSONB, built-in full-text search, pgvector, and the catalogue queries that answer "why is it slow".

The body is written against PostgreSQL 18 (current stable; 18.6 at time of writing). Rules that need a newer server than 14 carry a gate such as (PG 15+). Nothing here assumes 19, which is still in beta.

Not covered: