Re: vacuum is time consuming

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: vacuum is time consuming
Дата
Msg-id CAHOFxGrF9JD7BddS1scWP7+cR5HAw4k-6VYwDjxV2xzf2xaMwQ@mail.gmail.com
обсуждение исходный текст
Ответ на vacuum is time consuming  (Atul Kumar <akumar14871@gmail.com>)
Список pgsql-general
Assuming that the system is online and in use, you may want to consider doing analyze first to ensure stats are proper, and then vacuum all less-used tables that should be quick then larger/more active tables with the verbose option to see details of why it might be taking time. If you are seeing multiple index scan steps, then maintenance_work_mem is lower than ideal. If you are using default vacuum settings, there is no I/O throttling as I understand the vacuum_cost_delay and vacuum_cost_limit settings. What is your concern with it taking time? Depending how you did the upgrade, there may be no (new/special) need to do the vacuum at all also.

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

Предыдущее
От: "Zwettler Markus (OIZ)"
Дата:
Сообщение: AW: running vacuumlo periodically?
Следующее
От: Tatsuo Ishii
Дата:
Сообщение: Does pg_ctl promote wait for pending WAL?