On Fri, Feb 2, 2024 at 10:02 AM Olivier Gautherot <ogautherot@xxxxxxxxxxxxx> wrote:
El vie, 2 feb 2024 14:54, Ron Johnson <ronljohnsonjr@xxxxxxxxx> escribió:On Fri, Feb 2, 2024 at 3:50 AM Olivier Gautherot <ogautherot@xxxxxxxxxxxxx> wrote:Deleting large numbers of rows is a complex task with a lot of hidden issues (index management between other things). Adding a LIMIT paradigm will not simplify it in any way.Smaller "bites" are easier to manage than giant bites.To some extent, yes. But when it comes to large quantities overall, you have to consider vacuum,
I set autovacuum=off on the relevant table before purging, then vacuum-analyze before re-enabling autovacuum.
and it's best to take the DB offline for that. It depends on your use case.
The objections seem to presume that DBAs are incompetent, don't test ahead of time, and can't learn from their mistakes.
