query priority

Поиск
Список
Период
Сортировка
От Peter T. Brown
Тема query priority
Дата
Msg-id 002d01c19881$e6add680$7d00000a@PETER
обсуждение исходный текст
Ответы Re: query priority  (Peter Eisentraut <peter_e@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: problems with pg_sorttemp
Следующее
От: Sanjay Bhatia
Дата:
Сообщение: Checking out files during an update