Re: Chunk Delete
| От | Abraham, Danny |
|---|---|
| Тема | Re: Chunk Delete |
| Дата | |
| Msg-id | F8B9B12641FB6B4FAC761BDEF9D63B040F46F99E@tlv-ex-01.adprod.bmc.com обсуждение исходный текст |
| Ответ на | Chunk Delete ("Abraham, Danny" <danny_abraham@bmc.com>) |
| Ответы |
Re: Chunk Delete
Re: Chunk Delete Re: Chunk Delete |
| Список | pgsql-general |
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?
В списке pgsql-general по дате отправления: