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

From: Robert Creager <Robert(dot)Creager(at)Sun(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(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-18 16:29:43
Message-ID: 20051018102943.00001b8a@C118181.stortek.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 18 Oct 2005 00:25:25 +0100
Simon Riggs <simon(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Creager 2005-10-18 18:24:03 Re: Seeing context switch storm with 10/13 snapshot of
Previous Message Peter Eisentraut 2005-10-18 14:52:11 Call for translators