· 5 min · PostgreSQL

All Your GUCs in a Row: maintenance_work_mem

Steampunk-style illustration of ducks operating an industrial factory with copper pipes, steam vents, pressure gauges, and hanging pendant lights. Unlock faster index builds and vacuum operations by understanding maintenance_work_mem: PostgreSQL's one-allocation memory budget that actually behaves like…

0 comments

· 4 min · PostgreSQL

All Your GUCs in a Row: maintenance_io_concurrency

Row of ducks wearing yellow hard hats and green safety vests stand on a construction site with cranes and building materials in the background. Discover which PostgreSQL maintenance tasks actually use `maintenance_io_concurrency`—the answer is wider and more surprising than the name suggests, and…

0 comments

· 5 min · PostgreSQL

All Your GUCs in a Row: logical_decoding_work_mem

Photograph of a mahogany library desk with handwritten manuscript, brass lamp with green shade, taxidermied duck, leather-bound books, and brass magnifying glasses, against floor-to-ceiling bookshelves and stained-glass window. Logical decoding holds uncommitted transactions in memory until commit—and when they get too big, PostgreSQL spills them to disk.

0 comments

· 3 min · PostgreSQL

All Your GUCs in a Row: log_parser_stats, log_planner_stats, log_executor_stats, and log_statement_stats

Duck holding a forest ecology survey sheet, surrounded by data tables and stacked papers on a log in a wooded setting. PostgreSQL's oldest logging parameters measure CPU time, page faults, and context switches per statement—crude but irreplaceable when you need to know why a…

0 comments

· 7 min · PostgreSQL

All Your GUCs in a Row: log_startup_progress_interval and log_recovery_conflict_waits

Mallard duck standing on a wooden log-shaped riding mower in a backyard lawn. Track WAL replay progress on a primary, or diagnose why a standby stalled—two GUCs for the same startup question, answered only in the server log.

0 comments

· 4 min · PostgreSQL

All Your GUCs in a Row: log_lock_waits and log_lock_failures

Duck wearing a wristwatch stands in front of a wooden log cabin door with multiple padlocks, other log buildings visible in background. log_lock_waits is the cheapest lock-contention detector PostgreSQL ships, and through version 18 it is off by default. Turn it on. PostgreSQL 19 will do it for

0 comments

· 3 min · PostgreSQL

All Your GUCs in a Row: log_replication_commands

Steampunk illustration of a brass and iron steam engine with gears and pipes billowing white smoke, processing logs on a conveyor belt in a wooden workshop, with a mallard duck perched nearby. log_replication_commands is log_statement = all for walsenders, with the one difference that you should turn it on.

0 comments

· 4 min · PostgreSQL

All Your GUCs in a Row: log_min_duration_sample, log_statement_sample_rate, and log_transaction_sample_rate

Anthropomorphic white duck wearing jeweler's loupe and apron, examining gemstones at a workbench with tools, jewelry display cases, and a desk lamp in a warm workshop setting. Aggregate query statistics hide the forest of cheap queries.

0 comments

· 6 min · PostgreSQL

All Your GUCs in a Row: log_parameter_max_length and log_parameter_max_length_on_error

Anthropomorphic white eagle wearing safety glasses and work apron measures a log with a tape measure at a woodworking bench surrounded by hand tools. Control what bind parameters PostgreSQL logs alongside statements and errors.

0 comments

· 5 min · PostgreSQL

All Your GUCs in a Row: log_min_messages, log_min_error_statement, and log_error_verbosity

Duck surrounded by continuous computer printout paper spilling from a line printer in a data center, with control panels and indicator lights visible in background. Three parameters control what reaches your server log: a severity floor, whether to attach the triggering SQL, and how many fields each message prints.

0 comments