Re: Batch process
| От | Adrian Klaver |
|---|---|
| Тема | Re: Batch process |
| Дата | |
| Msg-id | eab2ed8d-785f-8992-3890-fb28dd38ec78@aklaver.com обсуждение исходный текст |
| Ответ на | Re: Batch process (Ron <ronljohnsonjr@gmail.com>) |
| Ответы |
Re: Batch process
|
| Список | pgsql-general |
On 7/20/22 01:28, Ron wrote: > On 7/20/22 00:08, Rama Krishnan wrote: >> Hi All, >> >> I am doing purge activity my sales table contains 5M records I am >> going to delete more than 1 year data (which was 3M) records so it was >> running more so I want to do batch wise deletion through plsql >> >> >> >> >> created or replace function data_purge() returns void as$$ >> Declare >> Begin >> Drop table test_old; >> Create table test_old as select * from sales where bill_date<now() >> -interval '1 year'; >> >> Delete table sales where sales_id in (select sales_id from test_old; >> >> End; >> $$ language plpgsql; >> >> >> Kindly guide me > > Why not just DELETE FROM sales WHERE bill_date<NOW() -INTERVAL '1 year';? > Because it looks like the OP is saving the old records in test_old. -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления: