X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 80293329F8C for ; Mon, 18 Oct 2004 16:28:46 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 14799-02 for ; Mon, 18 Oct 2004 15:28:41 +0000 (GMT) Received: from mail.osdl.org (fw.osdl.org [65.172.181.6]) by svr1.postgresql.org (Postfix) with ESMTP id 9C7BA329DB0 for ; Mon, 18 Oct 2004 16:28:40 +0100 (BST) Received: (from markw@localhost) by mail.osdl.org (8.11.6/8.11.6) id i9IFSAJ12704; Mon, 18 Oct 2004 08:28:10 -0700 Date: Mon, 18 Oct 2004 08:28:10 -0700 From: Mark Wong To: Bruce Momjian Cc: Tom Lane , Sean Chittenden , Kevin Brown , pgsql-performance@postgresql.org Subject: Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ... Message-ID: <20041018082810.A11062@osdl.org> References: <26542.1097876270@sss.pgh.pa.us> <200410160122.i9G1M3h03028@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <200410160122.i9G1M3h03028@candle.pha.pa.us>; from pgman@candle.pha.pa.us on Fri, Oct 15, 2004 at 09:22:03PM -0400 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/258 X-Sequence-Number: 8734 On Fri, Oct 15, 2004 at 09:22:03PM -0400, Bruce Momjian wrote: > Tom Lane wrote: > > Mark Wong 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