Re: Autovacuum in postgres.

Excerpts from venu madhav's message of vie may 21 05:38:43 -0400 2010:
> 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 there any way to make it run it every
> hour.

If you set naptime to 12 mins, it will run on one database every 12
minutes, so once per hour for your database. This is not really the
intended usage though. You will have to adjust the time if another
database is created.

--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support