Need an idea to operate massive delete operation on big size table.

From: Gambhir Singh <gambhir(dot)singh05(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Need an idea to operate massive delete operation on big size table.
Date: 2025-01-15 14:53:01
Message-ID: CAHOGQfWPQhxoyQ5GEUEFwtdXan=krr5Ue0DDPSKJGpcW9Szi4Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I received a request from a client to delete duplicate records from a table
which is very large in size.

Delete queries (~2 Billion) are provided via file, and we have to execute
that file in DB. Last time it lasted for two days. I feel there must be
another way to delete records in an efficient manner

This kind of activity they do every month.

--
Thanks & Regards
Gambhir Singh

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2025-01-15 15:08:32 Re: Need an idea to operate massive delete operation on big size table.
Previous Message Tom Lane 2025-01-14 14:27:53 Re: How to debug extension update