Re: Hyperthreading (was: Two identical systems, radically different performance)

Craig James <cjames@emolecules.com> writes:
> I've confirmed that hyperthreading causes a huge drop in performance on a
> 2x4-core Intel Xeon E5620 2.40GHz system.  The bottom line is:

Interesting.

> I'll be upgrading to 8.4.14 and making more changes to postgres.conf based
> on feedback.  The server is available for a day or so for more tests if
> anyone has suggestions.

It would be nice to see similar tests done with 9.2.  8.4 is kind of old
news as far as server performance is concerned.

            regards, tom lane