Postgres Pro
Downloads
Home   >   mailing lists

Is there a way to limit CPU usage per user - Mailing list pgsql-general

From Luki Rustianto
Subject Is there a way to limit CPU usage per user
Date
Msg-id a87d9f3a0602071954p27bfb6fbt22b2368b0cfd3dad@mail.gmail.com
Whole thread Raw
Responses Re: Is there a way to limit CPU usage per user  (Richard Huxton <dev@archonet.com>)
Re: Is there a way to limit CPU usage per user  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Clarification Regarding Vacuum and template1
Next
From: Tom Lane
Date:
Subject: Re: B-tree performance improvements in 8.x