Can we remove SnapshotSelf? - Mailing list pgsql-hackers

From Tom Lane
Subject Can we remove SnapshotSelf?
Date
Msg-id 19046.1108937442@sss.pgh.pa.us
Whole thread Raw
Responses Re: Can we remove SnapshotSelf?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
As of CVS tip, there is no code in the system that uses SnapshotSelf.
I am wondering if we can get rid of it and thereby save one test in
the heavily used HeapTupleSatisfiesVisibility() macro.

There is one place in the foreign-key triggers that uses the underlying
HeapTupleSatisfiesItself() test directly.  So it seems possible that we
might someday need SnapshotSelf again as the representation of the
appropriate snapshot test for a foreign-key check.  But I suspect that
any future changes in the FK stuff will go in the direction of using
dirty reads instead.  In any case we could always put back SnapshotSelf
if we needed it.

Comments?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: Query optimizer 8.0.1 (and 8.0)
Next
From: lsunley@mb.sympatico.ca
Date:
Subject: Re: SMP buffer management test question