Re: Query performance over a large proportion of data

Поиск
Список
Период
Сортировка
От decibel
Тема Re: Query performance over a large proportion of data
Дата
Msg-id E343A7FA-03EA-4320-9DBD-F1EEEFC6EB3E@decibel.org
обсуждение исходный текст
Ответ на Query performance over a large proportion of data  ("Steve McLellan" <smclellan@mintel.com>)
Ответы Re: Query performance over a large proportion of data  (Matteo Beccati <php@beccati.com>)
Список 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 по дате отправления:

Предыдущее
От: decibel
Дата:
Сообщение: Re: Query much slower when run from postgres function
Следующее
От: decibel
Дата:
Сообщение: Re: Proposal of tunable fix for scalability of 8.4