From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Jeff Davis <pgsql(at)j-davis(dot)com>
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 22:53:08
Message-ID:
17902.1172789588@sss.pgh.pa.us (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
Jeff Davis <pgsql(at)j-davis(dot)com> writes:
> Is it possible to make the database safe in this case? I can see why it
> would be difficult to handle pg_xlog filling up (or for that matter
> pg_log), but couldn't any other area be turned into just a simple ERROR?
It is --- Josh is mistaken about the severity of the code's response to
out-of-space. We have to panic if out of WAL or CLOG space because we
can't advance the transaction counter anymore in such cases, but
otherwise it's just ERROR. See the archives for some recorded cases of
PG's response to out-of-space situations.
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.
regards, tom lane
In response to
Responses
pgsql-hackers by date
Next :From: Hiroshi SaitoDate: 2007-03-01 23:44:56Subject : Re: Removing some of the old VC++ stuffPrevious :From : Jeff DavisDate : 2007-03-01 22:37:04Subject : Re: SOC & user quotas
