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 63F069DC800 for ; Thu, 16 Mar 2006 12:35:19 -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 43903-03-2 for ; Thu, 16 Mar 2006 12:35:14 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id EC1379DCC19 for ; Thu, 16 Mar 2006 12:35:12 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id k2GGYw1D017484; Thu, 16 Mar 2006 11:34:58 -0500 (EST) To: "Guillaume Smet" cc: "Sven Geisler" , "Richard Huxton" , pgsql-performance@postgresql.org Subject: Re: PostgreSQL and Xeon MP In-reply-to: <1d4e0c10603160808y6c2f683csb74086b10c3cd40e@mail.gmail.com> 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> <1d4e0c10603160808y6c2f683csb74086b10c3cd40e@mail.gmail.com> Comments: In-reply-to "Guillaume Smet" message dated "Thu, 16 Mar 2006 17:08:46 +0100" Date: Thu, 16 Mar 2006 11:34:58 -0500 Message-ID: <17483.1142526898@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.113 required=5 tests=[AWL=0.113] X-Spam-Score: 0.113 X-Spam-Level: X-Archive-Number: 200603/244 X-Sequence-Number: 17681 "Guillaume Smet" writes: > You mean strace -p pid with pid on some of the postgres process not on > the postmaster itself, does you? Right, pick a couple that are accumulating CPU time. > Do we need other options? strace will generate a *whole lot* of output to stderr. I usually do something like strace -p pid 2>outfile and then control-C it after a few seconds. > Which pattern should we expect? What we want to find out is if there's a lot of select()s and/or semop()s shown in the result. Ideally there wouldn't be any, but I fear that's not what you'll find. regards, tom lane