Re: Spinlocks, yet again: analysis and proposed patches - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Spinlocks, yet again: analysis and proposed patches
Date
Msg-id 28419.1126665779@sss.pgh.pa.us
Whole thread Raw
In response to Re: Spinlocks, yet again: analysis and proposed patches  ("Min Xu (Hsu)" <xu@cs.wisc.edu>)
Responses Re: Spinlocks, yet again: analysis and proposed patches
List pgsql-hackers
"Min Xu (Hsu)" <xu@cs.wisc.edu> writes:
> ...If this were the case, perhaps first fetch the spin lock with read-only
> permission should have helped.

But the cmpb instruction in the 8.0 version of TAS would have done that,
and I think we've already established that the cmpb is a loss on most
machines (except maybe single-physical-CPU Xeons).  I suggested in my
other message that it might help to grab write permission on the cache
line before actually trying to acquire the spin lock --- but I don't see
how getting read-only permission first will help.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: 8.1 system info / admin functions
Next
From: Tom Lane
Date:
Subject: Re: Spinlocks, yet again: analysis and proposed patches