Auto vacuum configuration in postgres.
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
On Mon, May 24, 2010 at 6:23 PM, venu madhav <venutaurus539@gmail.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@postgresql.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