name | setting | source | short_desc -------------------------------------+------------+--------------------+------------------------------------------------------------------------------------------- autovacuum | on | configuration file | Starts the autovacuum subprocess. autovacuum_analyze_scale_factor | 0.05 | configuration file | Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples. autovacuum_analyze_threshold | 100 | configuration file | Minimum number of tuple inserts, updates, or deletes prior to analyze. autovacuum_freeze_max_age | 1000000000 | configuration file | Age at which to autovacuum a table to prevent transaction ID wraparound. autovacuum_max_workers | 10 | configuration file | Sets the maximum number of simultaneously running autovacuum worker processes. autovacuum_multixact_freeze_max_age | 1200000000 | configuration file | Multixact age at which to autovacuum a table to prevent multixact wraparound. autovacuum_naptime | 60 | default | Time to sleep between autovacuum runs. autovacuum_vacuum_cost_delay | 5 | configuration file | Vacuum cost delay in milliseconds, for autovacuum. autovacuum_vacuum_cost_limit | -1 | default | Vacuum cost amount available before napping, for autovacuum. autovacuum_vacuum_scale_factor | 0.02 | configuration file | Number of tuple updates or deletes prior to vacuum as a fraction of reltuples. autovacuum_vacuum_threshold | 1000 | configuration file | Minimum number of tuple updates or deletes prior to vacuum. autovacuum_work_mem | -1 | default | Sets the maximum memory to be used by each autovacuum worker process. log_autovacuum_min_duration | 30000 | configuration file | Sets the minimum execution time above which autovacuum actions will be logged. (13 rows)