· 6 min · PostgreSQL

All Your GUCs in a Row: parallel_leader_participation

Ducks wearing numbered racing bibs walk down a paved road lined with spectators under trees. Whether your query's leader process joins the work or just supervises depends on this boolean, and the performance question it settles is subtle.

0 comments

· 7 min · PostgreSQL

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…

0 comments

· 6 min · FOSSLaw, PostgreSQL

Portions Copyright

PostgreSQL's copyright notice names a group that isn't a legal entity, and nobody signs anything.

0 comments

· 6 min · PostgreSQL

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.

0 comments

· 11 min · PostgreSQL

The International Ice Patrol

Animated characters dressed as naval officers scanning the ocean from a ship's bridge with binoculars at dusk. 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

0 comments

· 6 min

All Your GUCs in a Row: oauth_validator_libraries

Illustration of three anthropomorphic ducks in tuxedos juggling keys on a circus stage with striped tent backdrop and spotlight lighting. PostgreSQL 18's OAuth support delegates token validation to third-party libraries.

0 comments

· 13 min · FOSSLaw

The Garden of Forking Paths

Most projects inherit their license like a default shell and never reconsider it.

0 comments

· 5 min · PostgreSQL

All Your GUCs in a Row: num_os_semaphores

Five cartoon birds with halos and wings standing in a row on sand, with colored directional signs spelling "QUACK" above them and a white picket fence in the background. 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…

0 comments

· 13 min · PostgreSQL

The Deep End

Loch Ness Monster emerging from a swimming pool surrounded by ducks, with pool ladder and facilities visible in the background. Dive deeper into connection pooling with five more PostgreSQL poolers: Odyssey, pgagroal, Supavisor, PgDoorman, and ProxySQL, plus where your cloud already…

0 comments

· 6 min · PostgreSQL

All Your GUCs in a Row: notify_buffers

A mallard duck holds a smartphone displaying a list of "Quack" entries, looking at the screen. The `notify_buffers` GUC tunes a 128kB cache for PostgreSQL's LISTEN/NOTIFY queue—and almost never matters.

0 comments