Re: User Quota Implementation - Mailing list pgsql-hackers

From Jonah H. Harris
Subject Re: User Quota Implementation
Date
Msg-id 42AA0CFD.9040407@tvi.edu
Whole thread Raw
In response to Re: User Quota Implementation  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
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?
>
>  
>



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: User Quota Implementation
Next
From: Andrew - Supernews
Date:
Subject: Re: The Contrib Roundup (long)