Skip site navigation (1) Skip section navigation (2)


From: "George Sexton" <georges(at)mhsoftware(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: AutoVacuum_NapTime
Date: 2010-02-21 01:03:19
Message-ID: 053401cab291$a8cf7250$fa6e56f0$@com (view raw, whole thread or download thread mbox)
Lists: 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


pgsql-performance by date

Next:From: Tom LaneDate: 2010-02-21 01:15:20
Subject: Re: AutoVacuum_NapTime
Previous:From: Bruce MomjianDate: 2010-02-20 23:19:03
Subject: Re: SSD + RAID

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group