Re: PostgreSQL historical database

On Tue, Nov 5, 2024 at 1:15 PM Keith Fiske <keith(dot)fiske(at)crunchydata(dot)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 performance
> 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?

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