Postgres Pro
Downloads
Home   >   mailing lists

Re: Seeing context switch storm with 10/13 snapshot of - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Seeing context switch storm with 10/13 snapshot of
Date
Msg-id 1129839558.8300.744.camel@localhost.localdomain
Whole thread Raw
In response to Re: Seeing context switch storm with 10/13 snapshot of  (Robert Creager <Robert.Creager@Sun.com>)
Responses Re: Seeing context switch storm with 10/13 snapshot of
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: [GENERAL] 'a' == 'a '
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] 'a' == 'a '