Re: Postgres refusing to use >1 core

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Postgres refusing to use >1 core
Дата
Msg-id BANLkTinwkj7syvKkYzU_O7DD14EMzk2Zmg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres refusing to use >1 core  (Aren Cambre <aren@arencambre.com>)
Ответы Re: Postgres refusing to use >1 core
Список pgsql-performance
On Mon, May 9, 2011 at 10:15 PM, Aren Cambre <aren@arencambre.com> wrote:
>> Your OS won't *see* eight processors if you turn of HT.  :-)
>> I'm going to pursue this digression just a little further, because
>> it probably will be biting you sooner or later.  We make sure to
>> configure the BIOS on our database servers to turn off
>> hyperthreading.  It really can make a big difference in performance.
>
> OK, OK, I need to admit that this is a Core i7 720QM on an HP Envy 14
> laptop. :-) There is no BIOS option to disable HT.
> I am a doctoral student (but married with kids, about 5-10 years over
> traditional doctorate student age) and am trying to speed up some of my data
> analysis with parallelism. Right now the current operation,if run in series,
> takes 30 hours and only stresses one of the 8 (fake) cores. I'd rather see
> something that maximizes CPU use, provided that it doesn't overwhelm I/O.
> Aren

how are you reading through the table? if you are using OFFSET, you
owe me a steak dinner.

merlin

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Postgres refusing to use >1 core
Следующее
От: Aren Cambre
Дата:
Сообщение: Re: Postgres refusing to use >1 core