Re: unlogged tables vs. GIST - Mailing list pgsql-hackers

From Tom Lane
Subject Re: unlogged tables vs. GIST
Date
Msg-id 6126.1292620676@sss.pgh.pa.us
Whole thread Raw
In response to Re: unlogged tables vs. GIST  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: unlogged tables vs. GIST  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
[ hit send too soon ... ]

Robert Haas <robertmhaas@gmail.com> writes:
> Since these bits will only be set/cleared when the buffer mapping is
> changed, can we examine this bit without taking the spinlock?

Only if you're willing for the result to be unreliable.  In the
case of the xlog flush bit, I don't believe an extra locking cycle
should be necessary anyway, as you surely had the lock when you 
found the page to be dirty in the first place.  You could grab the
bit then.  I'm not sure where you envision checking the other bit,
but I doubt it can be all that far removed from a lock acquisition.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: unlogged tables vs. GIST
Next
From: Alvaro Herrera
Date:
Subject: Re: ps_status on fastpath