PostgreSQL Wait Event Atlas

A bilingual, operator-grade catalogue of PostgreSQL core wait events for PG13–18. English is the default language; Simplified Chinese pages live at /zh/. The site uses OINK v1.0.0 as a pinned Hugo Module.

The published content tree is intentionally rooted at /: there is no landing page and no /docs/ URL prefix. Source Markdown remains under content/docs/ so it keeps OINK's documentation shell, sidebar, search, print, Markdown, and agent outputs.

Evidence model

• PG13–16 inventories are parsed from the official monitoring documentation.
• PG17–18 inventories are queried from clean Docker instances through pg_wait_events and cross-checked against the official tables.
• facts/wait_event_matrix.* preserves every exact (type,name) identity and explicit rename/type-move metadata.
• facts/source_audit.json pins source tags, commits, file:line evidence, and dormant catalog-only exceptions.
• data/wait_events.jsonl contains 281 enriched core dossiers plus the single Extension mechanism placeholder used to generate bilingual pages.
• Diagnostic SQL is read-only, stored structurally in JSONL, and executed in both PG17 and PG18 containers.

The exact audited source releases are 13.23, 14.24, 15.19, 16.15, 17.11, and 18.6. IPC/WalReceiverUpstreamCatchup is explicitly patch-scoped because it first appears in 17.11 and 18.6 rather than the initial major releases.

Build

Requirements: Go 1.27+, Hugo Extended 0.165.0+, Python 3 with lxml and requests, Docker, and the PostgreSQL source trees expected by scripts/map_source_locations.py.

make catalogue
make support
make sql
make build

Preview:

make serve

The strict production build promotes warnings to errors. scripts/audit_catalogue.py checks counts, translations, source evidence, links, JSONL schema, and rendered route parity.

Repository map

content/docs/              bilingual OINK content and generated dossiers
data/wait_events.jsonl     enriched canonical data deliverable
facts/                     raw extracts, matrix, manifests, source and SQL evidence
scripts/                   deterministic extraction, generation, and audit pipeline
static/data/               downloadable copies published by the site
assets/                    site theme overrides, matrix includes, and brand assets

Custom extension-registered wait names are out of scope. The site includes one mechanism page explaining how to investigate them on the local instance.