From: | "Jonah H(dot) Harris" <jharris(at)tvi(dot)edu> |
---|---|
To: | Stephen Frost <sfrost(at)snowman(dot)net> |
Cc: | Rod Taylor <pg(at)rbt(dot)ca>, Klaus Naumann <kn(at)mgnet(dot)de>, PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: User Quota Implementation |
Date: | 2004-07-09 16:59:50 |
Message-ID: | 40EECF06.9000602@tvi.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Dennis Bjorklund | 2004-07-09 17:10:06 | Re: Nested Transactions, Abort All |
Previous Message | Stephen Frost | 2004-07-09 16:50:21 | Re: User Quota Implementation |