Re: limit-offset different result sets with same query

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: limit-offset different result sets with same query
Дата
Msg-id 9654.1241890083@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: limit-offset different result sets with same query  (Merlin Moncure <mmoncure@gmail.com>)
Ответы Re: limit-offset different result sets with same query  (David Fetter <david@fetter.org>)
Re: limit-offset different result sets with same query  (Emanuel Calvo Franco <postgres.arg@gmail.com>)
Список pgsql-general
Merlin Moncure <mmoncure@gmail.com> writes:
> On Fri, May 8, 2009 at 5:40 PM, Alvaro Herrera
> <alvherre@commandprompt.com> wrote:
>> Yeah, we went over this on the spanish list, turned out that I couldn't
>> remember about syncscan :-)

> I like the new behavior.  It really encourages proper use of order by,
> because the natural ordering results are effectively randomized.  A
> class of subtle bugs has been made obvious.  :)

Not really, because the syncscan behavior only kicks in when your table
gets large ... you'll never see it during devel testing on toy tables ...

            regards, tom lane

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: limit-offset different result sets with same query
Следующее
От: Juan Camilo Marín
Дата:
Сообщение: lack in psql console