Re: Long Running Update

Поиск
Список
Период
Сортировка
От Harry Mantheakis
Тема Re: Long Running Update
Дата
Msg-id 4E04C033.8060305@riskcontrollimited.com
обсуждение исходный текст
Ответ на Re: Long Running Update  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-performance
I called VACUUM on the database after abandoning the original all-in-one
update.

And I have a daily cron script that executes the following statement:

sudo -u postgres /usr/bin/vacuumdb -U postgres --all --analyze

But I had not considered using CLUSTER - I will certainly look into that.

Thanks again.

Harry Mantheakis
London, UK


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