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

In response to Ivan Sergio Borgonovo : > > If you need strong user resource limits, user storage limits, etc > > PostgreSQL might not be your best option. There are some things > > you can do, but there's not much. > > What about an external process that monitor backend and kill them > gracefully

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

On Fri, 16 Jul 2010 19:43:01 +0800 Craig Ringer wrote: > On 16/07/10 19:21, Ivan Sergio Borgonovo wrote: > > 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

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

On 16/07/10 19:21, Ivan Sergio Borgonovo wrote: > 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... Postg

Re: [GENERAL] 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) p

[GENERAL] resource management, letting user A use no more than X resource (time, CPU, memory...)

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... -- Ivan Sergio Borgonovo http://www.webthatworks.it -- Sent