RE: [HACKERS] low priority postmaster threads?

2001-02-22 Thread Chris Storah
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

[HACKERS] low priority postmaster threads?

2001-02-21 Thread Chris Storah
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