Is there any way in psql to connect to a database and reduce the run
priority of the child thread it kicks off ?
i.e. equivalent of 'nice' on the thread?
From first looks at the code, it seems to fork off the process and there is
a pid that can be niced.
If an extra run level parameter is passed in to the PQExec interface
(defaulted for compatibility with older code), would it work?
This assumes that there isn't already a mechanism to reduce the priority of
specific queries.
What I am looking for is a postgres system that runs 100 users or so at
'full speed', and major day long queries at a 'when idle' priority.
Cheers,
Chris