query priorities?

Поиск
Список
Период
Сортировка
От Thomas Finneid
Тема query priorities?
Дата
Msg-id 4A40761A.90604@fcon.no
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Saurabh Dave
Дата:
Сообщение: Re: Queries very slow and memory consumption too high
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Queries very slow and memory consumption too high