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?