Re: Hot Standby Feedback should default to on in 9.3+

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Magnus Hagander *EXTERN*" <magnus(at)hagander(dot)net>, "Heikki Linnakangas" <hlinnakangas(at)vmware(dot)com>
Cc: "Andres Freund" <andres(at)2ndquadrant(dot)com>, "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Hot Standby Feedback should default to on in 9.3+
Date: 2012-12-01 10:42:22
Message-ID: D960CB61B694CF459DCFB4B0128514C208C99DEC@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Erik Rijkers 2012-12-01 11:22:56 Re: WIP: index support for regexp search
Previous Message Amit Kapila 2012-12-01 08:09:04 Re: Proposal for Allow postgresql.conf values to be changed via SQL