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 1A2669DCC10 for ; Thu, 16 Mar 2006 09:41:51 -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 13308-02 for ; Thu, 16 Mar 2006 09:41:53 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.196]) by postgresql.org (Postfix) with ESMTP id 4858F9DCC25 for ; Thu, 16 Mar 2006 09:41:48 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 8so336306nzo for ; Thu, 16 Mar 2006 05:41:52 -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=kJEORg7tivYw1HbYHN+zM9zAV0yGpPr38EgwwzVMHRdKlR/CZ2Tvo2WcBxVcQqNXmnckxdg2XSY2pOXkHV3Pt/UI3EAVRam6qCCTOKVYP9GGlz6/zugKDas9c+E93QYEKisMsKEiKNn7ztK29TjesZpmpCRAfHq2xtrKMyyR7g8= Received: by 10.65.100.4 with SMTP id c4mr586676qbm; Thu, 16 Mar 2006 05:41:51 -0800 (PST) Received: by 10.65.123.12 with HTTP; Thu, 16 Mar 2006 05:41:50 -0800 (PST) Message-ID: <1d4e0c10603160541w59e19034scd13a4e11a9b9c09@mail.gmail.com> Date: Thu, 16 Mar 2006 14:41:50 +0100 From: "Guillaume Smet" To: "Richard Huxton" Subject: Re: PostgreSQL and Xeon MP Cc: pgsql-performance@postgresql.org In-Reply-To: <4419605F.9000806@archonet.com> 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> <4419605F.9000806@archonet.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.229 required=5 tests=[AWL=0.229] X-Spam-Score: 0.229 X-Spam-Level: X-Archive-Number: 200603/236 X-Sequence-Number: 17673 On 3/16/06, Richard Huxton wrote: > Very strange. Sure. I can't find any logical explanation for that but it is the behaviour we have for more than a year now (the site was migrated from Oracle to PostgreSQL on january 2005). We check iostat, vmstat and so on without any hint on why we have this behaviour. > The client has just bought an Opteron to run on, I'm afraid. I might try > 8.1 on the Xeon but it'll just be to see what happens and that won't be > for a while. I don't think it will be an option for us so I will have more information next week.