From: | David Boreham <david_list(at)boreham(dot)org> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: HT on or off for E5-26xx ? |
Date: | 2012-11-07 13:45:25 |
Message-ID: | 509A65F5.2020306@boreham.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On 11/7/2012 6:37 AM, Devrim GÜNDÜZ wrote:
> HT should be good for file servers, or say many of the app servers, or
> small web/mail servers. PostgreSQL relies on the CPU power, and since
> the HT CPUs don't have the same power as the original CPU, when OS
> submits a job to that particular HTed CPU, query will run significantly
> slow. To avoid issues, I would suggest you to turn HT off on all
> PostgreSQL servers. If you can throw some more money, another 6-core CPU
> would give more benefit.
I realize this is the "received knowledge" but it is not supported by
the evidence before me (which is that I get nearly 2x the throughput
from pgbench using nthreads == nhtcores vs nthreads == nfullcores).
Intel's latest HT implementation seems to suffer less from the kinds of
resource sharing contention issues seen in older generations.
Once I have the machine's full memory installed I'll run pgbench with HT
disabled in the BIOS and post the results.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-11-07 15:02:37 | Re: [HACKERS] pg_dump and thousands of schemas |
Previous Message | Devrim GÜNDÜZ | 2012-11-07 13:37:24 | Re: HT on or off for E5-26xx ? |