| From: | Juan Rodrigo Alejandro Burgos Mella <rodrigoburgosmella(at)gmail(dot)com> |
|---|---|
| To: | yudhi s <learnerdatabase99(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Controlling resource utilization |
| Date: | 2024-04-16 20:02:08 |
| Message-ID: | CAHbZ42wp3330nZcEWWq5PS5UrB36TCCW7iw=+q122bj_ejQoAg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Yes sir
SET statement_timeout TO '<milliseconds>'
Atte
JRBM
El mar, 16 abr 2024 a las 14:46, yudhi s (<learnerdatabase99(at)gmail(dot)com>)
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
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | yudhi s | 2024-04-16 20:18:39 | Re: Controlling resource utilization |
| Previous Message | yudhi s | 2024-04-16 19:45:54 | Controlling resource utilization |