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?