public inbox for [email protected]  

help / color / mirror / Atom feed

From: Juan Rodrigo Alejandro Burgos Mella <[email protected]>
To: yudhi s <[email protected]>
Cc: pgsql-general <[email protected]>
Subject: Re: Controlling resource utilization
Date: Tue, 16 Apr 2024 15:02:08 -0500
Message-ID: <CAHbZ42wp3330nZcEWWq5PS5UrB36TCCW7iw=+q122bj_ejQoAg@mail.gmail.com> (raw)
In-Reply-To: <CAEzWdqdU3cNWiZxSbdJOYP6MR4xdrKof6Rvz-V=xd8dmvH+WCw@mail.gmail.com>
References: <CAEzWdqdU3cNWiZxSbdJOYP6MR4xdrKof6Rvz-V=xd8dmvH+WCw@mail.gmail.com>

Yes sir

SET statement_timeout TO '<milliseconds>'

Atte
JRBM

El mar, 16 abr 2024 a las 14:46, yudhi s (<[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
>
>

view thread (3+ 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]
  Subject: Re: Controlling resource utilization
  In-Reply-To: <CAHbZ42wp3330nZcEWWq5PS5UrB36TCCW7iw=+q122bj_ejQoAg@mail.gmail.com>

* 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