Re: Statement Timeout at User Level

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: Statement Timeout at User Level
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C202854E2F@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на Statement Timeout at User Level  ("Gauri Kanekar" <meetgaurikanekar@gmail.com>)
Список pgsql-performance
Gauri Kanekar wrote:
> Is it possible to put Statement timeout at User Level.
> Like If i have a user like 'guest', Can i put a statement
> timeout for it.

If only all problems were that easily solved!

ALTER ROLE guest SET statement_timeout=10000;

This will cause all statements longer than 10 seconds and issued
by "guest" to be aborted.

Yours,
Laurenz Albe

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

Предыдущее
От: "Gauri Kanekar"
Дата:
Сообщение: Statement Timeout at User Level
Следующее
От: Matthew Wakeling
Дата:
Сообщение: Re: RAID arrays and performance