Re: Page access pattern in query plan using index scan

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

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.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
Licensee shall have no right to use the Licensed Software
for productive or commercial use. (Licencia de StarOffice 6.0 beta)

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jack Orenstein 2004-06-03 03:07:45 Re: Page access pattern in query plan using index scan
Previous Message Bruce Momjian 2004-06-03 01:29:10 Re: PostgreSQL Tablespaces