George Sexton wrote:
> 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?
the latter
--
Alvaro Herrerahttp://w
> -Original Message-
> From: Tom Lane [mailto:t...@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" writes:
> > I
"George Sexton" 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
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 autovac
