Open-Source TDE for PostgreSQL: What pg_tde Is, and Whether You Need It
PostgreSQL finally has an open-source Transparent Data Encryption option.
pg_tde Is, and Whether You Need Itcommit_timestamp_buffers
PostgreSQL 17 made SLRU buffer pools configurable for the first time.
Three heap buffer overflows in PostgreSQL — including a 20-year-old pgcrypto bug — were found by an AI code analyzer. But.
commit_delay and commit_siblings
Tune `commit_delay` to batch WAL flushes and trade latency for throughput—but only if `pg_test_fsync` proves sync time is your bottleneck.
PostgreSQL 19 brings REPACK CONCURRENTLY, a native alternative to pg_repack that rewrites tables without crippling locks.
cluster_name
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…
Fourth in a series of dispassionate tours of managed PostgreSQL services. Previously: RDS, Aurora, and Cloud SQL. AlloyDB is Google’s distributed-storage Postgr
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…
client_min_messages
`client_min_messages` controls what your session sees, not what the server logs—a confusion that spawns most of its trouble.
client_connection_check_interval
PostgreSQL 14 added a parameter that detects dead client connections during query execution, stopping wasted work before it's too late.