Skip site navigation (1) Skip section navigation (2)

Re: Vacuuming

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 (view raw or flat)
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?


In response to

Responses

pgsql-novice by date

Next:From: Devrim GÜNDÜZDate: 2010-02-14 00:23:19
Subject: Re: Vacuuming
Previous:From: Mladen GogalaDate: 2010-02-13 19:40:56
Subject: Re: Vacuuming

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group