On Tue, May 5, 2009 at 2:31 AM, Vlad Arkhipov <arhi...@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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
