On Wed, Dec 28, 2011 at 8:45 AM, Greg Stark <st...@mit.edu> wrote: > On Tue, Dec 27, 2011 at 10:43 PM, Merlin Moncure <mmonc...@gmail.com> wrote: >> I bet if you kept a judicious number of >> clog pages in each local process with some smart invalidation you >> could cover enough cases that scribbling the bits down would become >> unnecessary. > > I don't understand how any cache can completely remove the need for > hint bits. Without hint bits the xids in the tuples will be "in-doubt" > forever. No matter how large your cache you'll always come across > tuples that are arbitrarily old and are from an unbounded size set of > xids.
well, hint bits aren't needed strictly speaking, they are an optimization to guard against clog lookups. but is marking bits on the tuple the only way to get that effect? I'm conjecturing that some process local memory could be laid on top of the clog slru that would be fast enough such that it could take the place of the tuple bits in the visibility check. Maybe this could reduce clog contention as well -- or maybe the idea is unworkable. That said, it shouldn't be that much work to make a proof of concept to test the idea. > We could replace the xids with a frozen xid sooner but that just > amounts to nearly the same thing as the hint bits only with page > locking and wal records. right -- I don't think that helps. merlin -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers