Re: Disk is full, what's cool to get rid of?

Depends what the default is on your system. The default is 5% with the
version of mke2fs that I have here, so you would just:

tune2fs -m 5 <devicename>

to put it back.

On Thu, 27 Jul 2006, Erik Jones wrote:

> Awesome. Do I need to reset that to any magic # after the vacuum? I'm not
> all that up on filesystem maintenance/tweaking...
>
> Scott Marlowe wrote:
>> I can't tell you the number of times that little trick has saved my
>> life.
>>
>> On Thu, 2006-07-27 at 11:32, Jeff Frost wrote:
>>
>>> You can probably just "tune2fs -m 0 <device name>" to give yourself enough
>>> space to get out of the jam before you go deleting things. Then you might
>>> want to vacuum full afterwards.
>>>
>>> On Thu, 27 Jul 2006, Erik Jones wrote:
>>>
>>>
>>>> Hello, quick question. I've run into an issue with the disk that my
>>>> development box is on filling up and preventing pretty much any writing
>>>> (inserts, updates, deletes, etc...) from happening. Other than some
>>>> piddly text logs the db is pretty much the only thing on the box. So, my
>>>> question is: what can I do to free space and run a full vacuum? (I was
>>>> not the one who set up this box and there has been virtually no
>>>> administration or maintenance on it that I know of...) How about the WAL
>>>> files in pg_xlog? How critical are they when no data on the system is
>>>> critical in and of itself? Any suggestions would be greatly
>>>> appreciated...
>>>>
>>>>
>>>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 6: explain analyze is your friend
>>
>
>
>

--
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954