From: alvherre <alvherre@commandprompt.com>
To: venu madhav <venutaurus539@gmail.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Autovacuum in postgres.
Date: Thu, 27 May 2010 12:10:20 -0400
Message-ID: <1274976439-sup-7339@alvh.no-ip.org> (raw)
In-Reply-To: <AANLkTim7g1WwHs8qBnf1BXR9AXFuniwdCC3fZIedHYKD@mail.gmail.com>
References: <AANLkTim7g1WwHs8qBnf1BXR9AXFuniwdCC3fZIedHYKD@mail.gmail.com>
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@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alvherre@commandprompt.com, venutaurus539@gmail.com
Subject: Re: Autovacuum in postgres.
In-Reply-To: <1274976439-sup-7339@alvh.no-ip.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox