From d90c531188196cd4ea6683c7f4395151b42028a2 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 11 Aug 2005 21:11:50 +0000 Subject: Autovacuum loose end mop-up. Provide autovacuum-specific vacuum cost delay and limit, both as global GUCs and as table-specific entries in pg_autovacuum. stats_reset_on_server_start is now OFF by default, but a reset is forced if we did WAL replay. XID-wrap vacuums do not ANALYZE, but do FREEZE if it's a template database. Alvaro Herrera --- src/backend/utils/misc/postgresql.conf.sample | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'src/backend/utils/misc/postgresql.conf.sample') diff --git a/src/backend/utils/misc/postgresql.conf.sample b/src/backend/utils/misc/postgresql.conf.sample index 7eea5513c2b..86f236910f8 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -288,7 +288,7 @@ #stats_command_string = off #stats_block_level = off #stats_row_level = off -#stats_reset_on_server_start = on +#stats_reset_on_server_start = off #--------------------------------------------------------------------------- @@ -301,6 +301,10 @@ #autovacuum_analyze_threshold = 500 # min # of tuple updates before analyze #autovacuum_vacuum_scale_factor = 0.4 # fraction of rel size before vacuum #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 vacuum_cost_delay +#autovacuum_vacuum_cost_limit = -1 # default vacuum cost limit for autovac + # -1 means use vacuum_cost_limit #--------------------------------------------------------------------------- -- cgit v1.2.3