Postgres Pro
Downloads
Home   >   mailing lists

Re: AutoVacuum_NapTime - Mailing list pgsql-performance

From Tom Lane
Subject Re: AutoVacuum_NapTime
Date
Msg-id 25691.1266714920@sss.pgh.pa.us
Whole thread Raw
In response to AutoVacuum_NapTime  ("George Sexton" <georges@mhsoftware.com>)
Responses Re: AutoVacuum_NapTime  ("George Sexton" <georges@mhsoftware.com>)
List pgsql-performance
Tree view 
"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

pgsql-performance by date:

Previous
From: "George Sexton"
Date:
Subject: AutoVacuum_NapTime
Next
From: "George Sexton"
Date:
Subject: Re: AutoVacuum_NapTime