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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Automagic tuning
Следующее
От: Markus Schaber
Дата:
Сообщение: Correction of best way to fetch next/prev record based on index