On Tue, Nov 5, 2024 at 1:15 PM Keith Fiske <keith.fiske@xxxxxxxxxxxxxxx> 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!
