Disable autovacuum and PostgreSQL will cheerfully show you every failure mode in its playbook, from table bloat to transaction ID wraparound.

PostgreSQL 19 is an admin-and-monitoring release with 212 items: worker-managed AIO, smarter planner joins, faster diagnostics, and a C11 requirement.

PGX is stepping in to maintain pgBackRest as pgxbackup, ensuring critical fixes and PostgreSQL compatibility for the industry-standard backup tool.

Unauthenticated TCP connections consume backend slots until they log in or hit authentication_timeout.

pgvectorscale brings DiskANN's memory-efficient graph design to PostgreSQL, cutting vector search latency 9× versus HNSW when your index doesn't fit in RAM.

PHP 9.0 is ditching its dual custom licenses for the standard 3-clause BSD license.

pgBackRest is unmaintained. Here's what to do next: an honest evaluation of Barman, WAL-G, and the realistic alternatives for production PostgreSQL backups.

Control whether unquoted NULL in array literals becomes a SQL null or the string "NULL".

PostgreSQL 18 shipped async I/O but left operators with a single static knob.

PostgreSQL 19 ships a built-in REPACK command that defrags bloated tables without exclusive locks. We measure the real cost and survey the caveats.