Re: User/Group Quotas Revisited

Поиск
Список
Период
Сортировка
От Yann Michel
Тема Re: User/Group Quotas Revisited
Дата
Msg-id 20050612104614.GA29053@grrr.spline.inf.fu-berlin.de
обсуждение исходный текст
Ответ на Re: User/Group Quotas Revisited  (Gregory Maxwell <gmaxwell@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Abhijit Menon-Sen
Дата:
Сообщение: creating WITH HOLD cursors using SPI
Следующее
От: Michael Glaesemann
Дата:
Сообщение: interval->day first cut