Re: resource management, letting user A use no more than X resource (time, CPU, memory...)

In response to Ivan Sergio Borgonovo :
> If I'd like to learn how to manage resources in postgres and grant
> different users different time slot/memory/CPU?
>
> eg. I'd like to grant to user A to execute queries that last less
> than 1min or that occupy no more than X Mb... etc...

Isn't (real) possible. Okay, you can do something like:

alter user foo set work_mem to '1MB';

but i think, that's not a usefull option, because with this setting you
have other side effects (for instance, sort-operations on disk instead
of in-memory -> more I/O and more LOAD for the whole machine).


Regards, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99