On Tue, May 5, 2009 at 2:31 AM, Vlad Arkhipov <arhipov@dc.baikal.ru> 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