Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

query priorities?


  • From: Thomas Finneid <tfinneid(at)fcon(dot)no>
  • To: pgsql-jdbc(at)postgresql(dot)org
  • Subject: query priorities?
  • Date: Tue, 23 Jun 2009 08:28:42 +0200
  • Message-id: <4A40761A.90604@fcon.no> <text/plain>

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



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group