Re: Synchronized scans

On Mon, 2007-06-04 at 10:53 +0100, Heikki Linnakangas wrote:
> I'm now done with this patch and testing it.
>
>

One difference between our patches is that, in my patch, the ending
condition of the scan is after the hint is set back to the starting
position.

That means, in my patch, if you do:
SELECT * FROM bigtable;
SELECT * FROM bigtable;

with no concurrency at all, the returned order will be the same.

In your patch, each full table scan leaves the hint at 16 pages before
the position it started in, leading to different orders on the full
table scans.

Regards,
    Jeff Davis