Limit I/O bandwidth of a certain backend

Поиск
Список
Период
Сортировка
От Vlad Arkhipov
Тема Limit I/O bandwidth of a certain backend
Дата
Msg-id 49FFEB4C.2000205@dc.baikal.ru
обсуждение исходный текст
Ответы Re: Limit I/O bandwidth of a certain backend
Re: Limit I/O bandwidth of a certain backend
Список pgsql-performance
Is there a way to limit I/O bandwidth/CPU usage of a certain backend? It
seems that ionice/renice makes no sense because of bgwriter/WAL writer
processes are not a part of a backend. I have a periodic query (every
hour) that make huge I/O load and should run in background. When this
query runs all other fast queries slow down dramatically.


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