Re: Trying to minimize the impact of checkpoints (resend)

Поиск
Список
Период
Сортировка
От Doug McNaught
Тема Re: Trying to minimize the impact of checkpoints (resend)
Дата
Msg-id 87pt85zwe7.fsf@asmodeus.mcnaught.org
обсуждение исходный текст
Ответ на Trying to minimize the impact of checkpoints (resend)  (jao@geophile.com)
Список pgsql-general
jao@geophile.com writes:

> Does anyone have any experience in modifying the priority of the
> checkpoint process itself, (re-nicing it)?

Unfortunately for you, re-nicing doesn't generally affect a processes
I/O rate--it's meant for CPU-bound processes.

It might be possible to add code to "throttle" the checkpoint process
(similar to what was done for VACUUM) but I don't know for sure...

-Doug

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

Предыдущее
От: jao@geophile.com
Дата:
Сообщение: Trying to minimize the impact of checkpoints (resend)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Trying to minimize the impact of checkpoints (resend)