diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2007-01-16 18:26:02 +0000 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2007-01-16 18:26:02 +0000 |
| commit | 10a5e3348eabc651fe89e93ec37bdbaefeba7a12 (patch) | |
| tree | 5a71ee0356fc23feca2f564be6e90a5219da64f0 /src | |
| parent | eb63cc3da82cec03c54a9534a6c91d287078abd1 (diff) | |
| download | postgresql-10a5e3348eabc651fe89e93ec37bdbaefeba7a12.tar.gz postgresql-10a5e3348eabc651fe89e93ec37bdbaefeba7a12.zip | |
Enable autovacuum in the default configuration, per discussion.
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/utils/misc/guc.c | 6 | ||||
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 4 |
2 files changed, 5 insertions, 5 deletions
diff --git a/src/backend/utils/misc/guc.c b/src/backend/utils/misc/guc.c index 16f52bdf565..d04bacc58ee 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.367 2007/01/09 22:16:46 momjian Exp $ + * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.368 2007/01/16 18:26:02 alvherre Exp $ * *-------------------------------------------------------------------- */ @@ -711,7 +711,7 @@ static struct config_bool ConfigureNamesBool[] = NULL }, &pgstat_collect_tuplelevel, - false, NULL, NULL + true, NULL, NULL }, { {"stats_block_level", PGC_SUSET, STATS_COLLECTOR, @@ -748,7 +748,7 @@ static struct config_bool ConfigureNamesBool[] = NULL }, &autovacuum_start_daemon, - false, NULL, NULL + true, NULL, NULL }, { diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 3f546f10c40..50a02a62a50 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -349,7 +349,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) @@ -365,7 +365,7 @@ # AUTOVACUUM PARAMETERS #--------------------------------------------------------------------------- -#autovacuum = off # enable autovacuum subprocess? +#autovacuum = on # enable autovacuum subprocess? # 'on' requires stats_start_collector # and stats_row_level to also be on #autovacuum_naptime = 1min # time between autovacuum runs |