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
2026-05-26
· 16 min
·
PostgreSQL
Fourth in a series of dispassionate tours of managed PostgreSQL services. Previously: RDS, Aurora, and Cloud SQL. AlloyDB is Google’s distributed-storage Postgr
0 comments
2026-05-26
· 3 min
·
PostgreSQL
A 1990s-vintage PostgreSQL extension shipping a critical buffer overflow in 2026 reveals a larger problem: most teams can't even say what's actually installed…
0 comments
2026-05-25
· 3 min
·
PostgreSQL
`client_min_messages` controls what your session sees, not what the server logs—a confusion that spawns most of its trouble.
0 comments