Re: Sync Rep v19 - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: Sync Rep v19
Date
Msg-id AANLkTimoQ1PTk3p1R89EPyzGMiMLj+KFb=sHB8cJ1m+Y@mail.gmail.com
Whole thread Raw
In response to Re: Sync Rep v19  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Sync Rep v19
Re: Sync Rep v19
List pgsql-hackers
On Thu, Mar 3, 2011 at 1:23 PM, Robert Haas <robertmhaas@gmail.com> wrote:
>>
>> The patch sets "*" as the default, so all standbys are synchronous by
>> default.
>>
>> Would you prefer it if it was blank, meaning no standbys are
>> synchronous, by default?
>
> I think * is a reasonable default.
>

Actually i would prefer to have standbys asynchronous by default...
though is true that there will be no waits until i set
synchronous_replication to on... 1) it could be confusing to see a
SYNC standby in pg_stat_replication by default when i wanted all of
them to be async, 2) also * will give priority 1 to all standbys so it
doesn't seem like a very useful out-of-the-box configuration, better
to make the dba to write the standby names in the order they want

--
Jaime Casanova         www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Sync Rep v19
Next
From: Robert Haas
Date:
Subject: Re: Sync Rep v19