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:
2007-02-28 16:26:53 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-02-28 16:46:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-28 17:14:13 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-02-28 17:31:20 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-02-28 16:56:58 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-28 17:19:17 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-02-28 17:28:55 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-28 17:38:47 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-02-28 17:48:12 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-03-01 08:53:26 from "Zeugswetter Andreas ADI SD" <ZeugswetterA(at)spardat(dot)at>
2007-02-28 17:56:13 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-28 17:58:52 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-28 18:39:36 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2007-02-28 18:50:09 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-28 20:57:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-02-28 21:23:58 from Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
2007-02-28 21:35:25 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-02-28 22:29:52 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-02-28 23:01:22 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-03-01 20:58:55 from "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
2007-02-28 22:26:48 from Martijn van Oosterhout <kleptog(at)svana(dot)org>
2007-02-28 19:14:34 from Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
2007-02-28 22:48:38 from Joachim Wieland <joe(at)mcknight(dot)de>
2007-02-28 23:02:27 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-03-01 03:39:33 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2007-03-01 03:42:15 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-03-01 21:21:34 from Jeff Davis <pgsql(at)j-davis(dot)com>
2007-03-01 21:45:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-01 22:06:34 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-03-01 22:13:20 from "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
2007-03-01 22:28:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-01 22:35:09 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2007-03-02 18:58:21 from Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
2007-03-01 22:37:04 from Jeff Davis <pgsql(at)j-davis(dot)com>
2007-03-01 22:53:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-01 23:56:56 from Jeff Davis <pgsql(at)j-davis(dot)com>
2007-03-02 00:31:44 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-03-02 01:08:32 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2007-03-02 01:22:09 from "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>
2007-03-02 01:26:41 from Jeff Davis <pgsql(at)j-davis(dot)com>
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:15Subject : Re: SOC & user quotasPrevious :From : Jonah H. HarrisDate : 2007-03-01 03:34:21Subject : Re: COMMIT NOWAIT Performance Option
