Portions Copyright
PostgreSQL's copyright notice names a group that isn't a legal entity, and nobody signs anything.
All Your GUCs in a Row: array_nulls (Special Update)
Tom Lane deleted `array_nulls` in PostgreSQL 20, but `pg_dump` never set it, so restores into databases with it disabled silently corrupt text arrays.
The International Ice Patrol
On September 30, AWS announced that Aurora PostgreSQL can now query Apache Iceberg and Parquet data directly. That brings the number of things a vendor might me
All Your GUCs in a Row: oauth_validator_libraries
PostgreSQL 18's OAuth support delegates token validation to third-party libraries.
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.