Re: Query performance over a large proportion of data - Mailing list pgsql-performance

From decibel
Subject Re: Query performance over a large proportion of data
Date
Msg-id E343A7FA-03EA-4320-9DBD-F1EEEFC6EB3E@decibel.org
Whole thread Raw
In response to Query performance over a large proportion of data  ("Steve McLellan" <smclellan@mintel.com>)
Responses Re: Query performance over a large proportion of data
List pgsql-performance
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).
--
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828



pgsql-performance by date:

Previous
From: decibel
Date:
Subject: Re: Query much slower when run from postgres function
Next
From: decibel
Date:
Subject: Re: Proposal of tunable fix for scalability of 8.4