Re: Spinlocks, yet again: analysis and proposed patches

Josh Berkus <josh@agliodbs.com>

From: Josh Berkus <josh@agliodbs.com>
To: pgsql-hackers@postgresql.org
Cc: Tom Lane <tgl@sss.pgh.pa.us>, gmaxwell@gmail.com, Gavin Sherry <swm@linuxworld.com.au>, Marko Kreen <marko@l-t.ee>, Michael Paesold <mpaesold@gmx.at>
Date: 2005-09-16T16:40:25Z
Lists: pgsql-hackers
Tom,

> What I think this means is that the kernel is scheduling the 2 processes
> onto 2 processors chosen-at-random, without awareness of whether those
> two processors are on the same chip (in the Xeon case) or have closer
> NUMA affinity (in the Opteron case).

That would be consistent with my experience with HT, and the reason why many 
software vendors recommend disabling it.  Not sure about NUMA.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco