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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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