Re: autovacuum_naptime seems to take minutes for seconds

Tom

Hello,

55 databases which made me believe minutes correspond to seconds!

Many thanks for your explanation

Regards

Claudio



On 2010-01-13 11:08:35, Tom Lane wrote:
> Claudio Eichenberger <cei@yourshop.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
>

--
Tel +41 21 67 17 111
Mob +41 79 34 72 100
Claudio@yourshop.com
Http://YourShop.com/


    "Come to me all who are weary and burdened
        and I will give you rest" -- Jesus Christ