From: | Frank Bax <fbax(at)sympatico(dot)ca> |
---|---|
To: | PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Vacuuming |
Date: | 2010-02-14 00:08:39 |
Message-ID: | BLU0-SMTP32A3E8F74B381EE4583D53AC4B0@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Mladen Gogala wrote:
> In postgresql.conf parameter file, there should be the following section:
>
> autovacuum = on # Enable autovacuum subprocess? 'on'
> # requires track_counts to also be on.
> log_autovacuum_min_duration = 10000 # -1 disables, 0 logs all
> actions and
> # their durations, > 0 logs only
> # actions running at least this
> number
> # of milliseconds.
> autovacuum_max_workers = 5 # max number of autovacuum
> subprocesses
> #autovacuum_naptime = 1min # time between autovacuum runs
> #autovacuum_vacuum_threshold = 50 # min number of row updates before
> # vacuum
> #autovacuum_analyze_threshold = 50 # min number of row updates before
> # analyze
I start with:
autovacuum = on # Enable autovacuum subprocess? 'on'
# requires track_counts to also be on.
log_autovacuum_min_duration = 0 # -1 disables, 0 logs all
autovacuum_max_workers = 3 # max number of autovacuum subprocesses
autovacuum_naptime = 60min # time between autovacuum runs
Then stop/start postmaster...
2010-02-13 17:36:35 EST LOG: received fast shutdown request
2010-02-13 17:36:35 EST LOG: aborting any active transactions
2010-02-13 17:36:35 EST LOG: shutting down
2010-02-13 17:36:35 EST LOG: database system is shut down
2010-02-13 17:36:36 EST LOG: database system was shut down at
2010-02-13 17:36:35 EST
2010-02-13 17:36:36 EST LOG: database system is ready to accept
connections
2010-02-13 17:36:36 EST LOG: autovacuum launcher started
It's now 19:06 and no autovacuum; why not?
From | Date | Subject | |
---|---|---|---|
Next Message | Devrim GÜNDÜZ | 2010-02-14 00:23:19 | Re: Vacuuming |
Previous Message | Mladen Gogala | 2010-02-13 19:40:56 | Re: Vacuuming |