|From:||Thom Brown <thombrown(at)gmail(dot)com>|
|Subject:||Feature request: limited deletions|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
I couldn't find any discussion on this, but the request is quite
straightforward. Implement a LIMIT on DELETE statements like SELECT
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.
... although I suspect there will be reasons against this.
|Next Message||Ian Barwick||2010-04-08 10:55:30||Re: Feature request: limited deletions|
|Previous Message||Erwin Brandstetter||2010-04-07 17:47:12||Missing RULEs from VIEWs and their format|
|Next Message||Simon Riggs||2010-04-08 10:16:12||Re: Hot Standby: Startup at shutdown checkpoint|
|Previous Message||Tom Lane||2010-04-08 08:53:40||Re: Oddly indented raw_expression_tree_walker|