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
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.
pgBackRest is unmaintained. Here's what to do next: an honest evaluation of Barman, WAL-G, and the realistic alternatives for production PostgreSQL backups.
Autovacuum's ANALYZE threshold formula combines a fixed floor and a percentage of table size.
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".