Re: limit-offset different result sets with same query

Поиск
Список
Период
Сортировка
От Emanuel Calvo Franco
Тема Re: limit-offset different result sets with same query
Дата
Msg-id f205bb120905110519n6b2d7b4brc2ce3c7aa4ca2fcc@mail.gmail.com
обсуждение исходный текст
Ответ на Re: limit-offset different result sets with same query  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
2009/5/9 Tom Lane <tgl@sss.pgh.pa.us>:
> 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
>

Yeap. If you see one of the test i made, you'll see this switch over the
~100 regs.


--
      Emanuel Calvo Franco
        Sumate al ARPUG !
        ( www.arpug.com.ar)
    ArPUG / AOSUG Member

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

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: Controlling psql output
Следующее
От: Jasen Betts
Дата:
Сообщение: Re: Remote access