Re: SOC & user quotas - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: SOC & user quotas
Date
Msg-id 45E7551D.6000803@dunslane.net
Whole thread Raw
In response to Re: SOC & user quotas  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: SOC & user quotas  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-hackers
Tom Lane wrote:
> "Joshua D. Drake" <jd@commandprompt.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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: SOC & user quotas
Next
From: Jeff Davis
Date:
Subject: Re: SOC & user quotas