Re: Index trouble with 8.3b4 - Mailing list pgsql-hackers

From Jeff Davis
Subject Re: Index trouble with 8.3b4
Date
Msg-id 1200346158.10057.438.camel@dogma.ljc.laika.com
Whole thread Raw
In response to Re: Index trouble with 8.3b4  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Index trouble with 8.3b4  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: to_char incompatibility
Next
From: "Roberts, Jon"
Date:
Subject: Re: to_char incompatibility