Re: Chunk Delete

On 11/15/07, Abraham, Danny <danny_abraham@bmc.com> wrote:
> In Oracle we erase 50,000 records using the following:
>
> Delete <table name> where <condition> and ROWNUM < 50000;
>
> Do we have such a feature in PG?

Just delete with a subselect:

  delete from <table name> where <primary key> in (
    select <primary key> from <table name> order by <some sort key>
limit 50000);

For example:

  delete from persons where id in (
    select id from persons order by created_at limit 50000);

Alexander.