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


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: (view raw, whole thread or download thread mbox)
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.


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-2017 The PostgreSQL Global Development Group