[GENERAL] Chunk Delete

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? Received on Thu Nov 15 08:36:00 2007