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

Re:

From: "John Lister" <john(dot)lister-ps(at)kickstone(dot)com>
To: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>,<pgsql-admin(at)postgresql(dot)org>
Cc: <john(dot)lister-ps(at)kickstone(dot)co(dot)uk>
Subject: Re:
Date: 2009-12-03 18:04:52
Message-ID: E4207640A59B4B29A4F338A21D9AB8AA@squarepi.com (view raw or flat)
Thread:
Lists: pgsql-admin
 "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> When we first started using PostgreSQL we initially had problems
> with bloat and the autovacuum process started creating significant
> load.  Our first reaction was to make autovacuum less aggressive,
> but this just made things worse.  The counter-intuitive step of
> making autovacuum very aggressive actually prevented bloat to the
> point where autovacuum wound up creating less load.  Don't be shy
> about running it frequently and at low thresholds; but if it does
> have a performance impact, a small autovacuum_cost_delay (I've never
> needed more than 10ms) will probably solve the issue.

Cheers, I might give that a go. I've set the cost_delay to 10 already, so 
will decrease the thresholds more and see what happens.

John 


In response to

  • Re: at 2009-12-03 17:51:55 from Kevin Grittner

pgsql-admin by date

Next:From: Tena SakaiDate: 2009-12-04 02:25:47
Subject: /usr/bin/ld: cannot find -lpq
Previous:From: Kevin GrittnerDate: 2009-12-03 17:51:55
Subject: Re:

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