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

Re:

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "John Lister" <john(dot)lister-ps(at)kickstone(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Cc: <john(dot)lister-ps(at)kickstone(dot)co(dot)uk>
Subject: Re:
Date: 2009-12-03 17:51:55
Message-ID: 4B17A65B020000250002D05D@gw.wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-admin
"John Lister" <john(dot)lister-ps(at)kickstone(dot)com> wrote:
 
> As you say, I suspect I may have had the autovacuum settings too
> low so as to avoid loading the db too much (it seems to be a
> delicate balance between having autovacuum run and slowing down
> normal use) and have upped them a little. but wanted to make sure
> that (auto)vacuum was doing what I thought before getting more
> aggressive with them
 
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.
 
-Kevin

In response to

  • Re: at 2009-12-03 17:41:22 from John Lister

Responses

  • Re: at 2009-12-03 18:04:52 from John Lister

pgsql-admin by date

Next:From: John ListerDate: 2009-12-03 18:04:52
Subject: Re:
Previous:From: John ListerDate: 2009-12-03 17:41:22
Subject: Re:

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