Re: [HACKERS] HOT breaks CLUSTER, a bit

2007-09-12 Thread Tom Lane
"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

Re: [HACKERS] HOT breaks CLUSTER, a bit

2007-09-12 Thread Heikki Linnakangas
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 i

[HACKERS] HOT breaks CLUSTER, a bit

2007-09-11 Thread Tom Lane
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 cr