Re: Some interesting results from tweaking spinlocks - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Some interesting results from tweaking spinlocks
Date
Msg-id 9837.1010206146@sss.pgh.pa.us
Whole thread Raw
In response to Re: Some interesting results from tweaking spinlocks  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Some interesting results from tweaking spinlocks  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> The difference is small, perhaps 15%.

The thing that gets my attention is not that it's so small, it's that
it is so large.  My expectation was that that code would hardly ever
be executed at all, and even less seldom (on a multiprocessor) need to
block via select().  How is it that *increasing* the delay interval
(which one might reasonably expect to simply waste cycles) can achieve
a 15% improvement in total throughput?  That shouldn't be happening.

> My feeling is that we may want to start configuring whether we are on
> a multi-cpu machine and handle thing differently.

That would be more palatable if there were some portable way of
detecting it.  But maybe we'll be forced into an "is_smp" GUC switch.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Some interesting results from tweaking spinlocks
Next
From: Bruce Momjian
Date:
Subject: Re: Some interesting results from tweaking spinlocks