Re: write ahead logging in standby (streaming replication) - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: write ahead logging in standby (streaming replication)
Date
Msg-id 4AFBB9F5.4080503@enterprisedb.com
Whole thread Raw
In response to Re: write ahead logging in standby (streaming replication)  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: write ahead logging in standby (streaming replication)
List pgsql-hackers
Fujii Masao wrote:
> The problem is that fsync needs to be issued too frequently, which would
> be harmless in asynchronous replication, but not in synchronous one.
> A transaction would have to wait for the primary's and standby's fsync
> before returning a "success" to a client.
> 
> So I'm inclined to change the startup process and bgwriter, instead of
> walreceiver, so as to fsync the WAL for the WAL rule.

Let's keep it simple for now. Just make the walreceiver do the fsync. We
can optimize later. For now, we're only going to have async mode anyway.

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


pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: next CommitFest
Next
From: Peter Eisentraut
Date:
Subject: Re: Patch committers