diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2006-08-28 13:37:18 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2006-08-28 13:37:18 +0000 |
| commit | 88b811044322845aabe8362d7f442a04b1c4dbc7 (patch) | |
| tree | 5b576d4f6c131c6789847a3bf2d26a786fceb29d /src/backend/utils/misc/postgresql.conf.sample | |
| parent | ea2e263539df6a7df33e58e44236c504eb268e68 (diff) | |
Turn autovacuum on by default. (stats_row_level is also on by default.)
Threshold and scale factor are cut in half for more aggressive behavior.
Diffstat (limited to 'src/backend/utils/misc/postgresql.conf.sample')
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index fcb81d71188..2793b1e70df 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -59,7 +59,7 @@ # Note: increasing max_connections costs ~400 bytes of shared memory per # connection slot, plus lock space (see max_locks_per_transaction). You # might also need to raise shared_buffers to support more connections. -#superuser_reserved_connections = 2 # (change requires restart) +#superuser_reserved_connections = 3 # (change requires restart) #unix_socket_directory = '' # (change requires restart) #unix_socket_group = '' # (change requires restart) #unix_socket_permissions = 0777 # octal @@ -345,7 +345,7 @@ #stats_start_collector = on # needed for block or row stats # (change requires restart) #stats_block_level = off -#stats_row_level = off +#stats_row_level = on #stats_reset_on_server_start = off # (change requires restart) @@ -361,15 +361,15 @@ # AUTOVACUUM PARAMETERS #--------------------------------------------------------------------------- -#autovacuum = off # enable autovacuum subprocess? +#autovacuum = on # enable autovacuum subprocess? #autovacuum_naptime = 60 # time between autovacuum runs, in secs -#autovacuum_vacuum_threshold = 1000 # min # of tuple updates before +#autovacuum_vacuum_threshold = 500 # min # of tuple updates before # vacuum -#autovacuum_analyze_threshold = 500 # min # of tuple updates before +#autovacuum_analyze_threshold = 250 # min # of tuple updates before # analyze -#autovacuum_vacuum_scale_factor = 0.4 # fraction of rel size before +#autovacuum_vacuum_scale_factor = 0.2 # fraction of rel size before # vacuum -#autovacuum_analyze_scale_factor = 0.2 # fraction of rel size before +#autovacuum_analyze_scale_factor = 0.1 # fraction of rel size before # analyze #autovacuum_vacuum_cost_delay = -1 # default vacuum cost delay for # autovac, -1 means use |