"Pavan Deolasee" <pavan.deolasee@xxxxxxxxx> writes: > On 5/8/07, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: >> I forgot to mention that any other operation that examines every table >> row will fix all the hint bits as well. In particular a CREATE INDEX >> would do that --- > I might be missing something, but I think CREATE INDEX work on > SnapshotAny and hence may not actually examine any table row ? SnapshotAny is a no-op, but HeapTupleSatisfiesVacuum isn't. regards, tom lane
