Re: max_standby_delay considered harmful

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Robert Haas" <robertmhaas(at)gmail(dot)com>, "Bruce Momjian" <bruce(at)momjian(dot)us>
Cc: "Greg Smith" <greg(at)2ndquadrant(dot)com>, "Simon Riggs" <simon(at)2ndquadrant(dot)com>, "Josh Berkus" <josh(at)agliodbs(dot)com>, "Andres Freund" <andres(at)anarazel(dot)de>, "Dimitri Fontaine" <dfontaine(at)hi-media(dot)com>, "Florian Pflug" <fgp(at)phlo(dot)org>, <pgsql-hackers(at)postgresql(dot)org>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: max_standby_delay considered harmful
Date: 2010-05-10 15:39:00
Message-ID: 4BE7E24402000025000314AB@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> Robert Haas wrote:

>> Overall I would say opinion is about evenly split between:
>>
>> - leave it as-is
>> - make it a Boolean
>> - change it in some way but to something more expressive than a
>> Boolean

I think a boolean would limit the environments in which HS would be
useful. Personally, I think how far the replica is behind the
source is a more useful metric, even with anomalies on the
transition from idle to active; but a blocking duration would be
much better than no finer control than the boolean. So my "instant
runoff second choice" would be for the block duration knob.

> time for a decision, and with no one agreeing on what to do,
> feature removal seemed like the best approach.

I keep wondering at the assertion that once a GUC is present
(especially a tuning GUC like this) that we're stuck with it. I
know that's true of SQL code constructs, but postgresql.conf files?
How about redirect_stderr, max_fsm_*, sort_mem, etc.? This argument
seems tenuous.

> Suggesting we will fix it later in beta is not a solution.

I'm with you there, 100%

-Kevin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2010-05-10 15:40:37 Re: make install fails due to "/bin/mkdir: missing operand"
Previous Message Alexander Korotkov 2010-05-10 15:35:02 multibyte charater set in levenshtein function