Re: [HACKERS] Resource management in 7.4

[Hans-Jürgen Schönig]

Personally I think that configuring things like that is definitely beyond the scope of an average administrator.

However, there is one thing which would be useful for many applications: 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)") but I don't know how this fits into the Windows port and PostgreSQL on other platforms.

I think this would be a straight forward approach fixing most of the problems people might have with CPU usage.

Is this the right way to go?

Regards,
Hans

--
*Cybertec Geschwinde u Schoenig*
Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
Tel: +43/1/913 68 09; +43/664/233 90 75
www.postgresql.at <http://www.postgresql.at>, cluster.postgresql.at <http://cluster.postgresql.at>, www.cybertec.at <http://www.cybertec.at>, kernel.cybertec.at <http://kernel.cybertec.at>



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly