"Heikki Linnakangas" <heikki@enterprisedb.com> writes:
> Tom Lane wrote:
>> BTW, the proposed HOT code in indexam.c that special-cases SnapshotAny
>> is a crock ...
> It was written under the assumption that all tuples in a HOT chain have
> the same index key, which isn't true after CREATE INDEX as you pointed
> out. Is there something else wrong with it?
It's the wrong special case. It should assume that *all* non-MVCC
snapshots require walking the whole chain.
regards, tom lane