View Single Post

   
  #8 (permalink)  
Old 04-18-2008, 12:35 AM
Heikki Linnakangas
 
Posts: n/a
Default Re: Page at a time index scan

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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Reply With Quote