diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-07-14 05:13:45 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-07-14 05:13:45 +0000 |
| commit | 29094193f526bf90671d71b59a2e007aad1fcae5 (patch) | |
| tree | 51e632c843ab9c7eedbd0b01f4de5b27c202443e /src/backend/utils/misc/postgresql.conf.sample | |
| parent | f2bf2d2dc5cef3f5b9cf50493490fa9931f982b2 (diff) | |
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.
Diffstat (limited to 'src/backend/utils/misc/postgresql.conf.sample')
| -rw-r--r-- | src/backend/utils/misc/postgresql.conf.sample | 12 |
1 files changed, 12 insertions, 0 deletions
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 @@ -285,6 +285,18 @@ #--------------------------------------------------------------------------- +# 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 #--------------------------------------------------------------------------- |