Re: Seeing context switch storm with 10/13 snapshot of

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