Skip site navigation (1) Skip section navigation (2)

Re: Autovacuum is running forever

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Sachchida Ojha <sojha(at)secure-elements(dot)com>
Cc: Michael Glaesemann <grzm(at)seespotcode(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Autovacuum is running forever
Date: 2007-08-21 21:54:41
Message-ID: 20070821215441.GA12717@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-performance
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)

In response to

pgsql-performance by date

Next:From: Scott MarloweDate: 2007-08-21 22:01:23
Subject: Re: Autovacuum is running forever
Previous:From: Sachchida OjhaDate: 2007-08-21 21:52:32
Subject: Re: Autovacuum is running forever

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group