MIME-Version: 1.0
From: yudhi s <learnerdatabase99@gmail.com>
Date: Wed, 17 Apr 2024 01:15:54 +0530
Message-ID: <CAEzWdqdU3cNWiZxSbdJOYP6MR4xdrKof6Rvz-V=xd8dmvH+WCw@mail.gmail.com>
Subject: Controlling resource utilization
To: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000028fde806163bfdad"
Archived-At: <https://www.postgresql.org/message-id/CAEzWdqdU3cNWiZxSbdJOYP6MR4xdrKof6Rvz-V%3Dxd8dmvH%2BWCw%40mail.gmail.com>
Precedence: bulk

--00000000000028fde806163bfdad
Content-Type: text/plain; charset="UTF-8"

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

--00000000000028fde806163bfdad
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi , <br>We want to have controls around the DB resource u=
tilization by the adhoc user queries, so that it won&#39;t impact the appli=
cation queries negatively. Its RDS postgresql database version 15.4.<div><b=
r></div><div>Saw one parameter as statement_timeout which restricts the que=
ries to not run after a certain time duration and queries=C2=A0will be auto=
matically killed/cancelled. However, I don&#39;t see any other options to s=
et this at user level, rather it&#39;s getting set for all or at session le=
vel. So I want to know if there exists, anyway to control the database reso=
urce utilization specific to users?<div><br></div><div>Regards</div><div>Yu=
dhi<br><br></div></div></div>

--00000000000028fde806163bfdad--