Re: User Quota Implementation - Mailing list pgsql-hackers

From Jonah H. Harris
Subject Re: User Quota Implementation
Date
Msg-id 40EECF06.9000602@tvi.edu
Whole thread Raw
In response to Re: User Quota Implementation  (Stephen Frost <sfrost@snowman.net>)
List pgsql-hackers

Stephen Frost wrote:
> * Rod Taylor (pg@rbt.ca) wrote:
> 
>>On Fri, 2004-07-09 at 11:47, Stephen Frost wrote:
>>
>>>* Klaus Naumann (kn@mgnet.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@tvi.edu
Albuquerque, New Mexico 87106        | http://w3.tvi.edu/~jharris/

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



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: User Quota Implementation
Next
From: Dennis Bjorklund
Date:
Subject: Re: Nested Transactions, Abort All