Re: help tuning queries on large database

Поиск
Список
Период
Сортировка
От Mark Lewis
Тема Re: help tuning queries on large database
Дата
Msg-id 1136939286.22590.27.camel@archimedes
обсуждение исходный текст
Ответ на Re: help tuning queries on large database  (Ron <rjpeace@earthlink.net>)
Ответы Re: help tuning queries on large database  (Ron <rjpeace@earthlink.net>)
Список pgsql-performance
Ron,

A few days back you mentioned:

> Upgrade your kernel to at least  2.6.12
> There's a known issue with earlier versions of the 2.6.x kernel and
> 64b CPUs like the Opteron.  See kernel.org for details.
>

I did some searching and couldn't find any obvious mention of this issue
(I gave up after searching through the first few hundred instances of
"64" in the 2.6.12 changelog).

Would you mind being a little more specific about which issue you're
talking about?  We're about to deploy some new 16GB RAM Opteron DB
servers and I'd like to check and make sure RH backported whatever the
fix was to their current RHEL4 kernel.

Thanks,
Mark Lewis

В списке pgsql-performance по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: NOT LIKE much faster than LIKE?
Следующее
От: "Dave Dutcher"
Дата:
Сообщение: Left Join Performance vs Inner Join Performance