Re: autovacuum_work_mem

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Robert Haas <robertmhaas(at)gmail(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Peter Geoghegan <pg(at)heroku(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, Magnus Hagander <magnus(at)hagander(dot)net>
Subject: Re: autovacuum_work_mem
Date: 2013-12-11 18:35:32
Message-ID: 52A8B074.2080608@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 12/11/2013 09:57 AM, Robert Haas wrote:
> I don't agree with that assessment. Anything that involves changing
> the scheduling of autovacuum is a major project that will legitimately
> provoke much controversy. Extensive testing will be needed to prove
> that the new algorithm doesn't perform worse than the current
> algorithm in any important cases. I have my doubts about whether that
> can be accomplished in an entire release cycle, let alone 2-3 days.
> In contrast, the patch proposed does something that is easy to
> understand, clearly safe, and an improvement over what we have now.

+1

There is an inherent tuning and troubleshooting challenge in anything
involving a feedback loop.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabrízio de Royes Mello 2013-12-11 18:37:54 Re: Time-Delayed Standbys
Previous Message Merlin Moncure 2013-12-11 18:33:08 Re: In-Memory Columnar Store