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