| From: | Hans-Jürgen Schönig <postgres(at)cybertec(dot)at> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Resource management in 7.4 |
| Date: | 2002-12-21 09:48:05 |
| Message-ID: | 3E0438D5.20202@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paesold | 2002-12-21 09:49:19 | Re: Resource management in 7.4 |
| Previous Message | Ryan Mahoney | 2002-12-21 07:47:20 | Re: plpgsql and index usage |