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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
