On Thu, Apr 8, 2010 at 7:05 AM, Thom Brown <thombr...@gmail.com> wrote: > On 8 April 2010 11:55, Ian Barwick <barw...@gmail.com> wrote: >> >> 2010/4/8 Thom Brown <thombr...@gmail.com>: >> > I couldn't find any discussion on this, but the request is quite >> > straightforward. Implement a LIMIT on DELETE statements like SELECT >> > statements. >> > >> > So you could write: >> > >> > DELETE FROM massive_table WHERE id < 40000000 LIMIT 10000; >> > >> > This would allow deletions in smaller batches rather than waiting >> > potentially hours for the server to mark all those rows as deleted and >> > commit it as one massive transaction. >> >> Is this a PgAdmin-specific question? If it is, apologies I am missing >> the context. >> >> If not, this is totally the wrong list, but why not use a subquery to >> control what is deleted? > > Erm... my mistake, I thought this was on the generic hackers list. Moving > it over in this reply.
I've certainly worked around the lack of this syntax more than once. And I bet it's not even that hard to implement. ...Robert -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
