All Your GUCs in a Row: password_encryption
What `password_encryption` actually controls: how PostgreSQL hashes new passwords when you hand it clear text.
All Your GUCs in a Row: parallel_setup_cost and parallel_tuple_cost
PostgreSQL's parallel query planner charges two fees for going parallel: a setup cost per Gather node and a per-row cost for moving data from workers to…
All Your GUCs in a Row: parallel_leader_participation
Whether your query's leader process joins the work or just supervises depends on this boolean, and the performance question it settles is subtle.
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…