Re: [GENERAL] Chunk Delete

[Alexander Staubo]

On 11/15/07, Abraham, Danny <[EMAIL PROTECTED]> 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.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings