|
185 | 185 | #max_files_per_process = 1000# min 64 |
186 | 186 | # (change requires restart) |
187 | 187 |
|
188 | | -# - Cost-Based Vacuum Delay - |
189 | | - |
190 | | -#vacuum_cost_delay = 0# 0-100 milliseconds (0 disables) |
191 | | -#vacuum_cost_page_hit = 1# 0-10000 credits |
192 | | -#vacuum_cost_page_miss = 2# 0-10000 credits |
193 | | -#vacuum_cost_page_dirty = 20# 0-10000 credits |
194 | | -#vacuum_cost_limit = 200# 1-10000 credits |
195 | | - |
196 | 188 | # - Background Writer - |
197 | 189 |
|
198 | 190 | #bgwriter_delay = 200ms# 10-10000ms between rounds |
|
656 | 648 |
|
657 | 649 |
|
658 | 650 | #------------------------------------------------------------------------------ |
659 | | -#AUTOVACUUM |
| 651 | +#VACUUMING |
660 | 652 | #------------------------------------------------------------------------------ |
661 | 653 |
|
| 654 | +# - Automatic Vacuuming - |
| 655 | + |
662 | 656 | #autovacuum = on# Enable autovacuum subprocess? 'on' |
663 | 657 | # requires track_counts to also be on. |
664 | 658 | autovacuum_worker_slots = 16# autovacuum worker slots to allocate |
@@ -688,6 +682,22 @@ autovacuum_worker_slots = 16# autovacuum worker slots to allocate |
688 | 682 | # autovacuum, -1 means use |
689 | 683 | # vacuum_cost_limit |
690 | 684 |
|
| 685 | +# - Cost-Based Vacuum Delay - |
| 686 | + |
| 687 | +#vacuum_cost_delay = 0# 0-100 milliseconds (0 disables) |
| 688 | +#vacuum_cost_page_hit = 1# 0-10000 credits |
| 689 | +#vacuum_cost_page_miss = 2# 0-10000 credits |
| 690 | +#vacuum_cost_page_dirty = 20# 0-10000 credits |
| 691 | +#vacuum_cost_limit = 200# 1-10000 credits |
| 692 | + |
| 693 | +# - Freezing - |
| 694 | + |
| 695 | +#vacuum_freeze_table_age = 150000000 |
| 696 | +#vacuum_freeze_min_age = 50000000 |
| 697 | +#vacuum_failsafe_age = 1600000000 |
| 698 | +#vacuum_multixact_freeze_table_age = 150000000 |
| 699 | +#vacuum_multixact_freeze_min_age = 5000000 |
| 700 | +#vacuum_multixact_failsafe_age = 1600000000 |
691 | 701 |
|
692 | 702 | #------------------------------------------------------------------------------ |
693 | 703 | # CLIENT CONNECTION DEFAULTS |
@@ -722,12 +732,6 @@ autovacuum_worker_slots = 16# autovacuum worker slots to allocate |
722 | 732 | #lock_timeout = 0# in milliseconds, 0 is disabled |
723 | 733 | #idle_in_transaction_session_timeout = 0# in milliseconds, 0 is disabled |
724 | 734 | #idle_session_timeout = 0# in milliseconds, 0 is disabled |
725 | | -#vacuum_freeze_table_age = 150000000 |
726 | | -#vacuum_freeze_min_age = 50000000 |
727 | | -#vacuum_failsafe_age = 1600000000 |
728 | | -#vacuum_multixact_freeze_table_age = 150000000 |
729 | | -#vacuum_multixact_freeze_min_age = 5000000 |
730 | | -#vacuum_multixact_failsafe_age = 1600000000 |
731 | 735 | #bytea_output = 'hex'# hex, escape |
732 | 736 | #xmlbinary = 'base64' |
733 | 737 | #xmloption = 'content' |
|