query priorities?

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

Browse pgsql-jdbc by date

  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