Re: [HACKERS] Synch Rep: communication between backends and walsender

2009-06-23 Thread Fujii Masao
Hi, On Tue, Jun 23, 2009 at 1:55 AM, Markus Wannermar...@bluegap.ch wrote: On the other hand, I think that a semaphore should be used instead of a signal at least for backends to wait for walsender. This would turn around the situation on HPUX in some degree. In this case, the remaining

Re: [HACKERS] Synch Rep: communication between backends and walsender

2009-06-22 Thread Fujii Masao
Hi, On Sat, Jun 20, 2009 at 6:05 PM, Markus Wannermar...@bluegap.ch wrote: Reading the past messages on this topic, I realized that this problem so far only affects HPUX. I fear the proposed UDP/semaphores approach might have a similar gotcha on at least one of the supported platforms, too.

Re: [HACKERS] Synch Rep: communication between backends and walsender

2009-06-22 Thread Markus Wanner
Hi, Fujii Masao wrote: The perfect solution seems to be to remove SA_RESTART and handle EINTR in an appropriate way after every syscalls. But, this is very tough job and has much influence on whole source code, so I don't think that this should be done as part of synch rep. Especially note

Re: [HACKERS] Synch Rep: communication between backends and walsender

2009-06-20 Thread Markus Wanner
Hi, Fujii Masao wrote: One of the major complaints about the current synch rep patch is that signals are used for communication between backends and walsender. On some platforms, a signal doesn't interrupt sleep (i.e. poll or select system call), which would increase the performance overhead

[HACKERS] Synch Rep: communication between backends and walsender

2009-06-16 Thread Fujii Masao
http://archives.postgresql.org/pgsql-hackers/2008-12/msg00448.php One of the major complaints about the current synch rep patch is that signals are used for communication between backends and walsender. On some platforms, a signal doesn't interrupt sleep (i.e. poll or select system call), which

Re: [HACKERS] Synch Rep: communication between backends and walsender

2009-06-16 Thread Greg Stark
On Tue, Jun 16, 2009 at 12:50 PM, Fujii Masaomasao.fu...@gmail.com wrote: On some platforms, a signal doesn't interrupt sleep (i.e. poll or select system call) say what? -- Gregory Stark http://mit.edu/~gsstark/resume.pdf -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)

Re: [HACKERS] Synch Rep: communication between backends and walsender

2009-06-16 Thread Tom Lane
Greg Stark st...@enterprisedb.com writes: On Tue, Jun 16, 2009 at 12:50 PM, Fujii Masaomasao.fu...@gmail.com wrote: On some platforms, a signal doesn't interrupt sleep (i.e. poll or select system call) say what? Yup, what he said. regards, tom lane -- Sent via