| From: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | Robert Creager <Robert(dot)Creager(at)Sun(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PGHackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Seeing context switch storm with 10/13 snapshot of |
| Date: | 2005-10-20 20:19:18 |
| Message-ID: | 1129839558.8300.744.camel@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, 2005-10-18 at 12:24 -0600, Robert Creager wrote:
> Robert Creager <Robert(dot)Creager(at)sun(dot)com> wrote:
> > Simon Riggs <simon(at)2ndquadrant(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2005-10-20 20:40:34 | Re: 8.04 and RedHat/CentOS init script issue and sleep |
| Previous Message | Tom Lane | 2005-10-20 20:11:23 | Re: [HACKERS] 'a' == 'a ' |