Re: 7.4 Wishlist

Gavin Sherry wrote:
> I want to see:
>
> i) proper resource management a-la Oracle. This would allow a DBA to
> limited the amount of time any given user spends in the parser, planner or
> executor. It would be limited with a more sophisticated user system,
> including things like CREATE USER PROFILE ...

Amen:

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=3DB99C0A.70900%40mascari.com&rnum=1&prev=/groups%3Fq%3DCREATE%2BPROFILE%2BMike%2BMascari%26hl%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8

To avoid unnecessary cycles being spent on loading the profile
after session authorization, we could have a GUC as was
suggested to turn the feature on or off. This mirrors Oracle,
where you have to set RESOURCE_LIMIT in your init[SID].ora file
before PROFILEs are enforced. Some people like sticking
everything in postgresql.conf though, including resource limits.
I'm not sure how remote administration is supposed to work under
such a scenario though...

Mike Mascari
mascarm(at)mascari(dot)com