pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedAutoVacuum_NapTime
4+ messages / 3 participants
[nested] [flat]
* AutoVacuum_NapTime
@ 2010-02-21 01:03 George Sexton <georges@mhsoftware.com>
0 siblings, 1 reply; 4+ messages in thread
From: George Sexton @ 2010-02-21 01:03 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: AutoVacuum_NapTime
@ 2010-02-21 01:15 Tom Lane <tgl@sss.pgh.pa.us>
parent: George Sexton <georges@mhsoftware.com>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2010-02-21 01:15 UTC (permalink / raw)
To: George Sexton <georges@mhsoftware.com>; +Cc: pgsql-performance
"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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: AutoVacuum_NapTime
@ 2010-02-21 01:29 George Sexton <georges@mhsoftware.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: George Sexton @ 2010-02-21 01:29 UTC (permalink / raw)
To: 'Tom Lane' <tgl@sss.pgh.pa.us>; +Cc: pgsql-performance
> -----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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: AutoVacuum_NapTime
@ 2010-02-22 12:43 Alvaro Herrera <alvherre@commandprompt.com>
parent: George Sexton <georges@mhsoftware.com>
0 siblings, 0 replies; 4+ messages in thread
From: Alvaro Herrera @ 2010-02-22 12:43 UTC (permalink / raw)
To: George Sexton <georges@mhsoftware.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-performance
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 Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2010-02-22 12:43 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-02-21 01:03 AutoVacuum_NapTime George Sexton <georges@mhsoftware.com>
2010-02-21 01:15 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-02-21 01:29 ` George Sexton <georges@mhsoftware.com>
2010-02-22 12:43 ` Alvaro Herrera <alvherre@commandprompt.com>
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