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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073