Re: User Quota Implementation

Yann Michel wrote:
> Hi,
> 
> On Fri, Jun 10, 2005 at 10:59:46AM -0400, Bruce Momjian wrote:
> > > 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.
> > 
> > I assume you can't use file system quotas for the tablespace partitions?
> 
> No, that's definetely no solution, due to I'm interested in a general
> solution which should be applicable for all platforms.
> 
> > > BTW: Is there any patch available, yet? This thread dealt with a "patch"
> > > but I didn't see any!?
> > 
> > Oh, there is no patch, just a discussion.
> 
> O.K. so I was not wrong about that. Is it usefull to re-discuss some of
> the aspects to get a gist of what should probably be
> implemented/extended?

Sure.  Basically there has not been a lot of interest in this, and we
are not sure how to implement it without a huge amount of work. 
Considering the other things we are working on, it hasn't been a
priority, and lots of folks don't like the Oracle approach either.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073