· 6 min · PostgreSQL

All Your GUCs in a Row: port

Tall ship with billowed sails docked at a medieval European harbor, crew members on deck and rigging, spectators on the wharf, cityscape with church spires in background. The `port` parameter does double duty: it names the TCP socket and the Unix socket file too.

0 comments

· 6 min · PostgreSQL

The Patch Is Coming From Inside the House

On August 25, Robert Haas opened a pgsql-hackers thread like this:

0 comments

· 7 min · PostgreSQL

All Your GUCs in a Row: plan_cache_mode

Mallard duck pecking at a coffee mug half-buried in dirt and grass. Override PostgreSQL's prepared statement plan choice when its cost estimates go wrong on skewed data.

0 comments

· 7 min · PostgreSQL

All Your GUCs in a Row: password_encryption

Anthropomorphic duck in U.S. Army officer uniform operating a typewriter at a vintage military desk with maps, recruiting poster, and communication equipment in background. What `password_encryption` actually controls: how PostgreSQL hashes new passwords when you hand it clear text.

0 comments

· 7 min · PostgreSQL

All Your GUCs in a Row: parallel_setup_cost and parallel_tuple_cost

A taxidied duck stands on a workbench in a weaving studio surrounded by wooden looms, spools of thread, and a handwritten sign reading "WHY IS THIS SO HARD". 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 · 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

· 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)

Duck walking across a cracked and potholed concrete sidewalk in an empty European street lined with weathered apartment buildings. 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