On 7/19/22 22: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
This looks like a case, going forward for partitioning:
https://www.postgresql.org/docs/14/ddl-partitioning.html
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
