From: | "Wright, George" <George(dot)Wright(at)infimatic(dot)com> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | auto vacuum question |
Date: | 2009-04-09 13:03:09 |
Message-ID: | 51548D6D5BEB57468163194A8C1A0E980161AF89@MAGPTCPEXC02.na.mag-ias.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I have auto vacuum turned on in the postgresql.conf file and I noticed
template1 and postgres databases being vacuumed repeatedly.
Is that necessary? If not, how can I turn it off for just those
databases but not my project's database?
Here are my postgresql.conf autovaccum settings:
autovacuum = on # enable autovacuum subprocess?
#autovacuum_naptime = 60 # time between autovacuum runs,
in secs
#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
#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
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GÜNDÜZ | 2009-04-09 13:13:50 | Re: [NOVICE] Where is PostgreSQL root directory? |
Previous Message | A B | 2009-04-09 07:48:35 | Re: Is there a way to get just the number of seconds between two timestamps? |