From: George Sexton <georges@mhsoftware.com>
To: pgsql-performance@postgresql.org
Subject: AutoVacuum_NapTime
Date: Sat, 20 Feb 2010 18:03:19 -0700
Message-ID: <053401cab291$a8cf7250$fa6e56f0$@com> (raw)
I have a system with around 330 databases running PostgreSQL 8.4.2
What would the expected behavior be with AutoVacuum_NapTime set to the
default of 1m and autovacuum_workers set to 3?
What I'm observing is that the system is continuously vacuuming databases.
Would these settings mean the autovacuum worker would try to vacuum all 330
databases once per minute?
George Sexton
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-performance@postgresql.org
Cc: georges@mhsoftware.com
Subject: Re: AutoVacuum_NapTime
In-Reply-To: <053401cab291$a8cf7250$fa6e56f0$@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