Re: autovacuum_naptime seems to take minutes for seconds

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Claudio Eichenberger <cei(at)yourshop(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Palle Girgensohn <girgen(at)FreeBSD(dot)org>
Subject: Re: autovacuum_naptime seems to take minutes for seconds
Date: 2010-01-13 16:08:35
Message-ID: 11387.1263398915@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Claudio Eichenberger <cei(at)yourshop(dot)com> writes:
> The parameter autovacuum_naptime seems to take minutes for seconds.

How many databases in your installation?

autovacuum_naptime is the target cycle time for any one database.
If you have N databases then the time between launching autovacuum
workers will be autovacuum_naptime / N.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2010-01-13 16:30:43 Re: postgresql 8.1 windows 2008 64 bit
Previous Message Greg Smith 2010-01-13 15:58:44 Re: postgresql 8.1 windows 2008 64 bit