| From: | C F <tacnaboyz(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Limiting User Resources |
| Date: | 2002-08-21 16:45:31 |
| Message-ID: | 20020821164531.54634.qmail@web20414.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
Is this possible in PostgreSQL? I searched the archives and came up with nothing.... maybe I just don't know what to search on. A quick search in Google came up with this comment about Oracle...
"A user id can have a profile, and a profile can be
given several resource limits (such as CPU seconds
per call, logical I/O per call)"
Does PostgreSQL have anything similar? I'd be perfectly happy with simply being able set a timeout on SQL queries (where after a certain amount of time the query is cancelled and the resources it was using are freed).... I'd like to know what options there are. If not natively available in the the database are there 3rd party products or techniques you can suggest? Basically I'm looking at allowing users to enter their own queries through a web interface and I'm worried about people writing bad queries and hogging up the resources and effectively shutting down the site!
Thanks for you help!!
---------------------------------
Do You Yahoo!?
HotJobs, a Yahoo! service - Search Thousands of New Jobs
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Chittenden | 2002-08-21 17:07:10 | Re: Default values, inserts, and rules... |
| Previous Message | Tom Lane | 2002-08-21 13:59:30 | Re: Default values, inserts, and rules... |