Re: Enhancement Request

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Enhancement Request
Дата
Msg-id CANzqJaDqAsjbmFHOOjQSam6-tw-wJL_cQjD5HpMDEZww2WBRRg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Enhancement Request  (Olivier Gautherot <ogautherot@gautherot.net>)
Список pgsql-admin
Дерево обсуждения
On Fri, Feb 2, 2024 at 10:02 AM Olivier Gautherot <ogautherot@gautherot.net> wrote:


El vie, 2 feb 2024 14:54, Ron Johnson <ronljohnsonjr@gmail.com> escribió:
On Fri, Feb 2, 2024 at 3:50 AM Olivier Gautherot <ogautherot@gautherot.net> wrote:


El jue, 1 feb 2024 2:35, Ron Johnson <ronljohnsonjr@gmail.com> escribió:

...

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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: M Sarwar
Дата:
Сообщение: Re: Function is giving execution error from inside the procedure
Следующее
От: "Ravindranathan Rinilnath (Ext. - UniCredit)"
Дата:
Сообщение: PgAdmin 4 tool - Filter and Limit selector greyed out