query priorities? - Mailing list pgsql-jdbc

From Thomas Finneid
Subject query priorities?
Date
Msg-id 4A40761A.90604@fcon.no
Whole thread Raw
List 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

pgsql-jdbc by date:

Previous
From: Saurabh Dave
Date:
Subject: Re: Queries very slow and memory consumption too high
Next
From: "Albe Laurenz"
Date:
Subject: Re: Queries very slow and memory consumption too high