Re: [PERFORM] Context switching and Xeon processors

2005-12-06 Thread Steinar H. Gunderson
On Tue, Dec 06, 2005 at 03:01:02PM -0600, Brandon Metcalf wrote: > We're running a dual Xeon machine with hyperthreading enabled and > PostgreSQL 8.0.3. The two single most important things that will help you with high rates of context switching: - Turn off hyperthreading. - Upgrade to 8.1.

Re: [PERFORM] Context switching and Xeon processors

2005-12-06 Thread Brandon Metcalf
t == [EMAIL PROTECTED] writes: t> "Brandon Metcalf" <[EMAIL PROTECTED]> writes: t> > We've been tuning the kernel (2.4 SMP flavor) and have improved t> > performance quite a bit. I'm now wondering if turning off HT will t> > improve performance even more. Based on the vmstat output below, is

Re: [PERFORM] Context switching and Xeon processors

2005-12-06 Thread Tom Lane
"Brandon Metcalf" <[EMAIL PROTECTED]> writes: > We've been tuning the kernel (2.4 SMP flavor) and have improved > performance quite a bit. I'm now wondering if turning off HT will > improve performance even more. Based on the vmstat output below, is > the context switching typical or too high? G

[PERFORM] Context switching and Xeon processors

2005-12-06 Thread Brandon Metcalf
We're running a dual Xeon machine with hyperthreading enabled and PostgreSQL 8.0.3. Below is the type of CPUs: processor : 3 vendor_id : GenuineIntel cpu family : 15 model : 4 model name : Intel(R) Xeon(TM) CPU 3.20GHz stepping: 1 cpu MHz