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
Chris Storah <[EMAIL PROTECTED]> writes:
> 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?
Not at the moment, though it'd be a fairly trivial hack on postgres.c
to add a "-nice n" backend
I wrote:
> Chris Storah <[EMAIL PROTECTED]> writes:
>> 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.
> The trouble here is that CPU nice doesn't (on most platforms) change the
> behavior of the I/O sc
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
