Re: Capping CPU usage? - Mailing list pgsql-performance

From Rod Taylor
Subject Re: Capping CPU usage?
Date
Msg-id 1039631086.17316.194.camel@jester
Whole thread Raw
In response to Capping CPU usage?  ("Josh Berkus" <josh@agliodbs.com>)
Responses Re: Capping CPU usage?  (eric soroos <eric-psql@soroos.net>)
Re: Capping CPU usage?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Wed, 2002-12-11 at 13:12, Josh Berkus wrote:
> Folks:
>
> I had a new question from a client: is it possible to "cap" CPU usage
>  for PostgreSQL running on Linux? They don't care if the procedure
>  degrades Postgres performance, but they can't afford to have Postgres
>  take up more than 30% of processor for more than 400 milliseconds
> (they
>  are running some real-time operations).
>
> I can't imagine that postmaster could do this, but I thought it there
>  might be some kind of Linux Kernel CPU quota option I haven't heard
> of.
>   Can anybody point me in the right direction?

Don't know about Linux, but BSD cannot do that.  CPU limits are hard --
once you hit it it'll dump the process.

Anyway, would it be sufficient to simply reduce the priority of the
process?

--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

Attachment

pgsql-performance by date:

Previous
From: Cory 'G' Watson
Date:
Subject: Re: Capping CPU usage?
Next
From: eric soroos
Date:
Subject: Re: Capping CPU usage?