Re: Sync Rep: First Thoughts on Code

Simon Riggs wrote:
> On Thu, 2008-12-11 at 09:27 -0500, Aidan Van Dyk wrote:
> 
>> But "catchup" *has* to be *done* before PostgreSQL can enter "sync rep".
> 
> Not true. Please reread the thread where Heikki questions that and I
> reply. This was Fujii-san's idea, which I now agree with.

I think the confusion here is about what exactly "sync rep" means in 
this situation. It's true that you can start streaming the WAL before 
the standby has fully caught up. But from the client's point of view, 
there's not much point in streaming the log *synchronously* and making 
the client to wait for the acknowledment from the standby, if the 
acknowledgment from the standby that WAL has be streamed up to point X, 
doesn't actually guarantee that the slave can recover all the way to 
that point.

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com