Re: [HACKERS] Synch Rep v5

2009-01-13 Thread Fujii Masao
Hi, On Mon, Jan 12, 2009 at 1:16 AM, Simon Riggs wrote: > > On Sun, 2009-01-11 at 15:11 +0900, Fujii Masao wrote: > >> Yes, using semaphores for the communication is also my first approach. >> The problem of this approach is that walsender cannot wait for both >> signal from backends and the resp

Re: [HACKERS] Synch Rep v5

2009-01-13 Thread Simon Riggs
On Tue, 2009-01-13 at 16:39 +0900, Fujii Masao wrote: > > May as well leave it in, so people can use it with 8.3. > > I'd like this patch to be reviewed and committed for 8.4 even if > synch-rep > is postponed to 8.5. Because this is very useful for existing > warm-standby > mechanism, and only w

Re: [HACKERS] Synch Rep v5

2009-01-12 Thread Fujii Masao
Hi, On Mon, Jan 12, 2009 at 1:10 AM, Simon Riggs wrote: >> > Multiple standby is still possible, but just using old file based >> > mechanisms. We would need to be careful about use of %R in that case. >> >> Yes. Synch Rep can work fine with existing warm-standby mechanism. > > If we want multipl

Re: [HACKERS] Synch Rep v5

2009-01-11 Thread Simon Riggs
On Sun, 2009-01-11 at 15:11 +0900, Fujii Masao wrote: > Yes, using semaphores for the communication is also my first approach. > The problem of this approach is that walsender cannot wait for both > signal from backends and the response from walreceiver concurrently, > because > wait-for-semaphor

Re: [HACKERS] Synch Rep v5

2009-01-11 Thread Simon Riggs
On Sun, 2009-01-11 at 17:19 +0900, Fujii Masao wrote: > Thanks for your comments! > > On Sat, Jan 10, 2009 at 10:36 PM, Simon Riggs wrote: > > I notice we use the same settings for keepalives. We may need that to be > > a second set of parameters. > > Or, we should make walreceiver execute "SE

Re: [HACKERS] Synch Rep v5

2009-01-11 Thread Fujii Masao
Hi, Thanks for your comments! On Sat, Jan 10, 2009 at 10:36 PM, Simon Riggs wrote: > I notice we use the same settings for keepalives. We may need that to be > a second set of parameters. Or, we should make walreceiver execute "SET tcp_keepalives_xxx TO yyy" before starting replication if such

Re: [HACKERS] Synch Rep v5

2009-01-10 Thread Fujii Masao
Hi, On Sat, Jan 10, 2009 at 10:42 PM, Simon Riggs wrote: > > On Sat, 2009-01-10 at 19:16 +0900, Fujii Masao wrote: > >> On Thu, Dec 18, 2008 at 9:55 AM, Simon Riggs wrote: >> >> 4. sleeping >> >> http://archives.postgresql.org/pgsql-hackers/2008-12/msg00438.php >> >> >> >> I'm looking for the be

Re: [HACKERS] Synch Rep v5

2009-01-10 Thread Simon Riggs
On Sat, 2009-01-10 at 19:16 +0900, Fujii Masao wrote: > On Thu, Dec 18, 2008 at 9:55 AM, Simon Riggs wrote: > >> 4. sleeping > >> http://archives.postgresql.org/pgsql-hackers/2008-12/msg00438.php > >> > >> I'm looking for the better idea. How should we resolve that problem? > >> Only reduce the

Re: [HACKERS] Synch Rep v5

2009-01-10 Thread Simon Riggs
On Sat, 2009-01-10 at 19:16 +0900, Fujii Masao wrote: > I attached the updated version of Synch Rep patch (v5) on wiki. > The description of "User Overview" is also already updated. > http://wiki.postgresql.org/wiki/NTT%27s_Development_Projects#Synch_Rep Looks good on initial read of Wiki. Few m

[HACKERS] Synch Rep v5

2009-01-10 Thread Fujii Masao
Hi, I attached the updated version of Synch Rep patch (v5) on wiki. The description of "User Overview" is also already updated. http://wiki.postgresql.org/wiki/NTT%27s_Development_Projects#Synch_Rep On Thu, Dec 18, 2008 at 9:55 AM, Simon Riggs wrote: >> 4. sleeping >> http://archives.postgresql.