Re: Sync Rep v19
Jaime Casanova <jaime@2ndquadrant.com>
From: Jaime Casanova <jaime@2ndquadrant.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Simon Riggs <simon@2ndquadrant.com>, Dimitri Fontaine <dimitri@2ndquadrant.fr>, Fujii Masao <masao.fujii@gmail.com>, pgsql-hackers@postgresql.org
Date: 2011-03-04T21:18:39Z
Lists: 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