Re: spinlock->pthread_mutex : first results with Jeff's pgbench+plsql - Mailing list pgsql-hackers

From Tom Lane
Subject Re: spinlock->pthread_mutex : first results with Jeff's pgbench+plsql
Date
Msg-id 19536.1341249235@sss.pgh.pa.us
Whole thread Raw
In response to Re: spinlock->pthread_mutex : first results with Jeff's pgbench+plsql  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> The delay code is stupider than it could be, in that it sleeps without
> regard to what's happening elsewhere in the system.  The futex stuff
> was interesting to me because it potentially provides a way to sleep
> "until something interesting happens" rather than "for a fixed amount
> of time".  But it's unclear to me what exactly we'd have to do to
> squeeze out a win, or even whether it's possible.

Right.  AFAICS, sleeping "until something happens" necessarily requires
adding overhead on the other side, ie, lock releasers will have to do
something extra to wake up sleepers.  If that means adding overhead
to low-contention cases, we could come out behind even if it improves
high-contention cases.  Tradeoffs, always tradeoffs ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Checkpointer on hot standby runs without looking checkpoint_segments
Next
From: Nils Goroll
Date:
Subject: away soon - spinlock->pthread_mutex : first results with Jeff's pgbench+plsql