From: Mark Wong <markw@osdl.org>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Sean Chittenden <sean@chittenden.org>
Cc: Kevin Brown <kevin@sysexperts.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ...
Date: Mon, 18 Oct 2004 08:28:10 -0700
Message-ID: <20041018082810.A11062@osdl.org> (raw)
In-Reply-To: <200410160122.i9G1M3h03028@candle.pha.pa.us>
References: <26542.1097876270@sss.pgh.pa.us>
<200410160122.i9G1M3h03028@candle.pha.pa.us>
On Fri, Oct 15, 2004 at 09:22:03PM -0400, Bruce Momjian wrote:
> Tom Lane wrote:
> > Mark Wong <markw@osdl.org> 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.
>
Ok, I had the build commands changed for installing PostgreSQL in STP.
The do_sigaction call isn't at the top of the profile anymore, here's
a reference for those who are interested; it should have the same test
parameters as the one Tom referenced a little earlier:
http://khack.osdl.org/stp/298230/
Mark
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: markw@osdl.org, pgman@candle.pha.pa.us, tgl@sss.pgh.pa.us, sean@chittenden.org, kevin@sysexperts.com
Subject: Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ...
In-Reply-To: <20041018082810.A11062@osdl.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox