Received: from localhost (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 3A9DA633E9F for ; Sat, 14 Mar 2009 23:38:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 64007-03 for ; Sat, 14 Mar 2009 23:38:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.beccati.com (ispeed-srv6.housing.tomato.it [213.92.90.60]) by mail.postgresql.org (Postfix) with ESMTP id A4205632303 for ; Sat, 14 Mar 2009 23:38:28 -0300 (ADT) Received: (qmail 73295 invoked from network); 15 Mar 2009 03:38:24 +0100 Received: from unknown (HELO ?192.168.1.203?) (matteo@beccati.com@88.149.176.119) by mail.beccati.com with SMTP; 15 Mar 2009 02:38:24 -0000 Message-ID: <49BC6A19.9090802@beccati.com> Date: Sun, 15 Mar 2009 03:38:17 +0100 From: Matteo Beccati User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: decibel CC: Steve McLellan , pgsql-performance@postgresql.org Subject: Re: Query performance over a large proportion of data References: <1ca6422a7addad0207f758f54300dd0b.squirrel@semichrome.net> In-Reply-To: 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 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200903/197 X-Sequence-Number: 33119 decibel wrote: > On Mar 10, 2009, at 4:12 PM, Steve McLellan wrote: >> The server itself is a dual-core 3.7GHz Xeon Dell (each core reporting 2 >> logical CPUs) running an amd64 build of FreeBSD 6.2, and postgres >> 8.3.5 built >> from source. > > Uh, you're running an amd64 build on top of an Intel CPU? I didn't think > FBSD would allow that, but if it does it wouldn't surprise me if > kernel/OS performance stunk. If Postgres then used the same settings it > would make matters even worse (IIRC there is some code that's different > in an AMD vs Intel build). Uh? Amd64 just the name of the FreeBSD port for AMD/Intel 64 bit CPUs. See: http://www.freebsd.org/platforms/amd64.html and: http://en.wikipedia.org/wiki/X86-64 Cheers -- Matteo Beccati OpenX - http://www.openx.org