Re: Buffer access rules, and a probable bug - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Buffer access rules, and a probable bug
Date
Msg-id 26901.994217376@sss.pgh.pa.us
Whole thread Raw
In response to Re: Buffer access rules, and a probable bug  (ncm@zembu.com (Nathan Myers))
Responses Re: Buffer access rules, and a probable bug
List pgsql-hackers
ncm@zembu.com (Nathan Myers) writes:
> Here, backend B is a good citizen and locks while it makes its change.

No, backend B wasn't a good citizen: it should have been holding
exclusive lock on the buffer.

> Also, as hints, would it be Bad(tm) if an attempt to clear one failed?

Clearing hint bits is also an exclusive-lock-only operation.  Notice
I specified that *setting* them is the only case allowed to be done
with shared lock.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: stuck spin lock with many concurrent users
Next
From: Zeugswetter Andreas SB
Date:
Subject: AW: Re: Backup and Recovery