Hi, On Tue, 2012-11-06 at 20:31 -0700, David Boreham wrote: > Was assuming it was 6-core but I just noticed it has HT which is > currently enabled since I see 12 cores in /proc/cpuinfo > > Question for the performance experts : is it better to have H enabled > or disabled for this generation of Xeon ? Workload will be moderately > concurrent, small OLTP type transactions. We'll also run a few > low-load VMs (using KVM) and big Java application. 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. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachment:
signature.asc
Description: This is a digitally signed message part
