From: George Sexton <georges@mhsoftware.com>
To: 'Tom Lane' <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: AutoVacuum_NapTime
Date: Sat, 20 Feb 2010 18:29:51 -0700
Message-ID: <053801cab295$5df355e0$19da01a0$@com> (raw)
In-Reply-To: <25691.1266714920@sss.pgh.pa.us>
References: <053401cab291$a8cf7250$fa6e56f0$@com>
<25691.1266714920@sss.pgh.pa.us>
> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Saturday, February 20, 2010 6:15 PM
> To: George Sexton
> Cc: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] AutoVacuum_NapTime
>
> "George Sexton" <georges@mhsoftware.com> writes:
> > 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?
>
> autovacuum_naptime is the cycle time for any one database, so you'd
> get an autovac worker launched every 60/330 seconds ...
>
> regards, tom lane
Thanks. That's non-optimal for my usage. I'll change it.
Another question then. Say I set it to 720 minutes, which if I understand
things would see each db done twice per day.
If I'm cold starting the system, would it vacuum all 330 databases and then
wait 720 minutes and then do them all again, or would it distribute the
databases more or less evenly over the time period?
George Sexton
MH Software, Inc.
http://www.mhsoftware.com/
Voice: 303 438 9585
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, tgl@sss.pgh.pa.us
Subject: Re: AutoVacuum_NapTime
In-Reply-To: <053801cab295$5df355e0$19da01a0$@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