diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2006-08-29 11:37:47 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2006-08-29 11:37:47 +0000 |
| commit | ba9f9bf1b103d72196d76646c6fcc71abbdd51f5 (patch) | |
| tree | d2da65bb873eb5a572bfe15b8f570cfe1bf3cf8f /src | |
| parent | f443258d4fd19d62dbd5a3b9a5fe8c7f317e237d (diff) | |
| download | postgresql-ba9f9bf1b103d72196d76646c6fcc71abbdd51f5.tar.gz postgresql-ba9f9bf1b103d72196d76646c6fcc71abbdd51f5.zip | |
Revert change to turn autovacuum on by default.
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/utils/misc/guc.c | 16 | ||||
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 14 |
2 files changed, 15 insertions, 15 deletions
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index e6135bc8e75..48487fdc851 100644 --- a/src/backend/utils/misc/guc.c +++ b/src/backend/utils/misc/guc.c @@ -10,7 +10,7 @@ * Written by Peter Eisentraut <peter_e@gmx.net>. * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.344 2006/08/28 13:37:18 petere Exp $ + * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.345 2006/08/29 11:37:47 petere Exp $ * *-------------------------------------------------------------------- */ @@ -707,7 +707,7 @@ static struct config_bool ConfigureNamesBool[] = NULL }, &pgstat_collect_tuplelevel, - true, NULL, NULL + false, NULL, NULL }, { {"stats_block_level", PGC_SUSET, STATS_COLLECTOR, @@ -744,7 +744,7 @@ static struct config_bool ConfigureNamesBool[] = NULL }, &autovacuum_start_daemon, - true, NULL, NULL + false, NULL, NULL }, { @@ -1138,7 +1138,7 @@ static struct config_int ConfigureNamesInt[] = NULL }, &ReservedBackends, - 3, 0, INT_MAX / 4, NULL, NULL + 2, 0, INT_MAX / 4, NULL, NULL }, { @@ -1563,7 +1563,7 @@ static struct config_int ConfigureNamesInt[] = NULL }, &autovacuum_vac_thresh, - 500, 0, INT_MAX, NULL, NULL + 1000, 0, INT_MAX, NULL, NULL }, { {"autovacuum_analyze_threshold", PGC_SIGHUP, AUTOVACUUM, @@ -1571,7 +1571,7 @@ static struct config_int ConfigureNamesInt[] = NULL }, &autovacuum_anl_thresh, - 250, 0, INT_MAX, NULL, NULL + 500, 0, INT_MAX, NULL, NULL }, { @@ -1726,7 +1726,7 @@ static struct config_real ConfigureNamesReal[] = NULL }, &autovacuum_vac_scale, - 0.2, 0.0, 100.0, NULL, NULL + 0.4, 0.0, 100.0, NULL, NULL }, { {"autovacuum_analyze_scale_factor", PGC_SIGHUP, AUTOVACUUM, @@ -1734,7 +1734,7 @@ static struct config_real ConfigureNamesReal[] = NULL }, &autovacuum_anl_scale, - 0.1, 0.0, 100.0, NULL, NULL + 0.2, 0.0, 100.0, NULL, NULL }, /* End-of-list marker */ diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 2793b1e70df..fcb81d71188 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 = 3 # (change requires restart) +#superuser_reserved_connections = 2 # (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 = on +#stats_row_level = off #stats_reset_on_server_start = off # (change requires restart) @@ -361,15 +361,15 @@ # AUTOVACUUM PARAMETERS #--------------------------------------------------------------------------- -#autovacuum = on # enable autovacuum subprocess? +#autovacuum = off # enable autovacuum subprocess? #autovacuum_naptime = 60 # time between autovacuum runs, in secs -#autovacuum_vacuum_threshold = 500 # min # of tuple updates before +#autovacuum_vacuum_threshold = 1000 # min # of tuple updates before # vacuum -#autovacuum_analyze_threshold = 250 # min # of tuple updates before +#autovacuum_analyze_threshold = 500 # min # of tuple updates before # analyze -#autovacuum_vacuum_scale_factor = 0.2 # fraction of rel size before +#autovacuum_vacuum_scale_factor = 0.4 # fraction of rel size before # vacuum -#autovacuum_analyze_scale_factor = 0.1 # fraction of rel size before +#autovacuum_analyze_scale_factor = 0.2 # fraction of rel size before # analyze #autovacuum_vacuum_cost_delay = -1 # default vacuum cost delay for # autovac, -1 means use |