Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id DE0C29FB64A for ; Tue, 13 Feb 2007 18:53:22 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 88624-08 for ; Tue, 13 Feb 2007 18:53:19 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.190]) by postgresql.org (Postfix) with ESMTP id A45B59FB632 for ; Tue, 13 Feb 2007 18:53:19 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so477032nfb for ; Tue, 13 Feb 2007 14:53:18 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=XWLuQYHPJq3PK2TfIQCspEuYqh1FT+C5Ev6l4ZGFvX8lE0d6bQlWJwgi+coTH9H1ShQZ/7HoMlD8pih/OCJ47wc88Boj/+PiLFnV8+1h2RU3SBhmqnk1OxoO3Cf9e8WI/xEK7/FC2GuosnuREHKZXa2QR75iEGMKVeTj9iASx20= Received: by 10.49.75.2 with SMTP id c2mr1184798nfl.1171407198025; Tue, 13 Feb 2007 14:53:18 -0800 (PST) Received: from ?192.168.1.10? ( [82.3.238.153]) by mx.google.com with ESMTP id b1sm4544263nfe.2007.02.13.14.53.16; Tue, 13 Feb 2007 14:53:16 -0800 (PST) Message-ID: <45D24146.3050402@enterprisedb.com> Date: Tue, 13 Feb 2007 22:52:54 +0000 From: Heikki Linnakangas User-Agent: Icedove 1.5.0.8 (X11/20061116) MIME-Version: 1.0 To: Dan Harris CC: PostgreSQL Performance Subject: Re: quad or dual core Intel CPUs References: <20070213194610.GA10789@juniper.net> <45D22829.8050503@tweakers.net> <45D239D3.5020501@drivefaster.net> In-Reply-To: <45D239D3.5020501@drivefaster.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.093 tagged_above=0 required=5 tests=AWL, BAYES_50, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/143 X-Sequence-Number: 23197 Dan Harris wrote: > Arjen van der Meijden wrote: > >> But be aware that there can be substantial and unexpected differences >> on this relatively new platform due to simply changing the OS, like we >> saw when going from linux 2.6.15 to 2.6.18, as you can see here: >> http://tweakers.net/reviews/657/2 > > Having upgraded to 2.6.18 fairly recently, I am *very* interested in > what caused the throughput to drop in 2.6.18? I haven't done any > benchmarking on my system to know if it affected my usage pattern > negatively, but I am curious if anyone knows why this happened? I think you're reading the results backwards. PostgreSQL throughput increased, not decreased, by the upgrade. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com