Re: User/Group Quotas Revisited - Mailing list pgsql-hackers

From Yann Michel
Subject Re: User/Group Quotas Revisited
Date
Msg-id 20050612104614.GA29053@grrr.spline.inf.fu-berlin.de
Whole thread Raw
In response to Re: User/Group Quotas Revisited  (Gregory Maxwell <gmaxwell@gmail.com>)
List 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


pgsql-hackers by date:

Previous
From: Abhijit Menon-Sen
Date:
Subject: creating WITH HOLD cursors using SPI
Next
From: Michael Glaesemann
Date:
Subject: interval->day first cut