Re: AutoVacuum_NapTime

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"George Sexton" <georges@xxxxxxxxxxxxxx> 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

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux