Re: Limiting processor power on queries

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Limiting processor power on queries
Дата
Msg-id 19216.1052867396@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Limiting processor power on queries  ("Chad Thompson" <chad@weblinkservices.com>)
Список pgsql-novice
"Chad Thompson" <chad@weblinkservices.com> writes:
> 1) Is there some way to kill a query in 7.3?

That's been in there for a *long* time.

> 2) Is there a way to limit the processing power for a query based on a) from
> where the query originated (eg. IP address) or b) the type of query it is.

No.  In 7.3 you can set a per-statement timeout, although it's not
something you could enforce against an uncooperative user.

            regards, tom lane


В списке pgsql-novice по дате отправления:

Предыдущее
От: "Fontenot, Paul"
Дата:
Сообщение: Functions and triggers
Следующее
От: Katy Earl
Дата:
Сообщение: Re: can't alter user with the postgres user