On Thu, Dec 08, 2011 at 01:53:45PM +0100, Tomas Vondra wrote: > I wonder if the prioritisation could be done using nice - each backend is > a separate process, so why not to do 'nice(10)' for low priority processes > or something like that.
This won't work because if you are holding a lock on something someone else needs, your low nice score is going to cause them problems. It could make things worse rather than better. (This suggestion comes up a lot, by the way, so there's been a lot of discussion of it historically.) -- Andrew Sullivan [email protected] -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
