vacuum is time consuming

Поиск
Список
Период
Сортировка
От Atul Kumar
Тема vacuum is time consuming
Дата
Msg-id CA+ONtZ5eU7cD3wqsdPJhmCanvTqJg3rNSQ_piCxszdEwFvjE8w@mail.gmail.com
обсуждение исходный текст
Ответы Re: vacuum is time consuming  (Michael Lewis <mlewis@entrata.com>)
Re: vacuum is time consuming  (Martín Marqués <martin.marques@gmail.com>)
Список pgsql-general
Дерево обсуждения 
Hi,

We have DB of 400GBs, Server RAM is 160GBs. CPU consumption is 1-3%  only.

We have  configured maintenance_work_mem to 10GBs and restarted the
postgres service.

We have done upgrade from postgres 9.5 to 9.6, then when we run vacuum
analyze on database, it is taking more than 5 hours and still running.

Any suggestions for making the process(vacuum analyze) faster are welcome.

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

Предыдущее
От: Hemil Ruparel
Дата:
Сообщение: Re: How to post to this mailing list from a web based interface
Следующее
От: Matthias Apitz
Дата:
Сообщение: Re: How to post to this mailing list from a web based interface