2026-06-01
· 5 min
·
PostgreSQL
PostgreSQL 19 adds GRAPH_TABLE, letting you query property graphs with Cypher-like pattern matching over your existing relational tables.
0 comments
2026-05-31
· 3 min
·
PostgreSQL
Skip partition scanning with constraint_exclusion, PostgreSQL's old pruning trick.
0 comments
2026-05-30
· 2 min
·
PostgreSQL
PostgreSQL's `config_file` parameter creates a bootstrap paradox: it tells the server where to find its configuration, but lives on the command line only—never…
0 comments
2026-05-29
· 3 min
·
PostgreSQL
PostgreSQL 14 unified query-id computation across all subsystems, but defaulting to always-on would tax every backend.
0 comments
2026-05-29
· 6 min
·
PostgreSQL
PostgreSQL finally has an open-source Transparent Data Encryption option.
0 comments
2026-05-28
· 2 min
·
PostgreSQL
PostgreSQL 17 made SLRU buffer pools configurable for the first time.
0 comments
2026-05-28
· 5 min
·
PostgreSQL
Three heap buffer overflows in PostgreSQL — including a 20-year-old pgcrypto bug — were found by an AI code analyzer. But.
0 comments
2026-05-27
· 3 min
·
PostgreSQL
Tune `commit_delay` to batch WAL flushes and trade latency for throughput—but only if `pg_test_fsync` proves sync time is your bottleneck.
0 comments
2026-05-27
· 5 min
·
PostgreSQL
PostgreSQL 19 brings REPACK CONCURRENTLY, a native alternative to pg_repack that rewrites tables without crippling locks.
0 comments
2026-05-26
· 3 min
·
PostgreSQL
cluster_name looks like a cosmetic label for process listings, but on a standby it silently becomes the name your primary uses to verify synchronous…
0 comments