Skip to content

PostgreSQL GUC Encyclopedia

Every core PostgreSQL configuration parameter observed from 9.0 through 19 Beta 3, with history, defaults, mechanisms, tuning guidance, and Pigsty context.

This is the working index of PostgreSQL configuration parameters—not a marketing landing page. Start with a parameter, compare major versions, or inspect exactly where Pigsty diverges from upstream defaults.

PostgreSQL scope Value9.0–19 Beta 3
17 measured release points; 19 Beta 3 is pre-GA
Unique parameters Value447
Union of every observed pg_settings.name, including removed parameters
Languages ValueEnglish · 中文
English is canonical; translations share routes and heading IDs
Evidence ValueDocker · PostgreSQL docs · Git · Pigsty
Facts retain source version, path, and verification status

Browse

  • Parameters — identity, lifecycle, defaults, mechanism, tuning, pitfalls, and references.
  • Version diffs — added, removed, and default-changing parameters between adjacent majors.
  • Pigsty defaults — the OLTP, OLAP, CRIT, and TINY template matrix.
  • Methodology — evidence labels, lifecycle rules, and terminology.
  • Full JSONL export — one normalized record per parameter.

Representative dossiers

  • shared_buffers — memory units, a real boot-default transition, and a resource-sized Pigsty value.
  • wal_level — enum semantics, restart scope, and cross-parameter constraints.
  • wal_keep_segments — a removed parameter and its PG13 replacement.
Note

Fact boundary. Values labelled as facts come from measured pg_settings, verified official anchors, Git history, or pinned Pigsty source. Tuning recommendations are explicitly advice; Pigsty rationale remains marked for human review until approved.

Warning

PostgreSQL 19 Beta 3 is a prerelease snapshot. Its parameter set, defaults, and behavior can change before PostgreSQL 19 GA; do not use the beta dossiers as production compatibility guarantees.

Parameters

Complete dossiers for all 447 core PostgreSQL configuration parameters observed from 9.0 through 19 Beta 3.

Version diffs

GUCs added, removed, or changed in boot default between adjacent PostgreSQL majors.

Pigsty defaults

Complete OLTP, OLAP, CRIT, and TINY template deltas from upstream PostgreSQL boot defaults.

Methodology and terminology

Evidence boundaries, lifecycle rules, default-value semantics, Pigsty fixtures, and the bilingual glossary used across the GUC Atlas.

Last modified 2026-09-11