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 762029DCB70 for ; Thu, 16 Mar 2006 13:53:15 -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 61195-09 for ; Thu, 16 Mar 2006 13:53:14 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.199]) by postgresql.org (Postfix) with ESMTP id D96699DC9A7 for ; Thu, 16 Mar 2006 13:53:12 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 8so384828nzo for ; Thu, 16 Mar 2006 09:53:13 -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=biEwtTfp0x3H3pzAC46/iBW6q5eosx5YQoPBQBlBaIM/A5GvzB1rtlGa3++LDpMoY5PNRyuV3XaoTuURenBo1qGd0iEHgv6N6u1axLe/7GCF2PEIzAFkwmloUq4pZPHpGCJXBWWprLXUTztM5SNDUkSPc6Q9eDPfx1jwD0Ikytk= Received: by 10.65.222.3 with SMTP id z3mr1354501qbq; Thu, 16 Mar 2006 09:53:12 -0800 (PST) Received: by 10.65.123.12 with HTTP; Thu, 16 Mar 2006 09:53:12 -0800 (PST) Message-ID: <1d4e0c10603160953w6fc36b74oc3c3dc58681578e6@mail.gmail.com> Date: Thu, 16 Mar 2006 18:53:12 +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: <17483.1142526898@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> <1d4e0c10603160808y6c2f683csb74086b10c3cd40e@mail.gmail.com> <17483.1142526898@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.174 required=5 tests=[AWL=0.174] X-Spam-Score: 0.174 X-Spam-Level: X-Archive-Number: 200603/246 X-Sequence-Number: 17683 On 3/16/06, Tom Lane wrote: > 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. OK, I'll try to do it on monday before our upgrade then see what happens with PostgreSQL 8.1.3. Thanks for your help.