Re: Page access pattern in query plan using index scan

From: Jack Orenstein <jao(at)geophile(dot)com>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Page access pattern in query plan using index scan
Date: 2004-06-03 03:07:45
Message-ID: 40BE9601.3030608@geophile.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2004-06-03 03:34:32 Re: Page access pattern in query plan using index scan
Previous Message Alvaro Herrera 2004-06-03 02:53:53 Re: Page access pattern in query plan using index scan