Re: Page access pattern in query plan using index scan

Alvaro Herrera wrote:
> On Wed, Jun 02, 2004 at 08:38:58PM -0400, Jack Orenstein wrote:
>
>
>>What is the pattern of access to data pages? I can think of two likely
>>answers:
>>
>>1) The index is scanned for ages 30 through 40. As each index entry is
>>scanned, a row is retrieved.
>
>
> This one.  There have been noises about doing the second, but it's non
> trivial and there's no hacker currently working on it.  Not to be
> expected on the next version, I'd think.

Can you recommend an application-level workaround that will access pages
in the right order?

Jack Orenstein