Re: Page at a time index scan

From: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Page at a time index scan
Date: 2006-05-02 19:21:09
Message-ID: Pine.OSF.4.61.0605021946560.463955@kosh.hut.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

On Tue, 2 May 2006, Tom Lane wrote:

>>> Agreed. The pin has two functions:
>>> - keep the page from being moved out of the bufmgr - no need anymore
>>> - stop a vacuum from removing the page - no need anymore. We'll not stop
>>> on a removable row anymore, so no need.
>
>> At the moment, backward scan returns to the page to walk left from there.
>
> Backwards scan may break this whole concept; are you sure you've thought
> it through?

I think so. The patch doesn't change the walk-left code. Do you have
something specific in mind?

- Heikki

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2006-05-02 19:31:05 Re: Page at a time index scan
Previous Message Martijn van Oosterhout 2006-05-02 19:19:22 Re: patch review, please: Autovacuum/Vacuum times via stats.