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 -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte y capacitación de PostgreSQL -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers