Is there a way to limit CPU usage per user

From: Luki Rustianto <lukirus(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Is there a way to limit CPU usage per user
Date: 2006-02-08 03:54:37
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

Is there a way to limit user's CPU resource specially on "SELECT" query ?

I hava a table with a lot of rows inside, if one sloopy DB users do a
"SELECT * FROM bigtable"
then CPU resource will go near 99% and this action will surely affect
the other database performance ...

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-02-08 05:18:13 Re: B-tree performance improvements in 8.x
Previous Message Dick Kniep 2006-02-08 00:07:21 Re: B-tree performance improvements in 8.x