Re: Resource management in 7.4 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Resource management in 7.4
Date
Msg-id 513.1040488803@sss.pgh.pa.us
Whole thread Raw
In response to Re: Resource management in 7.4  (Hans-Jürgen Schönig <postgres@cybertec.at>)
List pgsql-hackers
Hans-Jürgen Schönig <postgres@cybertec.at> writes:
> It would be nice if there was a way to renice a connection. When it 
> comes to reporting it would be nice to have a handle for slowing a 
> backend down.

> A patch for Linux would be quite easy ("SELECT nice_backend(int)")

No, it wouldn't.  Or at least, the side effects of just nice'ing a
backend would not be what you'd wish.  See past discussions (try
searching the archives for "priority inversion").
        regards, tom lane


pgsql-hackers by date:

Previous
From: Kenji Sugita
Date:
Subject: How to write make rules for shared library and loadable library
Next
From: Ryan Mahoney
Date:
Subject: Re: plpgsql and index usage