Re: Postgres refusing to use >1 core - Mailing list pgsql-performance

From Aren Cambre
Subject Re: Postgres refusing to use >1 core
Date
Msg-id BANLkTi=FH4rX-7OtS9ozjuyXQTNTiRqCmg@mail.gmail.com
Whole thread Raw
In response to Re: Postgres refusing to use >1 core  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Postgres refusing to use >1 core
Re: Postgres refusing to use >1 core
List 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 by date:

Previous
From: Aren Cambre
Date:
Subject: Re: Postgres refusing to use >1 core
Next
From: Scott Marlowe
Date:
Subject: Re: Postgres refusing to use >1 core