PgQue's zero-mutation queue algorithm eliminates the "queue death spiral" by replacing UPDATE-and-DELETE with snapshot diffing.

Autovacuum_freeze_max_age prevents PostgreSQL's xid wraparound catastrophe.

Autovacuum's ANALYZE threshold formula combines a fixed floor and a percentage of table size.

If you have ever run pg_ctl stop -m fast on a primary and watched it hang well past wal_sender_shutdown_timeout, you have met a bug that has been sitting in wal

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.