Re: how to slow down parts of Pg

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: how to slow down parts of Pg
Дата
Msg-id CAHOFxGo_+iyx-MOqmF6gfJNmdfM=dTBY5EcO4RjEhGxuLs8azQ@mail.gmail.com
обсуждение исходный текст
Ответ на how to slow down parts of Pg  (Kevin Brannen <KBrannen@efji.com>)
Ответы RE: how to slow down parts of Pg
Список pgsql-general
You say 12.2 is in testing but what are you using now? Have you tuned configs much? Would you be able to implement partitioning such that your deletes become truncates or simply a detaching of the old partition? Generally if you are doing a vacuum full, you perhaps need to tune autovacuum to be more aggressive. Consider pg_repack at least to avoid taking an exclusive lock for the entire duration. If partitioning is not an option, could you delete old records hourly rather than daily?

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

Предыдущее
От: Kevin Brannen
Дата:
Сообщение: how to slow down parts of Pg
Следующее
От: Michael Loftis
Дата:
Сообщение: Re: how to slow down parts of Pg