On Wed, Apr 20, 2005 at 11:09:19AM -0700, Josh Berkus wrote: > At OSDL we're seeing a wierd performance crash on 8.1cvs. What's wierd > about > it is that it doesn't happen all the time -- about 1 out of 4 test runs. > What it looks like happens sometimes is that performance drops dramatically > at the first checkpoint, and never comes back. But there's oprofiles and > things to make a more insightful analysis:
What is the "wait" line in the Processor Utilization graphic? Does it have anything to do with spinlocks? Was it so high in 8.0 tests? -- Alvaro Herrera (<[EMAIL PROTECTED]>) Jude: I wish humans laid eggs Ringlord: Why would you want humans to lay eggs? Jude: So I can eat them ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match