On Tue, Oct 9, 2012 at 2:40 AM, Craig James <cjames@xxxxxxxxxxxxxx> wrote: > Nobody has commented on the hyperthreading question yet ... does it really > matter? The old (fast) server has hyperthreading disabled, and the new > (slower) server has hyperthreads enabled. > > If hyperthreading is definitely NOT an issue, it will save me a trip to the > co-lo facility. Hyperthreading will make lock contention issues worse by having more threads fighting. Test the new box with postgres 9.2, if the newer version exhibits much better scaling behavior it strongly suggest lock contention rather than IO being the root cause. Ants Aasma -- Cybertec Schönig & Schönig GmbH Gröhrmühlgasse 26 A-2700 Wiener Neustadt Web: http://www.postgresql-support.de -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
