On Tue, 2005-10-18 at 12:24 -0600, Robert Creager wrote: > Robert Creager <[EMAIL PROTECTED]> wrote: > > Simon Riggs <[EMAIL PROTECTED]> wrote: > > > Please try this patch and see if it reduces the CS storm:
> Sorry, didn't work. Took about an hour, and now it's now at the CS storm > (averaging 94k). I've now disabled auto vacuum, just to see if that is a > trigger, and am re-running. OK, thanks. There was a possibility that there was some issue with the spinlock code inadvertently grabbing a cache line with another lock in it. Try this to recreate the problem: http://archives.postgresql.org/pgsql-performance/2004-04/msg00280.php Best Regards, Simon Riggs ---------------------------(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
