On Sun, 2008-01-13 at 18:52 -0500, Tom Lane wrote:
> The scan is done using the regular heapscan code, which in 8.3 has been
> modified to enable "synchronized scanning", which means it might start
> from the middle of the table and wrap around. If that happens, the
> "merge join" will get totally confused because it is expecting the
Thank you and Hannes Dorbath for tracking this down.
> I wonder whether there are any other places that are silently assuming
> that heapscans start from page zero ...
>
I considered that question when implementing sync scans, but I could not
think of any specific areas of the code that would likely be affected.
Regards,Jeff Davis