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
