PostgreSQL Official Documentation Overview

The PostgreSQL 18.0 Documentation is the authoritative reference. This page gives a short roadmap of its structure (tutorials, SQL reference, server administration, etc.) and links to the official site for details.

Version and entry

• Current stable: PostgreSQL 18 — Current docs.
• Other versions (17, 16, 15, …) are available from the same documentation site.

Main sections (summary)

• Preface: What is PostgreSQL, history, conventions.
• Part I – Tutorial: Getting started, SQL language, advanced features.
• Part II – SQL: Syntax, DDL, DML, queries, types, functions, indexes, full-text search, concurrency, performance tips, parallel query.
• Part III – Server administration: Installation, configuration, roles, backup/restore, replication, monitoring, routine maintenance (VACUUM, ANALYZE).
• Parts IV–VII: Client interfaces, server programming, reference, internals, appendices.

For performance and operations, focus on Performance tips, Indexes, Routine maintenance, and Backup and restore in the official docs.