MIME-Version: 1.0
References: 
 <CA+dvXXuiL4+SRCZ5fqTr4WZ+pHhRaC9e=D7APBcZ2JGJZMiy6w@mail.gmail.com>
 <CAAo1mbnMTFf9pAyoY7dGGR5xKmZcEd6-nRZ9xyNNa3d5DoJLyg@mail.gmail.com>
 <CA+dvXXvQAFm_NHKStG4P8WOxWhM6DGYLcMMM9_B02iE5gsw_bg@mail.gmail.com>
 <CAODZiv6e4fBROiXjZ8iKEcEMrt=qUeP+vyoc5RmjKpqu8Z_THw@mail.gmail.com>
In-Reply-To: 
 <CAODZiv6e4fBROiXjZ8iKEcEMrt=qUeP+vyoc5RmjKpqu8Z_THw@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Fri, 15 Nov 2024 17:51:26 -0500
Message-ID: 
 <CANzqJaBd6ij80vJVZmDzVPGHdin=5F08bxjFeNjR93ocw9uzhQ@mail.gmail.com>
Subject: Re: PostgreSQL historical database
To: pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000daf87e0626fb68fe"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaBd6ij80vJVZmDzVPGHdin%3D5F08bxjFeNjR93ocw9uzhQ%40mail.gmail.com>
Precedence: bulk

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

On Tue, Nov 5, 2024 at 1:15=E2=80=AFPM Keith Fiske <keith.fiske@crunchydata=
.com>
wrote:
[snip]

> I would first recommend looking into partitioning for managing data
> retention like this. As Ron says, you'll want to look into the performanc=
e
> implications of this, but it allows for the most efficient method of
> removing old data from PostgreSQL and is typically worth the overhead
> costs. Otherwise you're dealing with potentially expensive deletion
> operations and managing bloat vs just detaching/dropping a table.
>

Am I the only person to have ever gotten good DELETE performance from
Postgresql?

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

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

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Nov 5, 2024 at 1:15=E2=80=AFPM Ke=
ith Fiske &lt;<a href=3D"mailto:keith.fiske@crunchydata.com">keith.fiske@cr=
unchydata.com</a>&gt; wrote:</div><div class=3D"gmail_quote"><div>[snip]=C2=
=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8e=
x;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"=
><div></div>I would first recommend looking into partitioning for managing =
data retention like this. As Ron says, you&#39;ll want to look into the per=
formance implications of this, but it allows for the most efficient method =
of removing old data from PostgreSQL and is typically worth the overhead co=
sts. Otherwise you&#39;re dealing with potentially expensive deletion opera=
tions and managing bloat vs just detaching/dropping a table.</div></blockqu=
ote><div>=C2=A0</div></div><div>Am I the only person to have ever gotten go=
od DELETE performance from Postgresql?</div><div><br></div><span class=3D"g=
mail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signat=
ure"><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; lobster!<=
/div></div></div></div></div></div>

--000000000000daf87e0626fb68fe--