query priority - Mailing list pgsql-admin

From Peter T. Brown
Subject query priority
Date
Msg-id 002d01c19881$e6add680$7d00000a@PETER
Whole thread Raw
Responses Re: query priority
List pgsql-admin
Is there a way to reduce the priority of any psql queries depending on the
user connecting to the database? I basically want to be able to run lower
priority queries for some types of queries (for exporting and analysis)
while other queries run at higher priorities (for mission critical website
serving etc.).

I have seem some C functions that will nice a SELECT at the time its run,
but I am using JDBC from a servlet engine cluster....

Any ideas?

THANK YOU


pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: problems with pg_sorttemp
Next
From: Sanjay Bhatia
Date:
Subject: Checking out files during an update