| From: | Thomas Finneid <tfinneid(at)fcon(dot)no> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | query priorities? |
| Date: | 2009-06-23 06:28:42 |
| Message-ID: | 4A40761A.90604@fcon.no |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Hi
Is it possible to give queries different priorities?
If I start a bigger query that is not part of the primary work of the
app, it can lead to it eating up the resources in the db so the primary
work does not complete in a reasonable time. Hence, I was wondering if I
can give queries priorities, so that the primary work always has higher
priority. While the secondary work, such as ad hoc queries, do not
obstruct resource access etc for the the primary work.
reagrds
thomas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Albe Laurenz | 2009-06-23 07:38:40 | Re: Queries very slow and memory consumption too high |
| Previous Message | Saurabh Dave | 2009-06-23 01:48:05 | Re: Queries very slow and memory consumption too high |