From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Rama Krishnan <raghuldrag(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Batch process |
Date: | 2022-07-20 15:07:54 |
Message-ID: | 375897a0-fbbb-8712-8164-8fbd3cab074a@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Rama Krishnan | 2022-07-20 15:26:26 | Re: Batch process |
Previous Message | David G. Johnston | 2022-07-20 14:57:58 | Re: postgis |