2026-05-05
· 4 min
·
PostgreSQL
PostgreSQL's MultiXact ID space wraps like transaction IDs, and this parameter forces anti-wraparound vacuums before it does.
0 comments
2026-05-05
· 17 min
·
PostgreSQL
·
#Aurora #RDS
Aurora PostgreSQL separates compute from a distributed storage layer that's radically unlike stock PostgreSQL.
0 comments
2026-05-04
· 2 min
·
PostgreSQL
Raising autovacuum_max_workers above 3 won't speed up vacuum unless you also increase autovacuum_vacuum_cost_limit—the I/O budget is divided among workers, not…
0 comments
2026-05-04
· 5 min
·
Client Advisories
Unauthenticated attackers can execute arbitrary SQL against pgBouncer 1.25.0 and earlier in specific configurations.
0 comments
2026-05-04
· 7 min
·
PostgreSQL
PostgreSQL 19 finally makes logical replication and physical standbys work together safely.
0 comments
2026-05-03
· 9 min
·
PostgreSQL
PgQue's zero-mutation queue algorithm eliminates the "queue death spiral" by replacing UPDATE-and-DELETE with snapshot diffing.
0 comments
2026-05-03
· 3 min
·
PostgreSQL
Autovacuum_freeze_max_age prevents PostgreSQL's xid wraparound catastrophe.
0 comments
2026-05-02
· 2 min
·
PostgreSQL
Autovacuum's ANALYZE threshold formula combines a fixed floor and a percentage of table size.
0 comments
2026-05-02
· 4 min
·
PostgreSQL
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
0 comments
2026-05-01
· 3 min
·
PostgreSQL
Disable autovacuum and PostgreSQL will cheerfully show you every failure mode in its playbook, from table bloat to transaction ID wraparound.
0 comments