Re: Synchronization levels in SR

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com> wrote:
> One way to do that would be to refrain from flushing the commit
> record to disk on the master until the standby has acknowledged
> it.
I'm not clear on the benefit of doing that, versus flushing the
commit record and then waiting for responses.  Either way some
databases will commit before others -- what is the benefit of having
the master lag?
> Adding a synchronous standby should require some action in the 
> master, since it affects the behavior on master.
+1
-Kevin