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