From 29094193f526bf90671d71b59a2e007aad1fcae5 Mon Sep 17 00:00:00 2001 From: Tom Lane Date: Thu, 14 Jul 2005 05:13:45 +0000 Subject: Integrate autovacuum functionality into the backend. There's still a few loose ends to be dealt with, but it seems to work. Alvaro Herrera, based on the contrib code by Matthew O'Connor. --- src/backend/utils/misc/postgresql.conf.sample | 12 ++++++++++++ 1 file changed, 12 insertions(+) (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 193b0303b38..dc06658e7f3 100644 --- a/src/backend/utils/misc/postgresql.conf.sample +++ b/src/backend/utils/misc/postgresql.conf.sample @@ -284,6 +284,18 @@ #stats_reset_on_server_start = on +#--------------------------------------------------------------------------- +# AUTOVACUUM PARAMETERS +#--------------------------------------------------------------------------- + +#autovacuum = false # enable autovacuum subprocess? +#autovacuum_naptime = 60 # time between autovacuum runs, in seconds +#autovacuum_vacuum_threshold = 1000 # min # of tuple updates before vacuum +#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 + + #--------------------------------------------------------------------------- # CLIENT CONNECTION DEFAULTS #--------------------------------------------------------------------------- -- cgit v1.2.3