On Thu, Aug 7, 2014 at 2:34 PM, Rod Taylor <rod.tay...@gmail.com> wrote: > This one is frequently sorted as batch operations against the files are > performed in alphabetical order to reduce conflict issues that a random > ordering may cause between jobs.
Sure. There are cases out there. But, again, I have a hard time imagining why you'd expect those to be pre-sorted in practice, and particularly why you'd feel justified in expecting that to sort much faster than equivalent though slightly imperfectly correlated data. Without that, the fmgr-elision aspect of sort support appears to offer enough for us to still win on balance [1], assuming 9.4 is our basis of comparison. [1] http://www.postgresql.org/message-id/cam3swzqhjxiyrsqbs5w3u-vtj_jt2hp8o02big5wyb4m9lp...@mail.gmail.com -- Peter Geoghegan -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
