Re: Hot Standby Feedback should default to on in 9.3+ - Mailing list pgsql-hackers

From Albe Laurenz
Subject Re: Hot Standby Feedback should default to on in 9.3+
Date
Msg-id D960CB61B694CF459DCFB4B0128514C208C99DEC@exadv11.host.magwien.gv.at
Whole thread Raw
In response to Re: Hot Standby Feedback should default to on in 9.3+  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
Magnus Hagander wrote:
>> On 30.11.2012 21:02, Andres Freund wrote:
>>> There are workloads where its detrimental, but in general having it
>>> default to on improver experience tremendously because getting conflicts
>>> because of vacuum is rather confusing.
>>>
>>> In the workloads where it might not be a good idea (very long queries on
>>> the standby, many dead tuples on the primary) you need to think very
>>> carefuly about the strategy of avoiding conflicts anyway, and explicit
>>> configuration is required as well.
>>>
>>> Does anybody have an argument against changing the default value?
>>
>>
>> -1. By default, I would expect a standby server to not have any meaningful
>> impact on the performance of the master. With hot standby feedback, you can
>> bloat the master very badly if you're not careful.
> 
> I'm with Heikki on the -1 on this. It's certainly unexpected to have
> the slave affect the master by default - people will expect the master
> to be independent.

I agree.

> +1. Having your reporting query time out *shows you* the problem.
> Having the master bloat for you won't show the problem until later -
> when it's much bigger, and it's much more pain to recover from.

I couldn't agree more.

There are different requirements, and there will always be
people who need to change the defaults, but the way it is is
the safest in my opinion.

Yours,
Laurenz Albe

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Proposal for Allow postgresql.conf values to be changed via SQL
Next
From: "Erik Rijkers"
Date:
Subject: Re: WIP: index support for regexp search