Tom Lane wrote: > Mark Wong <[EMAIL PROTECTED]> writes: > > I know where the do_sigaction is coming from in this particular case. > > Manfred Spraul tracked it to a pair of pgsignal calls in libpq. > > Commenting out those two calls out virtually eliminates do_sigaction from > > the kernel profile for this workload. > > Hmm, I suppose those are the ones associated with suppressing SIGPIPE > during send(). It looks to me like those should go away in 8.0 if you > have compiled with ENABLE_THREAD_SAFETY ... exactly how is PG being > built in the current round of tests?
Yes, those calls are gone in 8.0 with --enable-thread-safety and were added specifically because of Manfred's reports. -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend