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

From Tom Lane
Subject Re: Seeing context switch storm with 10/13 snapshot of
Date
Msg-id 25797.1129929473@sss.pgh.pa.us
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
Re: Seeing context switch storm with 10/13 snapshot of
List pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> Certainly there is a lack of ideas as to how to fix it, as you mention
> in (3). This shows to me that the solution lies in one of two areas: a)
> the solution has not yet been considered or b) the solution has already
> been thought of and for whatever reason disregarded. You may be certain
> that the solution lies in a), though I am not. Rejecting ideas quickly
> may simply increase the chances of finding the solution in a b) case.

However, building a spinlock test harness presupposes that the solution
lies in the spinlock code itself, and not in (say) changing our usage
patterns of it.  So I'd throw the "rejecting ideas too quickly"
challenge right back at you.  What we need to optimize is the behavior
in the real context of Postgres, not in a test harness.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [PATCHES] Win32 CHECK_FOR_INTERRUPTS() performance tweak
Next
From: Neil Conway
Date:
Subject: Re: [COMMITTERS] pgsql: Do all accesses to shared buffer