Re: Additional options for Sync Replication - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Additional options for Sync Replication
Date
Msg-id AANLkTi=6n_i5RTC-hYqKQgbeycEXV-N2r+UMhhXJDFVg@mail.gmail.com
Whole thread Raw
In response to Re: Additional options for Sync Replication  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-hackers
On Wed, Mar 30, 2011 at 5:29 AM, Fujii Masao <masao.fujii@gmail.com> wrote:

> I'm very excited about new options, especially recv. But I agree with
> Robert and Heikki because what the patch provides looks like new
> feature rather than bug fix. And I think that we still require some
> discussions of the design; how far transactions must wait for sync
> rep in recv mode? In the patch, they wait for WAL to be written in
> the standby, but I think that they should wait until walreceiver has
> recieved WAL instead. That would increase the performance of sync
> rep. Anyway, I don't think now is time to discuss about such a design
> except for bug fix.

Not waiting for write would just be much less safe and would not have
any purpose as a sync rep option.

The difference in time would be very marginal also.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services


pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Replication server timeout patch
Next
From: Heikki Linnakangas
Date:
Subject: Re: Replication server timeout patch