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

From Robert Creager
Subject Re: Seeing context switch storm with 10/13 snapshot of
Date
Msg-id 20051018102943.00001b8a@C118181.stortek.com
Whole thread Raw
In response to Re: Seeing context switch storm with 10/13 snapshot of  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: Seeing context switch storm with 10/13 snapshot of
List pgsql-hackers
On Tue, 18 Oct 2005 00:25:25 +0100
Simon Riggs <simon@2ndquadrant.com> wrote:
> 
> Please try this patch and see if it reduces the CS storm:
> 
> http://archives.postgresql.org/pgsql-patches/2005-10/msg00091.php

Yes, I will.  I'd been trying to figure out what triggered it, as I was unable
to reproduce it for a while, but it gets there eventually.  I had just
re-started with auto vacuum off, as that might be the trigger?  I'll apply the
patch, re-build and re-start with auto vacuum back on, they way I'm running when
I know I'll see it.

> 
> Do you have access to another similar machine to do comparative testing?
> Do you have access to another machine with different CPU arch? It would
> be good to firmly isolate this to a CPU architecture interaction issue.

I do have access to a windows version of the DL-380 but it's only a single CPU. 
I've a dual AMD server at home, but I cannot run against the db there (reverse
VPN?).  I'd need that reproducibility Tom wanted that I have not gotten to yet.

> 
> Are the Xeons particularly old models? How new is the server?

It is a HP Proliant (post Compaq merger) DL-380.  A couple years old.

Thanks,
Rob



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Call for translators
Next
From: Robert Creager
Date:
Subject: Re: Seeing context switch storm with 10/13 snapshot of