Re: User/Group Quotas Revisited

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

In response to

Browse pgsql-hackers by date

  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