Tom Lane Wrote:
> The trouble here is that CPU nice doesn't (on most platforms) change the
> behavior of the I/O scheduler, so this would only be of use to the
> extent that your queries are CPU bound and not I/O bound.
Assuming there is a major processor hit, and the backend has a UW-SCSI RAID
b
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