Postgres Pro
Downloads
Home   >   mailing lists

AutoVacuum_NapTime - Mailing list pgsql-performance

From George Sexton
Subject AutoVacuum_NapTime
Date
Msg-id 053401cab291$a8cf7250$fa6e56f0$@com
Whole thread Raw
Responses Re: AutoVacuum_NapTime  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
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:

Previous
From: Bruce Momjian
Date:
Subject: Re: SSD + RAID
Next
From: Tom Lane
Date:
Subject: Re: AutoVacuum_NapTime