From: Chris Hoover <revoohc@gmail.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Autovacuum Question
Date: Tue, 16 May 2006 13:27:07 -0400
Message-ID: <1d219a6f0605161027y190c9ba2y781b048ea5c647d9@mail.gmail.com> (raw)
PostgreSQL 8.1.3
Question on autovacuum.
autovacuum_naptime (integer)
Specifies the delay between activity rounds for the autovacuum subprocess.
In each round the subprocess examines one database and issues VACUUM and
ANALYZE commands as needed for tables in that database. The delay is
measured in seconds, and the default is 60. This option can be set at server
start or in the postgresql.conf file.
Does this mean that each run of autovacuum will vacuum/analyze all tables
that need work in the database that autovacuum is looking at?
The reason I'm asking is that I have ~172 non system tables in each
database, so if autovacuum only does one table per run, I don't think it
will ever get caught up (since there are almost 35k tables in total).
Also, with over 200 databases, does this mean that a database will only get
checked once about every 3.5 hours, or does autovacuum run on the database
that needs the vacuuming the most?
Thanks,
Chris
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: revoohc@gmail.com
Subject: Re: Autovacuum Question
In-Reply-To: <1d219a6f0605161027y190c9ba2y781b048ea5c647d9@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox