From: | Yann Michel <yann-postgresql(at)spline(dot)de> |
---|---|
To: | Gregory Maxwell <gmaxwell(at)gmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: User/Group Quotas Revisited |
Date: | 2005-06-12 10:46:14 |
Message-ID: | 20050612104614.GA29053@grrr.spline.inf.fu-berlin.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
On Sat, Jun 11, 2005 at 09:45:12PM -0400, Gregory Maxwell wrote:
> > - Who has permissions to set the user's quota per tablespace, the
> > superuser and the tablespace owner?
>
> It would be nice if this were nestable, that is, if the sysadmin could
> carve out a tablespace for a user then the user could carve that into
> seperately quotated sub tables..
>
> The idea being, a user may have several tables, some of which are
> likely to get big and fat and gain lots of crud, but some of which
> will never grow too big but you really don't want to fail just because
> someone floodded the other table and used up your quota. It would be
> nice if the user could manage that subassignment as he saw fit without
> assistance from the admin.
I think this is not necessary, due to yu may suround that problem by
using different tablespaces for that different table types.
Regards,
Yann
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Glaesemann | 2005-06-12 14:26:53 | interval->day first cut |
Previous Message | Abhijit Menon-Sen | 2005-06-12 09:24:47 | creating WITH HOLD cursors using SPI |