Say we have a FIFO of 800,000,000 records.
No primary key is required – this is only audit information. We do not use it on Oracle too.
Based on a condition, 2,000,000 records should be deleted daily.
We have a background process that wakes up every X minutes and deletes Y records.
With Oracle we do it with: delete ,tname> where <cond> and rownum < Y;
Can we have the same goody on Postgres?
