From: Matteo Beccati <php@beccati.com>
To: decibel <decibel@decibel.org>
Cc: Steve McLellan <smclellan@mintel.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Query performance over a large proportion of data
Date: Sun, 15 Mar 2009 03:38:17 +0100
Message-ID: <49BC6A19.9090802@beccati.com> (raw)
In-Reply-To: <E343A7FA-03EA-4320-9DBD-F1EEEFC6EB3E@decibel.org>
References: <1ca6422a7addad0207f758f54300dd0b.squirrel@semichrome.net>
<E343A7FA-03EA-4320-9DBD-F1EEEFC6EB3E@decibel.org>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: php@beccati.com, decibel@decibel.org, smclellan@mintel.com
Subject: Re: Query performance over a large proportion of data
In-Reply-To: <49BC6A19.9090802@beccati.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox