Hi Siraj,
There are no resource profiles in Postgres. You may create and use ROLES for such requirements. E.g.
CREATE ROLE limited_user WITH LOGIN CONNECTION LIMIT 5;
CREATE ROLE limited_user WITH LOGIN CONNECTION LIMIT 5;
ALTER ROLE limited_user SET work_mem = '64MB';
ALTER ROLE limited_user SET statement_timeout = '30s';
For more please explore PostgreSQL documentation as suggested above by David.
Regards,
Muhammad Ikram,
Bitnine Global
On Fri, Jul 12, 2024 at 7:59 AM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
On Thursday, July 11, 2024, Siraj G <tosiraj.g@xxxxxxxxx> wrote:I wonder if there is any similar concept we can explore in PgSQL?David J.
Muhammad Ikram
