From: | "Jonah H(dot) Harris" <jharris(at)tvi(dot)edu> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | User/Group Quotas Revisited |
Date: | 2005-06-12 01:10:23 |
Message-ID: | 42AB8B7F.1090300@tvi.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I've sent this again as it hadn't appeared on the list in over 4 hours;
hopefully it isn't posted twice :).
Anyway, on to the main topic...
I've spent some time looking at my user/group quota patch and have
decided to start a new one for 8.x and need some decisions made:
- When to check quota (I'm leaning toward at commit)
- Is quota determined by the ACTUAL sizes of user-owned objects.
- Quota creation syntax
CREATE USER foo QUOTA 10M ON bar;
ALTER USER foo QUOTA 1G ON bar;
CREATE GROUP group QUOTA 100M ON sometbspc;
...
- Quota removal syntax
ALTER USER foo NOQUOTA ON bar;
OR
ALTER USER foo QUOTA UNLIMITED ON bar;
- Size parameter - Currently the following is allowed (I removed
kilobytes):
file_size {digit}+[m|M|g|G|t|T]
- Who has permissions to set the user's quota per tablespace, the
superuser and the tablespace owner?
- How do we want to store quotas in the catalog? I can go with an
aclitem-like array approach at the tablespace level or create a
pg_quota relation (aclitem-like array approach seems nicer, but you may
know something I don't)
Anything else you can think of, let me know.
Thanks.
--
Jonah H. Harris, Sr. Web 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/
A hacker on a roll may be able to produce, in a period of a few
months, something that a small development group (say, 7-8 people)
would have a hard time getting together over a year. IBM used to
report that certain programmers might be as much as 100 times as
productive as other workers, or more.
-- Peter Seebach
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Maxwell | 2005-06-12 01:45:12 | Re: User/Group Quotas Revisited |
Previous Message | Bruce Momjian | 2005-06-11 19:38:55 | Re: The Contrib Roundup (long) |