| From: | Claudio Eichenberger <cei(at)yourshop(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| 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 17:09:06 |
| Message-ID: | 20100113170906.GB18018@yourshop.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(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
>
--
Tel +41 21 67 17 111
Mob +41 79 34 72 100
Claudio(at)yourshop(dot)com
Http://YourShop.com/
"Come to me all who are weary and burdened
and I will give you rest" -- Jesus Christ
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vincenzo Romano | 2010-01-13 17:37:40 | Re: R: Re: Weird EXECUTE ... USING behaviour |
| Previous Message | Vincenzo Romano | 2010-01-13 17:04:34 | Re: R: Re: Weird EXECUTE ... USING behaviour |