public inbox for [email protected]
help / color / mirror / Atom feedFrom: yudhi s <[email protected]>
To: pgsql-general <[email protected]>
Subject: Controlling resource utilization
Date: Wed, 17 Apr 2024 01:15:54 +0530
Message-ID: <CAEzWdqdU3cNWiZxSbdJOYP6MR4xdrKof6Rvz-V=xd8dmvH+WCw@mail.gmail.com> (raw)
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]
Subject: Re: Controlling resource utilization
In-Reply-To: <CAEzWdqdU3cNWiZxSbdJOYP6MR4xdrKof6Rvz-V=xd8dmvH+WCw@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