Request a Demo
Home   >   mailing lists

Re: Need an idea to operate massive delete operation on big size table. - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Need an idea to operate massive delete operation on big size table.
Date
Msg-id CANzqJaDsDMzwf_YAN3_gXqdUji1GvJg-M4Bn-kW_UT5xy0HB-g@mail.gmail.com
Whole thread Raw
In response to Need an idea to operate massive delete operation on big size table.  (Gambhir Singh <gambhir.singh05@gmail.com>)
Responses Re: Need an idea to operate massive delete operation on big size table.
List pgsql-admin
Tree view
On Wed, Jan 15, 2025 at 9:54 AM Gambhir Singh <gambhir.singh05@gmail.com> wrote:
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

Maybe the delete "queries" are poorly written.  Maybe there's no supporting index.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

pgsql-admin by date:

Previous
From: Gambhir Singh
Date:
Subject: Need an idea to operate massive delete operation on big size table.
Next
From: youness bellasri
Date:
Subject: Re: Need an idea to operate massive delete operation on big size table.