Postgres Professional
   

Limit I/O bandwidth of a certain backend

From: Vlad Arkhipov
Subject: Limit I/O bandwidth of a certain backend
Date: ,
Msg-id: 49FFEB4C.2000205@dc.baikal.ru
(view: Whole thread, Raw)
Responses: Re: Limit I/O bandwidth of a certain backend  (Bryan Murphy)
Re: Limit I/O bandwidth of a certain backend  (Greg Smith)
List: 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 by date:

Previous:
From: Matthew Wakeling
Date:
Subject: Re: [HACKERS] high shared buffer and swap
Next:
From: Bryan Murphy
Date:
Subject: Re: Limit I/O bandwidth of a certain backend