Skip site navigation (1) Skip section navigation (2)

Re: SOC & user quotas

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Cc: "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>, Joachim Wieland <joe(at)mcknight(dot)de>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Subject: Re: SOC & user quotas
Date: 2007-03-01 03:39:33
Message-ID: 200702282239.34694.xzilla@users.sourceforge.net (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wednesday 28 February 2007 18:02, Sergey E. Koposov wrote:
> On Wed, 28 Feb 2007, Joachim Wieland wrote:
> > On Wed, Feb 28, 2007 at 12:56:13PM -0500, Tom Lane wrote:
> >> It hasn't ever made it onto the TODO list, which means there's not a
> >> consensus that we need it.
> >
> > Such a patch could improve the acceptance of PostgreSQL in shared hosting
> > environments. Note that a database without quotas can be filled up easily
> > and the database will stop serving requests to other users' databases.
>
> Yes, I agree.
>
> > There is a quota implementation already in the archives but I don't know
> > more about it than that it exists:
> >
> > http://archives.postgresql.org/pgsql-hackers/2004-07/msg00392.php
>
> I remember that thread, but I think there was no patch at all, at least I
> didn't see it.
>

Sergey, could you do a little research on what behavior other databases that 
support user quotes exhibit?  This might help folks judge whether any 
proposed solution for postgres will be above or below potential users 
expectations. 

-- 
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

In response to

Responses

pgsql-hackers by date

Next:From: Sergey E. KoposovDate: 2007-03-01 03:42:15
Subject: Re: SOC & user quotas
Previous:From: Jonah H. HarrisDate: 2007-03-01 03:34:21
Subject: Re: COMMIT NOWAIT Performance Option

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group