Re: Statement Timeout at User Level

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Gauri Kanekar *EXTERN*" <meetgaurikanekar(at)gmail(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Statement Timeout at User Level
Date: 2008-09-18 07:34:50
Message-ID: D960CB61B694CF459DCFB4B0128514C202854E2F@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Wakeling 2008-09-18 13:21:46 Re: RAID arrays and performance
Previous Message Gauri Kanekar 2008-09-18 05:07:18 Statement Timeout at User Level