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?