From: Alvaro Herrera <alvherre@commandprompt.com>
To: Sachchida Ojha <sojha@secure-elements.com>
Cc: Michael Glaesemann <grzm@seespotcode.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Autovacuum is running forever
Date: Tue, 21 Aug 2007 17:54:41 -0400
Message-ID: <20070821215441.GA12717@alvh.no-ip.org> (raw)
In-Reply-To: <E099DB9EF394534CBA0F62ED03CF3BBF05FDBF1F@EXVS01.IceMAIL.com>
References: <C927A262-C7B0-4003-ABAE-570256F76B16@seespotcode.net>
<E099DB9EF394534CBA0F62ED03CF3BBF05FDBF1F@EXVS01.IceMAIL.com>
Sachchida Ojha wrote:
> vacuum_cost_delay = 200
That is absurdly high. A setting of 10 is more likely to be useful.
> autovacuum_naptime = 3600
That is too high probably as well; particularly so if you have "updates
and deletes every second".
> #autovacuum_vacuum_scale_factor = 0.4
> #autovacuum_analyze_scale_factor = 0.2
These too. Try 0.1 for both and see how it goes.
In short, you need autovacuum to run _way more often_ than you are.
--
Alvaro Herrera http://www.advogato.org/person/alvherre
"Un poeta es un mundo encerrado en un hombre" (Victor Hugo)
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, sojha@secure-elements.com, grzm@seespotcode.net
Subject: Re: Autovacuum is running forever
In-Reply-To: <20070821215441.GA12717@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