On Tuesday 24 November 2009, Thom Brown <thombr...@gmail.com> wrote: > > It's a shame there isn't a LIMIT option on DELETE so this can be done in > small batches.
delete from table where pk in (select pk from table where delete_condition limit X); -- "No animals were harmed in the recording of this episode. We tried but that damn monkey was just too fast." -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance