Re: vacuum locking

Поиск
Список
Период
Сортировка
От Vivek Khera
Тема Re: vacuum locking
Дата
Msg-id x78yndcdq5.fsf@yertle.int.kciLink.com
обсуждение исходный текст
Ответ на vacuum locking  (Rob Nagler <nagler@bivio.biz>)
Список pgsql-performance
>>>>> "RN" == Rob Nagler <nagler@bivio.biz> writes:

RN> This solution doesn't really fix the fact that VACUUM consumes the
RN> disk while it is running.  I want to avoid the erratic performance on
RN> my web server when VACUUM is running.

What's the disk utilization proir to running vacuum?  If it is
hovering around 95% or more of capacity, of course you're gonna
overwhelm it.

This ain't Star Trek -- the engines can't run at 110%, Cap'n!


--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

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

Предыдущее
От: Vivek Khera
Дата:
Сообщение: Re: vacuum locking
Следующее
От: "Medora Schauer"
Дата:
Сообщение: Re: slow select