MIME-Version: 1.0
References: 
 <CAP-pBm8xZGJA_kpfxjK=S85N4QypRNYZqDy_G3Z+mAuRKgmdeA@mail.gmail.com>
 <CANzqJaDfahhS+XED6OAJ+N-RRehZq6FVFpzSDM8qpmQfwriWSg@mail.gmail.com>
In-Reply-To: 
 <CANzqJaDfahhS+XED6OAJ+N-RRehZq6FVFpzSDM8qpmQfwriWSg@mail.gmail.com>
From: Rajesh Kumar <rajeshkumar.dba09@gmail.com>
Date: Mon, 13 Jan 2025 10:03:27 +0530
Message-ID: 
 <CAJk5AtaP5vk+5R9SmQ_H+-V9jct09vJxjpN+9Jt1u9zF==3CBQ@mail.gmail.com>
Subject: Re: Archiving solutions
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000e1068f062b8ef29b"
Archived-At: 
 <https://www.postgresql.org/message-id/CAJk5AtaP5vk%2B5R9SmQ_H%2B-V9jct09vJxjpN%2B9Jt1u9zF%3D%3D3CBQ%40mail.gmail.com>
Precedence: bulk

--000000000000e1068f062b8ef29b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

What are regular housekeeping activities @Imran?

On Mon, 13 Jan 2025, 07:27 Ron Johnson, <ronljohnsonjr@gmail.com> wrote:

> COPY exists, and is very fast.
>
> In my experience, DELETE is quite fast when you:
> 1. have a supporting index, and
> 2. don't try to delete too much in one statement.
>
> Those are the only PG comments that I needed to archive a 6TB DB down to
> 2TB.
>
> On Sun, Jan 12, 2025 at 3:42=E2=80=AFPM kasem adel <kasemadel8@gmail.com>=
 wrote:
>
>> Dears ,
>>
>> Appreciate your support I have 2.4 TB database and I need to implement
>> archiving solutions to prevent data growthing.
>>
>> Thanks
>>
>
>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!
>

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

<p dir=3D"ltr">What are regular housekeeping activities @Imran?</p>
<br><div class=3D"gmail_quote gmail_quote_container"><div dir=3D"ltr" class=
=3D"gmail_attr">On Mon, 13 Jan 2025, 07:27 Ron Johnson, &lt;<a href=3D"mail=
to:ronljohnsonjr@gmail.com">ronljohnsonjr@gmail.com</a>&gt; wrote:<br></div=
><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1=
px #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div>COPY exists, and is v=
ery fast.</div><div><br></div>In my=C2=A0experience, DELETE is quite fast w=
hen you:<div>1. have a supporting index, and=C2=A0</div><div>2. don&#39;t t=
ry to delete too much in one statement.</div><div><br></div><div>Those are =
the only PG comments that I needed to archive a 6TB DB down to 2TB.</div></=
div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On=
 Sun, Jan 12, 2025 at 3:42=E2=80=AFPM kasem adel &lt;<a href=3D"mailto:kase=
madel8@gmail.com" target=3D"_blank" rel=3D"noreferrer">kasemadel8@gmail.com=
</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:=
0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">=
<div dir=3D"auto">Dears ,<div dir=3D"auto"><br></div><div dir=3D"auto">Appr=
eciate your support I have 2.4 TB database and I need to implement archivin=
g solutions to prevent data growthing.=C2=A0</div><div dir=3D"auto"><br></d=
iv><div dir=3D"auto">Thanks=C2=A0</div></div>
</blockquote></div><div><br clear=3D"all"></div><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div=
>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobs=
ter!</div></div></div></div></div>
</blockquote></div>

--000000000000e1068f062b8ef29b--