From:
Andrew Dunstan <andrew(at)dunslane(dot)net>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
"Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>,
Jeff Davis <pgsql(at)j-davis(dot)com>,
"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:35:09
Message-ID:
45E7551D.6000803@dunslane.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
Tom Lane wrote:
> "Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
>
>> Andrew Dunstan wrote:
>>
>>> Hitting a file system quota limit is likely to bring you down pretty
>>> hard, isn't it?
>>>
>
>
>> Yes, and likely corrupt the database.
>>
>
> As long as you don't keep WAL on the restricted filesystem, it won't
> stop or corrupt your database. Whether you can get anything much done
> is another story :-(
>
>
>
Yeah. Including recovery. Maybe we could do something that would work in
cooperation with FS quotas - I have no idea what though.
cheers
andrew
In response to
Responses
pgsql-hackers by date
Next :From: Jeff DavisDate: 2007-03-01 22:37:04Subject : Re: SOC & user quotasPrevious :From : Tom LaneDate : 2007-03-01 22:28:18Subject : Re: SOC & user quotas
