Re: Postgres refusing to use >1 core

Поиск
Список
Период
Сортировка
От Aren Cambre
Тема Re: Postgres refusing to use >1 core
Дата
Msg-id BANLkTi=FH4rX-7OtS9ozjuyXQTNTiRqCmg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres refusing to use >1 core  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Ответы Re: Postgres refusing to use >1 core  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Postgres refusing to use >1 core  (Merlin Moncure <mmoncure@gmail.com>)
Список pgsql-performance
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

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

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