Re: Index Skip Scan

Поиск
Список
Период
Сортировка
От Dmitry Dolgov
Тема Re: Index Skip Scan
Дата
Msg-id 20200122213716.ghvobtxsrfncjyye@localhost
обсуждение исходный текст
Ответ на RE: Index Skip Scan  (Floris Van Nee <florisvannee@Optiver.com>)
Список pgsql-hackers
> On Wed, Jan 22, 2020 at 09:08:59PM +0000, Floris Van Nee wrote:
> > Note in particular that index scans cannot return the same index tuple twice -
> > - processing a page at a time ensures that that cannot happen.
> >
> > Can a loose index scan return the same tuple (i.e. a tuple with the same heap
> > TID) to the executor more than once?
> >
>
> The loose index scan shouldn't return a tuple twice. It should only be able to skip 'further', so that shouldn't be a
problem.

Yes, it shouldn't happen.



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

Предыдущее
От: Dmitry Dolgov
Дата:
Сообщение: Re: Index Skip Scan
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pgsql: Fix crash in BRIN inclusion op functions, due to missingdatum c