MIME-Version: 1.0
From: Gambhir Singh <gambhir.singh05@gmail.com>
Date: Wed, 15 Jan 2025 20:23:01 +0530
Message-ID: 
 <CAHOGQfWPQhxoyQ5GEUEFwtdXan=krr5Ue0DDPSKJGpcW9Szi4Q@mail.gmail.com>
Subject: Need an idea to operate massive delete operation on big size table.
To: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000000cfd47062bbfd9c6"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHOGQfWPQhxoyQ5GEUEFwtdXan%3Dkrr5Ue0DDPSKJGpcW9Szi4Q%40mail.gmail.com>
Precedence: bulk

--0000000000000cfd47062bbfd9c6
Content-Type: text/plain; charset="UTF-8"

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

--0000000000000cfd47062bbfd9c6
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div class=3D"gmail_default" style=3D"font-family:tah=
oma,sans-serif;font-size:small;color:rgb(0,0,0)">Hi,</div><div class=3D"gma=
il_default" style=3D"font-family:tahoma,sans-serif;font-size:small;color:rg=
b(0,0,0)"><br></div><div class=3D"gmail_default" style=3D"font-family:tahom=
a,sans-serif;font-size:small;color:rgb(0,0,0)">I received a request from a =
client to delete duplicate records from a table which is very large in size=
.=C2=A0<br><br>Delete queries (~2 Billion) are provided via file, and we ha=
ve to execute that file in DB. Last time it lasted for two days. I feel the=
re must be another way to delete records in an efficient manner</div></div>=
<div class=3D"gmail_default" style=3D"font-family:tahoma,sans-serif;font-si=
ze:small;color:rgb(0,0,0)"><br></div><div class=3D"gmail_default" style=3D"=
font-family:tahoma,sans-serif;font-size:small;color:rgb(0,0,0)">This kind o=
f activity they do every month.</div><div><br></div><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature" da=
ta-smartmail=3D"gmail_signature"><div dir=3D"ltr">Thanks &amp; Regards<br>G=
ambhir Singh<br><br></div></div></div>

--0000000000000cfd47062bbfd9c6--