A Parade of Horribles, in Serial Order
Sooner or later, someone on the team reads about write skew. It is an unsettling read: two transactions, each correct on its own, each looking at data the other
All Your GUCs in a Row: primary_conninfo
`primary_conninfo` tells a standby where to stream WAL from—but only after the archive and pg_wal run dry.
All Your GUCs in a Row: post_auth_delay and pre_auth_delay
Debugging PostgreSQL connections requires stopping a backend before it does anything interesting.
All Your GUCs in a Row: port
The `port` parameter does double duty: it names the TCP socket and the Unix socket file too.
The Patch Is Coming From Inside the House
On August 25, Robert Haas opened a pgsql-hackers thread like this:
All Your GUCs in a Row: plan_cache_mode
Override PostgreSQL's prepared statement plan choice when its cost estimates go wrong on skewed data.
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.