Re: User Quota Implementation

From: Yann Michel <yann-postgresql(at)spline(dot)de>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: User Quota Implementation
Date: 2005-06-10 14:51:21
Message-ID: 20050610145121.GA25188@zoom.spline.inf.fu-berlin.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Jun 10, 2005 at 10:07:59AM -0400, Bruce Momjian wrote:
> > Do you think that it is possible that one can generate a TODO item out
> > of the request or do you rather think different?
>
> Yes, sure. Ah, I found it. TODO has now:
>
> * Allow limits on per-db/user connections

Fine!

> That is pretty vague, but it is all we have so far. In fact, that
> refers more to the number of connections rather than say disk space or
> CPU. The issue we have had with these issues in the past is that we
> aren't sure how such limits would be implemented or used.

Well, I have realy a lot of experiences with oracle usage and with its
limitation capabilities. What I need the most is space-limitation per
tablespace. Since 9i there is also a possibility to restrict cpu-usage
for a certain consumer or group but in fact I din't need to to so since
most of the apps have their own database. Maybe it could be useful to
have these groups later on. As far as I understood the thread above (and
any other mails) the space limitation would not only be nice for me.

BTW: Is there any patch available, yet? This thread dealt with a "patch"
but I didn't see any!?

Regards,
Yann

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Hannu Krosing 2005-06-10 14:54:11 Re: proposed TODO: non-locking CREATE INDEX / REINDEX
Previous Message Bruce Momjian 2005-06-10 14:42:58 Re: Tilde expansion on Win32