The Garden of Forking Paths
Most projects inherit their license like a default shell and never reconsider it.
All Your GUCs in a Row: num_os_semaphores
PostgreSQL 18's new `num_os_semaphores` preset reports how many OS semaphores the server needs—a formula that drifted wrong for twelve years until the…
The Deep End
Dive deeper into connection pooling with five more PostgreSQL poolers: Odyssey, pgagroal, Supavisor, PgDoorman, and ProxySQL, plus where your cloud already…
All Your GUCs in a Row: notify_buffers
The `notify_buffers` GUC tunes a 128kB cache for PostgreSQL's LISTEN/NOTIFY queue—and almost never matters.
Everyone into the Pool
PostgreSQL's simple one-process-per-connection model is expensive.
The Vector That Lied About Its Dimensions
A vector index build in pgvector 0.8.6 and earlier trusted a vector's header over the column's dimension count, allowing out-of-bounds writes.
All Your GUCs in a Row: multixact_member_buffers and multixact_offset_buffers
When one long transaction holds row locks on thousands of parents, multixact cache misses can tank insert throughput.
All Your GUCs in a Row: min_wal_size
`min_wal_size` sets a floor under WAL recycling, not a retention policy—confusing many operators who lose standbys when the floor causes segments to be…
All Your GUCs in a Row: min_parallel_index_scan_size and min_parallel_table_scan_size
Parallel scans need a minimum table or index size to be considered—but that minimum also sets the bottom rung of the ladder the planner climbs to decide how…
Nobody Patches the Pooler
PgBouncer 1.26.0 patches three CVEs, two triggerable without authentication.