Re: Chunk Delete

On 11/15/07, Abraham, Danny <danny_abraham(at)bmc(dot)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.