Home > mailing lists

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

From	Gambhir Singh
Subject	Need an idea to operate massive delete operation on big size table.
Date	January 15 17:53:01
Msg-id	CAHOGQfWPQhxoyQ5GEUEFwtdXan=krr5Ue0DDPSKJGpcW9Szi4Q@mail.gmail.com Whole thread Raw
Responses	Re: Need an idea to operate massive delete operation on big size table. Re: Need an idea to operate massive delete operation on big size table.
List	pgsql-admin

Tree view

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

pgsql-admin by date:

From: Tom Lane
Date: 14 January, 17:27:53
Subject: Re: How to debug extension update

From: Ron Johnson
Date: 15 January, 18:08:32
Subject: Re: Need an idea to operate massive delete operation on big size table.

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

Previous

Next