Re: [PostgreSQL 10] default of hot_standby should be "on"?

From: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
To: Craig Ringer <craig(at)2ndquadrant(dot)com>
Cc: Huong Dangminh <huo-dangminh(at)ys(dot)jp(dot)nec(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Hiroshi Yanagisawa <hir-yanagisawa(at)ut(dot)jp(dot)nec(dot)com>
Subject: Re: [PostgreSQL 10] default of hot_standby should be "on"?
Date: 2017-04-26 07:24:23
Message-ID: CAD21AoDvtF0z3LWxC5CWAZA+2dgGe3YCOPCso5SXX=-T64hy5g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Apr 26, 2017 at 9:36 AM, Craig Ringer <craig(at)2ndquadrant(dot)com> wrote:
> On 26 April 2017 at 08:30, Huong Dangminh <huo-dangminh(at)ys(dot)jp(dot)nec(dot)com> wrote:
>
>> Default for hot_standby parameter should be "on" from PostgreSQL 10?
>>
>> In PostgreSQL 10, -w option is default for [pg_ctl start].
>> So in order to start standby we have to setting hot_standby to "on" or
>> start standby with -W option.
>
> Yeah. That's a good reason to change it. I think at this point warm
> standby is clearly the less-used secondary option and hot_standby
> should be default.
>

The idea of changing the default value seems good to me but I'm not
sure it's good idea to change the default value now under the
circumstances where we're focus on stabilization.
Also we should update the document as well.

Regards,

--
Masahiko Sawada
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tsunakawa, Takayuki 2017-04-26 07:33:27 Re: [PostgreSQL 10] default of hot_standby should be "on"?
Previous Message Kyotaro HORIGUCHI 2017-04-26 07:03:40 Re: subscription worker doesn't start immediately on eabled