From: | Nilesh Govindarajan <lists(at)itech7(dot)com> |
---|---|
To: | venu madhav <venutaurus539(at)gmail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Auto vacuum configuration in postgres. |
Date: | 2010-05-28 04:00:00 |
Message-ID: | AANLkTimpO_vUBeDG3WGElRhLsCn2IDiCDT7GuikXlwt8@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, May 24, 2010 at 6:23 PM, venu madhav <venutaurus539(at)gmail(dot)com> wrote:
> Hi All,
> In my application we are using postgres which runs on an
> embedded box. I have configured autovacuum to run once for every one
> hour. It has 5 different databases in it. When I saw the log messages,
> I found that it is running autovacuum on one database every hour. As a
> result, on my database autovacuum is run once in 5 hours. Is that an
> expected behavior, Is there any way to make it run it every hour.
>
>
> Thank you,
> Venu
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
Increase autovacuum workers. More the workers, the job will be done
parallely. Anybody with more knowledge is requested to correct me if
I'm wrong.
--
Nilesh Govindarajan
Facebook: nilesh.gr
Twitter: nileshgr
Website: www.itech7.com
From | Date | Subject | |
---|---|---|---|
Next Message | Or Kroyzer | 2010-05-28 05:25:10 | Re: recovery after interrupt in the middle of a previous recovery |
Previous Message | Nilesh Govindarajan | 2010-05-28 03:58:24 | Re: No lidbl.so in libpq.so (postgresql 8.4.4) |