Limit I/O bandwidth of a certain backend

Поиск
Список
Период
Сортировка
Искать

Limit I/O bandwidth of a certain backend

От:
Vlad Arkhipov <arhipov@dc.baikal.ru>
Дата:
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.

Re: Limit I/O bandwidth of a certain backend

От:
Bryan Murphy <bmurphy1976@gmail.com>
Дата:
On Tue, May 5, 2009 at 2:31 AM, Vlad Arkhipov  wrote:
> 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.

Could you use something like slony to replicate the needed data to a
secondary database and run the query there?

Bryan

Re: Limit I/O bandwidth of a certain backend

От:
Greg Smith <gsmith@gregsmith.com>
Дата:
On Tue, 5 May 2009, Vlad Arkhipov wrote:

> 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.

The background writer and WAL writer are pretty low users of CPU and I/O 
relative to how much an expensive query uses in most cases.  You should 
try out one of the nice approaches and see if it works for you rather than 
presuming the background processes will thwart you here.  There isn't 
anything better available in the database yet, so it's the closest things 
to a good solution available right now anyway.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
FAQ