Re: [PERFORM] Limit I/O bandwidth of a certain backend

2009-05-05 Thread Greg Smith
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

Re: [PERFORM] Limit I/O bandwidth of a certain backend

2009-05-05 Thread Bryan Murphy
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/

[PERFORM] Limit I/O bandwidth of a certain backend

2009-05-05 Thread Vlad Arkhipov
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