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

From Matthew Wakeling
Subject Re: which ext3 fs type should I use for postgresql
Date
Msg-id Pine.LNX.4.64.0805151618520.16756@aragorn.flymine.org
Whole thread Raw
In response to Re: which ext3 fs type should I use for postgresql  (Guillaume Cottenceau <gc@mnc.ch>)
Responses Re: which ext3 fs type should I use for postgresql  (Guillaume Cottenceau <gc@mnc.ch>)
List pgsql-performance
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.

Matthew

--
Let's say I go into a field and I hear "baa baa baa". Now, how do I work
out whether that was "baa" followed by "baa baa", or if it was "baa baa"
followed by "baa"?
         - Computer Science Lecturer

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: I/O on select count(*)
Next
From: Guillaume Cottenceau
Date:
Subject: Re: which ext3 fs type should I use for postgresql