On Mon, Nov 29, 2010 at 10:50 PM, Marti Raudsepp <ma...@juffo.org> wrote: > On Tue, Nov 30, 2010 at 05:09, Jaime Casanova <ja...@2ndquadrant.com> wrote: >> at least IMHO the only sensible way that LIMIT is usefull is with >> an ORDER BY clause with make the results very well defined... > > DELETE with LIMIT is also useful for deleting things in batches, so > you can do large deletes on a live system without starving other users > from I/O. In this case deletion order doesn't matter (it's more > efficient to delete rows in physical table order) -- ORDER BY isn't > necessary. > > Regards, > Marti >
++ I have a lot of DELETE with LIMIT in my (mysql) environment for this reason. -- Rob Wultsch wult...@gmail.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
