//
Search across all documentation pages
10 pages in this section.
The mental model behind PostgreSQL: how a cluster, database, schema, and table relate, how a query actually executes, and why the engine is built to be extended rather than replaced.
Learn PostgreSQL fundamentals with 10 examples. Understand clusters, databases, schemas, and tables, and connect to, create, and query data.
Explore PostgreSQL's multi-process architecture, including postmaster, backends, and background workers. Learn how they impact connections, memory, and restarts.
Explore PostgreSQL system catalogs like pg_catalog and information_schema to discover database metadata, schemas, tables, and constraints.
Understand PostgreSQL databases, schemas, and search_path. Learn how to manage object namespaces and resolve unqualified names to prevent bugs.
Understand PostgreSQL's major and minor releases, 5-year support, and End-of-Life planning. Learn upgrade strategies and policy setting.
Learn PostgreSQL best practices for version management, schema design, and operational mindset. Ensure supported versions, clear namespaces, and robust operations.
A single-page roundup of every highlight bullet from the 9 pages in the Fundamentals section, grouped by source page so you can scan all 52 takeaways without opening each article individually.