Re: Resource management in 7.4

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: Raw Message | Whole Thread | 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>

In response to

Responses

Browse pgsql-hackers by date

  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