Comprehensive PostgreSQL reference for developers and DBAs covering versions 14–18. Use whenever the user asks about PostgreSQL syntax, DDL/DML/DQL, joins, LATERAL, CTEs, window functions, GROUPING SETS, DISTINCT ON, RETURNING, ON CONFLICT, PL/pgSQL, functions, procedures, triggers, views, materialized views, indexes (B-tree/GIN/GiST/BRIN/Hash/Bloom), MVCC, VACUUM, autovacuum, WAL, TOAST, partitioning, replication (streaming/logical), backup, PITR, HA (Patroni/repmgr), pgBouncer, EXPLAIN ANALYZE, RLS, roles, extensions (pgvector, PostGIS, TimescaleDB, Citus, pg_trgm, pg_cron), JSON/JSONB, full-text search, UUID, timestamptz, COPY, system catalogs, collations, large objects, cursors, GUC, or any Postgres administration, performance, security, replication, backup, or recovery topic.
94
94%
Does it follow best practices?
Impact
94%
1.36xAverage score across 3 eval scenarios
Passed
No known issues
RLS response format compliance
Lead with SQL
0%
0%
Version-pinned URLs
100%
100%
Version admonition format
0%
100%
PG16 as SQL baseline
100%
100%
Provider-neutral managed limitations
0%
100%
BYPASSRLS superuser caveat
100%
100%
FORCE ROW LEVEL SECURITY
100%
100%
USING vs WITH CHECK
100%
100%
Section headers match references
50%
62%
Source links present
100%
100%
NVMe slow query investigation
NVMe random_page_cost
100%
100%
EXPLAIN ANALYZE BUFFERS
100%
100%
pg_stat_statements usage
100%
100%
CREATE STATISTICS recommendation
0%
100%
pg_stats not pg_statistic
100%
100%
pg_class filtered by relkind
62%
37%
Version-pinned URLs
0%
100%
PG16 baseline SQL
100%
100%
EXPLAIN bottom-up reading
0%
100%
Misestimate 10x threshold
0%
100%
pgvector semantic search setup
Extension named 'vector'
100%
100%
HNSW index chosen
100%
100%
Cosine opclass used
100%
100%
halfvec for memory savings
100%
100%
Iterative scan for filtered ANN
100%
100%
Provider-neutral managed phrasing
0%
100%
One opclass per index
100%
100%
ef_search / probes tuning
100%
100%
HNSW build memory
100%
100%
PG16 baseline SQL
100%
100%