| From: | Rod Taylor <rbt(at)rbt(dot)ca> | 
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> | 
| Cc: | Pgsql Performance <pgsql-performance(at)postgresql(dot)org> | 
| Subject: | Re: Capping CPU usage? | 
| Date: | 2002-12-11 18:24:47 | 
| Message-ID: | 1039631086.17316.194.camel@jester | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | 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(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Cory 'G' Watson | 2002-12-11 18:27:45 | Re: Capping CPU usage? | 
| Previous Message | Josh Berkus | 2002-12-11 18:12:21 | Capping CPU usage? |