Re: controlling process priority - Mailing list pgsql-sql

From Tom Lane
Subject Re: controlling process priority
Date
Msg-id 8399.1008860972@sss.pgh.pa.us
Whole thread Raw
In response to Re: controlling process priority  ("Robert B. Easter" <reaster@comptechnews.com>)
Responses Re: controlling process priority
List pgsql-sql
"Robert B. Easter" <reaster@comptechnews.com> writes:
> [ C function to nice down the backend ]

This sort of thing has been suggested before, but I've always wondered
whether it isn't counterproductive.  The trouble is priority inversion:
any time the niced backend is holding a lock on some shared
datastructure, it will be blocking the allegedly-higher-priority other
backends.
        regards, tom lane


pgsql-sql by date:

Previous
From: Carl van Tast
Date:
Subject: Re: subselects
Next
From: "Josh Berkus"
Date:
Subject: Re: Transaction and cascade problem