Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Seeing context switch storm with 10/13 snapshot of 8.1beta3
Date
Msg-id 5458.1129260445@sss.pgh.pa.us
Whole thread Raw
In response to Re: Seeing context switch storm with 10/13 snapshot of  (Robert Creager <Robert_Creager@LogicalChaos.org>)
List pgsql-hackers
Tree view 
Robert Creager <Robert_Creager@LogicalChaos.org> writes:
> Is there anything I might be able to do (without the test case) that
> would help figure out what's happening?

oprofile stats would be enlightening, perhaps.

I'm particularly interested in why 7.4 is behaving better than newer
versions --- that does not compute ;-).  Have you checked that the same
query plan is being used by 7.4 and the newer versions?  Could you get
oprofile results for both versions?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Robert Creager
Date:
Subject: Re: Seeing context switch storm with 10/13 snapshot of
Next
From: "Michael Paesold"
Date:
Subject: Re: [PATCHES] [BUGS] BUG #1962: ECPG and VARCHAR