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: a87d9f3a0602071954p27bfb6fbt22b2368b0cfd3dad@mail.gmail.com
Views: Raw Message | Whole Thread | 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