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. /* Steinar */ -- Homepage: http://www.sesse.net/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
