Re: best way to fetch next/prev record based on index

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: best way to fetch next/prev record based on index
Дата
Msg-id 29487.1090942399@sss.pgh.pa.us
обсуждение исходный текст
Ответ на best way to fetch next/prev record based on index  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Ответы Re: best way to fetch next/prev record based on index
Список pgsql-performance
Дерево обсуждения 
"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
> Plus, your where clause does not guarantee results.

No, but in combination with the ORDER BY it does.  Please note also
that the offset would *always* be one, so your gripe about it not
scaling seems misguided to me.

            regards, tom lane

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