Limit I/O bandwidth of a certain backend - Mailing list pgsql-performance

From Vlad Arkhipov
Subject Limit I/O bandwidth of a certain backend
Date
Msg-id 49FFEB4C.2000205@dc.baikal.ru
Whole thread Raw
Responses Re: Limit I/O bandwidth of a certain backend  (Bryan Murphy <bmurphy1976@gmail.com>)
Re: Limit I/O bandwidth of a certain backend  (Greg Smith <gsmith@gregsmith.com>)
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: Scott Marlowe
Date:
Subject: Re: high shared buffer and swap
Next
From: PFC
Date:
Subject: Re: [HACKERS] high shared buffer and swap