I have a patch for user quotas in (I think) 7.4.2. I was going to
update it for 8.x but have been too busy. The discussion (in the past)
was related to whether quotas would be applied to users or groups and
whether it would be on tablespaces (which I think it should).
I can spend some time reviving the patch this weekend if it is of
interest to you. Just let me know.
-Jonah
Josh Berkus wrote:
Yann,
O.K. This makes sens to me. Otherwise I'd like to see quotas per
tablespace. As far as I got it, a tablespace may grow in size untile the
volume is full. Here a grace quota might be usefull as well. Let's say a
5% threshold like the ext filesystem as an default for generating a
warning to th elogs files letting the admin extend the volum(s) by time.
Hmmm ... Tablespace quotas would be *even more* useful than database
quotas. If it's just as easy for you?
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend