On Tue, 2005-10-18 at 12:24 -0600, Robert Creager wrote:
> Robert Creager <Robert.Creager@sun.com> wrote:
> > Simon Riggs <simon@2ndquadrant.com> 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