On 2025-Jan-13, Melanie Plageman wrote: > I've gone with VACUUM_AUTOVACUUM, VACUUM_COST_DELAY, and > VACUUM_FREEZING, but I am open to feedback.
Looks good to me. I checked these two queries, whose results appear correct: 55432 18devel 560655=# select name, category from pg_settings where category ilike '%vacuum%'; name │ category ───────────────────────────────────────┼───────────────────────────────────── autovacuum │ Vacuuming / Automatic Vacuuming autovacuum_analyze_scale_factor │ Vacuuming / Automatic Vacuuming autovacuum_analyze_threshold │ Vacuuming / Automatic Vacuuming autovacuum_freeze_max_age │ Vacuuming / Automatic Vacuuming autovacuum_max_workers │ Vacuuming / Automatic Vacuuming autovacuum_multixact_freeze_max_age │ Vacuuming / Automatic Vacuuming autovacuum_naptime │ Vacuuming / Automatic Vacuuming autovacuum_vacuum_cost_delay │ Vacuuming / Automatic Vacuuming autovacuum_vacuum_cost_limit │ Vacuuming / Automatic Vacuuming autovacuum_vacuum_insert_scale_factor │ Vacuuming / Automatic Vacuuming autovacuum_vacuum_insert_threshold │ Vacuuming / Automatic Vacuuming autovacuum_vacuum_scale_factor │ Vacuuming / Automatic Vacuuming autovacuum_vacuum_threshold │ Vacuuming / Automatic Vacuuming autovacuum_worker_slots │ Vacuuming / Automatic Vacuuming vacuum_cost_delay │ Vacuuming / Cost-Based Vacuum Delay vacuum_cost_limit │ Vacuuming / Cost-Based Vacuum Delay vacuum_cost_page_dirty │ Vacuuming / Cost-Based Vacuum Delay vacuum_cost_page_hit │ Vacuuming / Cost-Based Vacuum Delay vacuum_cost_page_miss │ Vacuuming / Cost-Based Vacuum Delay vacuum_failsafe_age │ Vacuuming / Freezing vacuum_freeze_min_age │ Vacuuming / Freezing vacuum_freeze_table_age │ Vacuuming / Freezing vacuum_multixact_failsafe_age │ Vacuuming / Freezing vacuum_multixact_freeze_min_age │ Vacuuming / Freezing vacuum_multixact_freeze_table_age │ Vacuuming / Freezing 55432 18devel 560655=# select name, category from pg_settings where (short_desc ilike '%vacuum%' or extra_desc ilike '%vacuum%') and category not ilike '%vacuum%'; name │ category ─────────────────────────────┼───────────────────────────────────── autovacuum_work_mem │ Resource Usage / Memory log_autovacuum_min_duration │ Reporting and Logging / What to Log maintenance_work_mem │ Resource Usage / Memory vacuum_buffer_usage_limit │ Resource Usage / Memory -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/ "That sort of implies that there are Emacs keystrokes which aren't obscure. I've been using it daily for 2 years now and have yet to discover any key sequence which makes any sense." (Paul Thomas)