On 11/15/07, Abraham, Danny <danny_abraham@xxxxxxx> 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
