public inbox for [email protected]  

help / color / mirror / Atom feed

From: [email protected]
To: Juan Rodrigo Alejandro Burgos Mella <[email protected]>
Cc: yudhi s <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Controlling resource utilization
Date: Wed, 17 Apr 2024 09:10:16 +0200 (CEST)
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAHbZ42zeyjryzSQH=X+TPutaVOOhGT9sOa1HEBF__eALowUngA@mail.gmail.com>
References: <CAEzWdqdU3cNWiZxSbdJOYP6MR4xdrKof6Rvz-V=xd8dmvH+WCw@mail.gmail.com>
	<CAHbZ42wp3330nZcEWWq5PS5UrB36TCCW7iw=+q122bj_ejQoAg@mail.gmail.com>
	<CAEzWdqcHxchRxcAYr_OQaVbYOfAEqOCgshGuydf0LmLBe0waZQ@mail.gmail.com>
	<CAHbZ42zeyjryzSQH=X+TPutaVOOhGT9sOa1HEBF__eALowUngA@mail.gmail.com>

> De: "Juan Rodrigo Alejandro Burgos Mella" <[email protected]>
> À: "yudhi s" <[email protected]>
> Cc: "pgsql-general" <[email protected]>
> Envoyé: Mardi 16 Avril 2024 22:29:35
> Objet: Re: Controlling resource utilization

> In postgreSQL, that can be done at a session level, or at a general level (in
> the postgresql.conf configuration file)

> Atte
> JRBM

> El mar, 16 abr 2024 a las 15:18, yudhi s (< [ mailto:[email protected]
> | [email protected] ] >) escribió:

>> On Wed, 17 Apr, 2024, 1:32 am Juan Rodrigo Alejandro Burgos Mella, < [
>> mailto:[email protected] | [email protected] ] > wrote:

>>> Yes sir
>>> SET statement_timeout TO '<milliseconds>'

>>> Atte
>>> JRBM

>>> El mar, 16 abr 2024 a las 14:46, yudhi s (< [ mailto:[email protected]
>>> | [email protected] ] >) escribió:

>>>> Hi ,
>>>> We want to have controls around the DB resource utilization by the adhoc user
>>>> queries, so that it won't impact the application queries negatively. Its RDS
>>>> postgresql database version 15.4.
>>>> Saw one parameter as statement_timeout which restricts the queries to not run
>>>> after a certain time duration and queries will be automatically
>>>> killed/cancelled. However, I don't see any other options to set this at user
>>>> level, rather it's getting set for all or at session level. So I want to know
>>>> if there exists, anyway to control the database resource utilization specific
>>>> to users?
>>>> Regards
>>>> Yudhi

>> This will set the timeout at session level. However, We want to understand, if
>> it can be done at user/role level, so that any such adhoc user queries can be
>> auto killed or cancelled after the set time.

Or also at role/user level : 
ALTER ROLE < your - username > SET statement_timeout = '<time_unit>' ; 
Regards 
Gilles 

view thread (4+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Controlling resource utilization
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox