Re: Page at a time index scan

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Page at a time index scan
Дата
Msg-id Pine.OSF.4.61.0605021946560.463955@kosh.hut.fi
обсуждение исходный текст
Ответ на Re: Page at a time index scan  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Page at a time index scan
Список 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

В списке pgsql-patches по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Page at a time index scan
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Page at a time index scan