Re: Experimental patch for inter-page delay in VACUUM

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Experimental patch for inter-page delay in VACUUM
Дата
Msg-id 4211.1067619906@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Experimental patch for inter-page delay in VACUUM  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> What is the advantage of delaying vacuum per page vs. just doing vacuum
> less frequently?

The point is the amount of load VACUUM poses while it's running.  If
your setup doesn't have a lot of disk bandwidth to spare, a background
VACUUM can hurt the performance of your foreground applications quite
a bit.  Running it less often doesn't improve this issue at all.
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Call for port reports
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PQunescapeBytea code