Tom Lane wrote:
While editing Bruce's README.HOT documentation I ran into a problem.
I had idly added the following text after thinking about the different
sorts of snapshots we use:
---
Another unpleasant consequence is that it is no longer very meaningful to
use SnapshotAny in an index
Heikki Linnakangas [EMAIL PROTECTED] 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
While editing Bruce's README.HOT documentation I ran into a problem.
I had idly added the following text after thinking about the different
sorts of snapshots we use:
---
Another unpleasant consequence is that it is no longer very meaningful to
use SnapshotAny in an index scan: if the index was