On Fri, Mar 4, 2011 at 4:18 PM, Jaime Casanova <ja...@2ndquadrant.com> wrote: > On Thu, Mar 3, 2011 at 1:23 PM, Robert Haas <robertmh...@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
Mmm, good points. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers