The Patch Is Coming From Inside the House
On August 25, Robert Haas opened a pgsql-hackers thread like this:
plan_cache_mode
Override PostgreSQL's prepared statement plan choice when its cost estimates go wrong on skewed data.
password_encryption
What `password_encryption` actually controls: how PostgreSQL hashes new passwords when you hand it clear text.
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…
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.
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.
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
oauth_validator_libraries
PostgreSQL 18's OAuth support delegates token validation to third-party libraries.