X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 0C1C09DC800 for ; Thu, 16 Mar 2006 12:08:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37691-05 for ; Thu, 16 Mar 2006 12:08:48 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.201]) by postgresql.org (Postfix) with ESMTP id BB7FA9DC849 for ; Thu, 16 Mar 2006 12:08:47 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 8so364777nzo for ; Thu, 16 Mar 2006 08:08:47 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=SEYZZLgFQ2fpaL12IGtrwCUeAIg7j66+PQBdohmVyXUjWxBNWcYZt7EQcju025xvAZKani0GjtauKTiS8Ywf5J1XFdC+K/Mj/mh+ruHOlcXZauTeyDgKCZWZ0Fr/cP/wpmECkN3QC5gmtV4W6GDUafv5zjtdFtQsHDE3jk6VYWU= Received: by 10.64.27.10 with SMTP id a10mr290413qba; Thu, 16 Mar 2006 08:08:46 -0800 (PST) Received: by 10.65.123.12 with HTTP; Thu, 16 Mar 2006 08:08:46 -0800 (PST) Message-ID: <1d4e0c10603160808y6c2f683csb74086b10c3cd40e@mail.gmail.com> Date: Thu, 16 Mar 2006 17:08:46 +0100 From: "Guillaume Smet" To: "Tom Lane" Subject: Re: PostgreSQL and Xeon MP Cc: "Sven Geisler" , "Richard Huxton" , pgsql-performance@postgresql.org In-Reply-To: <16633.1142522409@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <1d4e0c10603160245n55128e86t35431a339afcf8cc@mail.gmail.com> <44194A4B.3020106@archonet.com> <1d4e0c10603160428s1a3c1f4cocbe8489634524387@mail.gmail.com> <441963F4.1010607@aeccom.com> <1d4e0c10603160630g7fe945ffo1d723843407ed128@mail.gmail.com> <16633.1142522409@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.18 required=5 tests=[AWL=0.180] X-Spam-Score: 0.18 X-Spam-Level: X-Archive-Number: 200603/243 X-Sequence-Number: 17680 On 3/16/06, Tom Lane wrote: > Can you try strace'ing some of the backend processes while the system is > behaving like this? I suspect what you'll find is a whole lot of > delaying select() calls due to high contention for spinlocks ... Tom, I think we can try to do it. You mean strace -p pid with pid on some of the postgres process not on the postmaster itself, does you? Do we need other options? Which pattern should we expect? I'm not really familiar with strace and its output. Thanks for your help.