From:
Jeff Davis <pgsql(at)j-davis(dot)com>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
"Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, "Sergey E(dot) Koposov" <math(at)sai(dot)msu(dot)ru>, pgsql-hackers(at)postgresql(dot)org, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Subject:
Re: SOC & user quotas
Date:
2007-03-01 23:56:56
Message-ID:
1172793416.13722.143.camel@dogma.v10.wvs (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 Thu, 2007-03-01 at 17:53 -0500, Tom Lane wrote:
> The real problem though is whether you can get anything much done if up
> against a hard limit; especially if that limit also affects the system
> catalogs. Remember that UPDATE requires the ability to insert new tuple
> versions, so there are a whole lot of things that will draw that ERROR.
>
You can pg_dump, drop the database, and make it again (maybe after
deleting a few lines).
I know it's not pretty, but the request is mostly centered around
virtual hosting. The admin can easily generate emails when space is low,
and when someone actually hits the quota the admin does have a path to
get them out of the mess without disturbing other customers.
It's not fool-proof. Someone can generate huge amounts of WAL traffic,
hog the CPU, use the RAM, all kinds of things. But virtual hosting can't
easily prevent that kind of thing anyway.
So it seems like we already have a solution to quotas at the database
level.
Another point is that shared virtual hosting is becoming less important
as OS virtualization (like Xen) becomes more prevalent.
Regards,
Jeff Davis
In response to
Responses
pgsql-hackers by date
Next :From: FAST PostgreSQLDate: 2007-03-02 00:19:43Subject : Re: [HACKERS] Previous :From : Hiroshi SaitoDate : 2007-03-01 23:44:56Subject : Re: Removing some of the old VC++ stuff
