Re: rapid degradation after postmaster restart

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: rapid degradation after postmaster restart
Дата
Msg-id 405331B0.6080102@joeconway.com
обсуждение исходный текст
Ответ на Re: rapid degradation after postmaster restart  (Marty Scholes <marty@outputservices.com>)
Список pgsql-performance
Marty Scholes wrote:
> I have seen similar results to what you are describing.
>
> I found that running a full vacuum:
>
> vacuumdb -fza
>
> followed by a checkpoint makes it run fast again.
>
> Try timing the update with and without a full vacuum.

Will do. I'll let you know how it goes.

Thanks for the reply.

Joe


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

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: rapid degradation after postmaster restart
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: rapid degradation after postmaster restart