AutoVacuum_NapTime

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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2010-02-21 01:15:20 Re: AutoVacuum_NapTime
Previous Message Bruce Momjian 2010-02-20 23:19:03 Re: SSD + RAID