Re: Vacuuming - Mailing list pgsql-novice

From Frank Bax
Subject Re: Vacuuming
Date
Msg-id BLU0-SMTP32A3E8F74B381EE4583D53AC4B0@phx.gbl
Whole thread Raw
In response to Re: Vacuuming  (Mladen Gogala <mladen.gogala@vmsinfo.com>)
Responses Re: Vacuuming  (Devrim GÜNDÜZ <devrim@gunduz.org>)
List 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?


pgsql-novice by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: Vacuuming
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: Vacuuming