Re: which ext3 fs type should I use for postgresql - Mailing list pgsql-performance

From Guillaume Cottenceau
Subject Re: which ext3 fs type should I use for postgresql
Date
Msg-id 87r6c3wpka.fsf@mnc.ch
Whole thread Raw
In response to Re: which ext3 fs type should I use for postgresql  (Matthew Wakeling <matthew@flymine.org>)
Responses Re: which ext3 fs type should I use for postgresql  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-performance
Matthew Wakeling <matthew 'at' flymine.org> writes:

> On Thu, 15 May 2008, Guillaume Cottenceau wrote:
>> Also, IIRC when PG writes data up to a full filesystem,
>> postmaster won't be able to then restart if the filesystem is
>> still full (it needs some free disk space for its startup).
>>
>> Or maybe this has been fixed in recent versions?
>
> Ah, the "not enough space to delete file, delete some files and try
> again" problem. Anyway, that isn't relevant to the reserved
> percentage, as that will happen whether or not the filesystem is 5%
> smaller.

It is still relevant, as with 5% margin, you can afford changing
that to 0% with tune2fs, just the time for you to start PG and
remove some data by SQL, then shutdown and set the margin to 5%
again.

--
Guillaume Cottenceau

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: which ext3 fs type should I use for postgresql
Next
From: "Joshua D. Drake"
Date:
Subject: Re: which ext3 fs type should I use for postgresql