diff options
| author | Melanie Plageman <melanieplageman@gmail.com> | 2025-01-13 15:21:04 -0500 |
|---|---|---|
| committer | Melanie Plageman <melanieplageman@gmail.com> | 2025-01-13 15:21:04 -0500 |
| commit | af2317652d5daf8b382cc65936731c4a3c0aaa4c (patch) | |
| tree | ea21c13824cadffd4fbc6f3ca0f36ed0bf8fdb77 | |
| parent | 1c854eb8931a8ce2ba8e2cc4d0a209a45d836de5 (diff) | |
| download | postgresql-af2317652d5daf8b382cc65936731c4a3c0aaa4c.tar.gz postgresql-af2317652d5daf8b382cc65936731c4a3c0aaa4c.zip | |
Reorder vacuum GUCs in postgresql.conf.sample to match docs
ca9c6a5680d consolidated most of vacuum-related GUCs' documentation into
a new subsection. It neglected, however, to reorganize
postgresql.conf.sample to match the new order. Do this now.
Reported-by: Álvaro Herrera
Discussion: https://postgr.es/m/202501110902.5banlseavz7c%40alvherre.pgsql
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 34 |
1 files changed, 19 insertions, 15 deletions
diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index b2bc43383db..079efa1baa7 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -185,14 +185,6 @@ #max_files_per_process = 1000 # min 64 # (change requires restart) -# - Cost-Based Vacuum Delay - - -#vacuum_cost_delay = 0 # 0-100 milliseconds (0 disables) -#vacuum_cost_page_hit = 1 # 0-10000 credits -#vacuum_cost_page_miss = 2 # 0-10000 credits -#vacuum_cost_page_dirty = 20 # 0-10000 credits -#vacuum_cost_limit = 200 # 1-10000 credits - # - Background Writer - #bgwriter_delay = 200ms # 10-10000ms between rounds @@ -656,9 +648,11 @@ #------------------------------------------------------------------------------ -# AUTOVACUUM +# VACUUMING #------------------------------------------------------------------------------ +# - Automatic Vacuuming - + #autovacuum = on # Enable autovacuum subprocess? 'on' # requires track_counts to also be on. autovacuum_worker_slots = 16 # autovacuum worker slots to allocate @@ -688,6 +682,22 @@ autovacuum_worker_slots = 16 # autovacuum worker slots to allocate # autovacuum, -1 means use # vacuum_cost_limit +# - Cost-Based Vacuum Delay - + +#vacuum_cost_delay = 0 # 0-100 milliseconds (0 disables) +#vacuum_cost_page_hit = 1 # 0-10000 credits +#vacuum_cost_page_miss = 2 # 0-10000 credits +#vacuum_cost_page_dirty = 20 # 0-10000 credits +#vacuum_cost_limit = 200 # 1-10000 credits + +# - Freezing - + +#vacuum_freeze_table_age = 150000000 +#vacuum_freeze_min_age = 50000000 +#vacuum_failsafe_age = 1600000000 +#vacuum_multixact_freeze_table_age = 150000000 +#vacuum_multixact_freeze_min_age = 5000000 +#vacuum_multixact_failsafe_age = 1600000000 #------------------------------------------------------------------------------ # CLIENT CONNECTION DEFAULTS @@ -722,12 +732,6 @@ autovacuum_worker_slots = 16 # autovacuum worker slots to allocate #lock_timeout = 0 # in milliseconds, 0 is disabled #idle_in_transaction_session_timeout = 0 # in milliseconds, 0 is disabled #idle_session_timeout = 0 # in milliseconds, 0 is disabled -#vacuum_freeze_table_age = 150000000 -#vacuum_freeze_min_age = 50000000 -#vacuum_failsafe_age = 1600000000 -#vacuum_multixact_freeze_table_age = 150000000 -#vacuum_multixact_freeze_min_age = 5000000 -#vacuum_multixact_failsafe_age = 1600000000 #bytea_output = 'hex' # hex, escape #xmlbinary = 'base64' #xmloption = 'content' |