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/O relative to how much an expensive query uses in most cases. You should try out one of the nice approaches and see if it works for you rather than presuming the background processes will thwart you here. There isn't anything better available in the database yet, so it's the closest things to a good solution available right now anyway.
-- * Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
