2026-05-06
· 3 min
·
PostgreSQL
Autovacuum's three key parameters work together to control when it runs, how hard, and how it throttles itself.
0 comments
2026-05-06
· 2 min
·
PostgreSQL
When your database catches fire, panic is optional. Learn seven battle-tested rules that turn chaos into a coordinated response.
0 comments
2026-05-06
· 4 min
·
PostgreSQL
PostgreSQL 19 eliminates the 32-bit MultiXactOffset ceiling that has crashed high-concurrency FK-heavy clusters at 3 a.m.
0 comments
2026-05-06
· 5 min
·
PostgreSQL
Most organizations that build data lakes don't need them.
0 comments
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