|
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? |
