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 769BC529BA for ; Fri, 5 Aug 2005 10:53:17 -0300 (ADT) 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 16749-07 for ; Fri, 5 Aug 2005 13:53:13 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id DA67852909 for ; Fri, 5 Aug 2005 10:53:12 -0300 (ADT) 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 j75DrEXI008259; Fri, 5 Aug 2005 09:53:14 -0400 (EDT) To: =?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= Cc: pgsql-performance@postgresql.org, Sven Geisler Subject: Re: Performance problems on 4-way AMD Opteron 875 (dual core) In-reply-to: <42F34963.5080403@aeccom.com> References: <42F34963.5080403@aeccom.com> Comments: In-reply-to =?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= message dated "Fri, 05 Aug 2005 13:11:31 +0200" Date: Fri, 05 Aug 2005 09:53:14 -0400 Message-ID: <8258.1123249994@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200508/49 X-Sequence-Number: 13796 =?ISO-8859-1?Q?Dirk_Lutzeb=E4ck?= writes: > Here are the number of queries which the server has finished in a fix > period of time. Uh, you never actually supplied any numbers (or much of any other specifics about what was tested, either). My first reaction is "don't vary more than one experimental parameter at a time". There is no way to tell whether the discrepancy is due to the different hardware, different Postgres version, or 32-bit vs 64-bit build. regards, tom lane