2009/5/9 Tom Lane <tgl@xxxxxxxxxxxxx>:
> Merlin Moncure <mmoncure@xxxxxxxxx> writes:
>> On Fri, May 8, 2009 at 5:40 PM, Alvaro Herrera
>> <alvherre@xxxxxxxxxxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
