Re: VacuumDB generating huge WAL filed

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: VacuumDB generating huge WAL filed
Дата
Msg-id CAKFQuway7Ly58D_e8UBaDR4hCw9T-2yvWiJ3+EZNzbvXoRWjMQ@mail.gmail.com
обсуждение исходный текст
Ответ на VacuumDB generating huge WAL filed  (SASIKUMAR Devaraj <sashikumard@yahoo.com>)
Ответы Re: VacuumDB generating huge WAL filed
Список pgsql-admin
On Wednesday, December 11, 2024, SASIKUMAR Devaraj <sashikumard@yahoo.com> wrote:

When we are running vacuumdb for our database of 1.5TB it is generating approximately 60GB of WAL files? Any way we can reduce this WAL file generation?


Set a much more aggressive autovacuum so you don’t accumulate as much dead tuples between runs?

David J.

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