Re: User Quota Implementation

Stephen Frost wrote:
> * Rod Taylor (pg(at)rbt(dot)ca) wrote:
>
>>On Fri, 2004-07-09 at 11:47, Stephen Frost wrote:
>>
>>>* Klaus Naumann (kn(at)mgnet(dot)de) wrote:
>>>
>>>>On Thu, 8 Jul 2004, Jonah H. Harris wrote:
>>>>
>>>>>3. The maximum quota size is (currently) the maximum of int4*1024 bytes.
>>>>
>>>>why is this? This is very limiting ...
>>>
>>>It's 2TB...
>>
>>Okay.. that is good for a few years. What do we do after 2007?
>
>
> I was pointing out that it's not all *that* limiting. If it's not too
> difficult (ie: isn't something that affects disk layout or internal
> postgres things..) I certainly don't have a problem w/ moving to a 64bit
> int.
>
> Stephen

My thinking was, if you're allowing a user to use that much space,
they're probably better off with an unlimited quota... unless you don't
vacuum often and there are heavy updates/deletes performed on that
user's relations.

Internally there isn't a problem (as I see it) with using a bigger data
type.

--
Jonah H. Harris, UNIX Administrator | phone: 505.224.4814
Albuquerque TVI | fax: 505.224.3014
525 Buena Vista SE | jharris(at)tvi(dot)edu
Albuquerque, New Mexico 87106 | http://w3.tvi.edu/~jharris/

"All great truths begin as blasphemies."
-- George Bernard Shaw