Yes sir SET statement_timeout TO '<milliseconds>'
Atte JRBM El mar, 16 abr 2024 a las 14:46, yudhi s (<learnerdatabas...@gmail.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 > >
