11 stories tagged with #gucs, in publish-time order across the WeSearch catalog. Tag pages update as new stories ingest.
⌘ RSS feed for this tag → or search "Gucs"
Christophe Pettus: All Your GUCs in a Row: The geqo Family
PostgreSQL's genetic query optimizer has seven knobs, but you should probably only touch one. Learn which one, and why the others are best left alone.…
Christophe Pettus: All Your GUCs in a Row: from_collapse_limit
Subqueries in FROM clauses get flattened into the outer query by default—but only if the resulting join problem stays small enough.…
Christophe Pettus: All Your GUCs in a Row: file_extend_method
file_extend_method is an escape hatch wearing the costume of a tuning knob. It exists for one purpose: to let you turn off a PostgreSQL 16 optimization on the filesystems where tha…
Christophe Pettus: All Your GUCs in a Row: cluster_name
cluster_name looks like a cosmetic label for process listings, but on a standby it silently becomes the name your primary uses to verify synchronous……
Christophe Pettus: All Your GUCs in a Row: client_min_messages
`client_min_messages` controls what your session sees, not what the server logs—a confusion that spawns most of its trouble.…
Christophe Pettus: All Your GUCs in a Row: client_connection_check_interval
PostgreSQL 14 added a parameter that detects dead client connections during query execution, stopping wasted work before it's too late.…
Christophe Pettus: All Your GUCs in a Row: checkpoint_timeout and checkpoint_completion_target
PostgreSQL's default 5-minute checkpoint interval wastes I/O on modern servers.…
Christophe Pettus: All Your GUCs in a Row: bytea_output
PostgreSQL's `bytea_output` parameter controls how binary data is formatted when sent to clients: the modern `hex` format (default since 9.0) or the legacy……
Christophe Pettus: All Your GUCs in a Row: bonjour and bonjour_name
PostgreSQL's Bonjour parameters let you advertise a server on the local network via Apple's service-discovery protocol—a clever 2002 idea that hasn't aged well.…
Christophe Pettus: All Your GUCs in a Row: block_size
A parameter you cannot change. block_size lives in the “Preset Options” section of the docs, alongside its read-only cousins like data_checksums, wal_block_size…
Christophe Pettus: All Your GUCs in a Row: bgwriter_lru_maxpages and bgwriter_lru_multiplier
These two parameters close out the bgwriter cluster. Together with bgwriter_delay, they govern how the background writer decides what to write each round, and t…