Commit10a5e33

committed

Enable autovacuum in the default configuration, per discussion.

1 parenteb63cc3 commit10a5e33Copy full SHA for 10a5e33

File tree

+12

-9

lines changed

+12

-9

lines changed

Lines changed: 3 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.101 2007/01/09 22:16:46 momjian Exp $ -->`
	`1`	`+<!-- $PostgreSQL: pgsql/doc/src/sgml/config.sgml,v 1.102 2007/01/16 18:26:02 alvherre Exp $ -->`
`2`	`2`
`3`	`3`	`<chapter Id="runtime-config">`
`4`	`4`	`<title>Server Configuration</title>`
`@@ -3043,7 +3043,8 @@ SELECT * FROM parent WHERE key = 2400;`
`3043`	`3043`	`<listitem>`
`3044`	`3044`	`<para>`
`3045`	`3045`	`Enables the collection of row-level statistics on database`
`3046`		`- activity. This parameter is off by default.`
	`3046`	`+ activity. This parameter is on by default, because the autovacuum`
	`3047`	`+ daemon needs the collected information.`
`3047`	`3048`	`Only superusers can change this setting.`
`3048`	`3049`	`</para>`
`3049`	`3050`	`</listitem>`

Lines changed: 4 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -1,4 +1,4 @@`
`1`		`-<!-- $PostgreSQL: pgsql/doc/src/sgml/maintenance.sgml,v 1.65 2006/12/27 14:55:17 momjian Exp $ -->`
	`1`	`+<!-- $PostgreSQL: pgsql/doc/src/sgml/maintenance.sgml,v 1.66 2007/01/16 18:26:02 alvherre Exp $ -->`
`2`	`2`
`3`	`3`	`<chapter id="maintenance">`
`4`	`4`	`<title>Routine Database Maintenance Tasks</title>`
`@@ -477,7 +477,9 @@ HINT: Stop the postmaster and use a standalone backend to VACUUM in "mydb".`
`477`	`477`	`linkend="guc-stats-start-collector"> and <xref`
`478`	`478`	`linkend="guc-stats-row-level"> are set to <literal>true</literal>. Also,`
`479`	`479`	`it's important to allow a slot for the autovacuum process when choosing`
`480`		`- the value of <xref linkend="guc-superuser-reserved-connections">.`
	`480`	`+ the value of <xref linkend="guc-superuser-reserved-connections">. In`
	`481`	`+ the default configuration, autovacuuming is enabled and the related`
	`482`	`+ configuration parameters are appropriately set.`
`481`	`483`	`</para>`
`482`	`484`
`483`	`485`	`<para>`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -10,7 +10,7 @@`
`10`	`10`	`* Written by Peter Eisentraut <peter_e@gmx.net>.`
`11`	`11`	`*`
`12`	`12`	`* IDENTIFICATION`
`13`		`- * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.367 2007/01/09 22:16:46 momjian Exp $`
	`13`	`+ * $PostgreSQL: pgsql/src/backend/utils/misc/guc.c,v 1.368 2007/01/16 18:26:02 alvherre Exp $`
`14`	`14`	`*`
`15`	`15`	`*--------------------------------------------------------------------`
`16`	`16`	`*/`
`@@ -711,7 +711,7 @@ static struct config_bool ConfigureNamesBool[] =`
`711`	`711`	`NULL`
`712`	`712`	`},`
`713`	`713`	`&pgstat_collect_tuplelevel,`
`714`		`-false,NULL,NULL`
	`714`	`+true,NULL,NULL`
`715`	`715`	`},`
`716`	`716`	`{`
`717`	`717`	`{"stats_block_level",PGC_SUSET,STATS_COLLECTOR,`
`@@ -748,7 +748,7 @@ static struct config_bool ConfigureNamesBool[] =`
`748`	`748`	`NULL`
`749`	`749`	`},`
`750`	`750`	`&autovacuum_start_daemon,`
`751`		`-false,NULL,NULL`
	`751`	`+true,NULL,NULL`
`752`	`752`	`},`
`753`	`753`
`754`	`754`	`{`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -349,7 +349,7 @@`
`349`	`349`	`#stats_start_collector = on# needed for block or row stats`
`350`	`350`	`# (change requires restart)`
`351`	`351`	`#stats_block_level = off`
`352`		`-#stats_row_level =off`
	`352`	`+#stats_row_level =on`
`353`	`353`	`#stats_reset_on_server_start = off# (change requires restart)`
`354`	`354`
`355`	`355`
`@@ -365,7 +365,7 @@`
`365`	`365`	`# AUTOVACUUM PARAMETERS`
`366`	`366`	`#---------------------------------------------------------------------------`
`367`	`367`
`368`		`-#autovacuum =off# enable autovacuum subprocess?`
	`368`	`+#autovacuum =on# enable autovacuum subprocess?`
`369`	`369`	`# 'on' requires stats_start_collector`
`370`	`370`	`# and stats_row_level to also be on`
`371`	`371`	`#autovacuum_naptime = 1min# time between autovacuum runs`

Comments

(0)