On 7/11/07, Andrew Sullivan <ajs@xxxxxxxxxxxxxxx> wrote:
On Tue, Jul 10, 2007 at 08:09:11PM +0200, Adrian von Bidder wrote: > If your operating system is able to schedule the threads/processes across > CPUs, PostgreSQL will use them. But notice that hyperthreading imposes its own overhead. I've not seen evidence that enabling hyperthreading actually helps, although I may have overlooked a couple of cases.
I don't have any metrics of my own to present (nor do I care enough to try and gather them), but there are a few tests with kind of varied results, depending on WHAT one wants to use HT for. Have a look at these: http://www.ibm.com/developerworks/linux/library/l-htl/ http://www.2cpu.com/articles/41_6.html In how far they're relevant to Postgres is left as an exercise to the reader :}
A
Cheers, Andrej -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.american.edu/econ/notes/htmlmail.htm