Search Postgresql Archives

Re: Chunk Delete

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux