Re: User Quota Implementation

Jonah,

> Don't get me wrong, I think we need tablespace maximums.  What I'm
> looking at is a user/group-based quota which would allow a superuser to
> grant say, 2G of space to a user or group.  Any object that user owned
> would be included in the space allocation.
>
> So, if the user owns three tablespaces, they can still only have a
> maximum of 2G total.  This is where I think it would be wise to allow
> the tablespace owner and/or superuser to set the maximum size of a
> tablespace.

Yeah, the problem is that with the upcoming "group ownership" I see 
user-based quotas as being rather difficult to implement unambiguously. 
Even more so when we get "local users" in the future.   So I'd only want 
to do it if there was a real-world use case that tablespace quotas 
wouldn't satisfy.

For the basic ISP space, tablespace quotas seem a lot more apt for that 
case.  You give each user a database, and put it in its own tablespace and 
don't give them permissions to change it.  That way you could have user 
e-mail, web, and database in the same directory tree for easy 
backup/transfer.  It also means that you can use filesystem controls to 
double-check the tablespace maximums.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco