Re: Vacuum rate limit in KBps

Bruce Momjian <bruce@momjian.us>

From: Bruce Momjian <bruce@momjian.us>
To: Greg Smith <greg@2ndQuadrant.com>
Cc: Robert Haas <robertmhaas@gmail.com>, Alvaro Herrera <alvherre@commandprompt.com>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2012-02-09T14:42:21Z
Lists: pgsql-hackers
On Wed, Feb 08, 2012 at 10:41:43PM -0500, Greg Smith wrote:
> Just trying to set the expectations bar realistically here.  I don't
> consider the easier problem of checkpoint smoothing a solved one,
> either.  Saying autovacuum needs to reach even that level of
> automation to be a useful improvement over now is a slippery goal.
> Regardless, the simple idea I submitted to this CF is clearly dead
> for now.  I'll take the feedback of "this level of change can live
> in a user-side tuning tool" and do that instead.  Since I was
> already thinking in the direction of background activity monitoring,
> I have a good idea how I'd need to approach this next, to be more
> likely to gain community buy-in as an automated improvement.  That's
> a longer term project though, which I'll hopefully be able to
> revisit for 9.3.

Totally agree.  If it is hard for us, it is super-hard to admins to set
this, so we had better give it serious thought.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +