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

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