Re: Postgresql on file system EXT2 or EXT3 - Mailing list pgsql-general

From Christopher Browne
Subject Re: Postgresql on file system EXT2 or EXT3
Date
Msg-id 60wu9kibg1.fsf@dev6.int.libertyrms.info
Whole thread Raw
In response to Postgresql on file system EXT2 or EXT3  ("Carmen Wai" <wai_carmen@hotmail.com>)
Responses Re: Postgresql on file system EXT2 or EXT3  (Mike Benoit <mikeb@netnation.com>)
List pgsql-general
miki@canaan.co.il ("Ben-Nes Michael") writes:
> Don't go on EXT2, its not reliable and takes lots of time to start after an
> unclean shutdown. ( all the other explained it quite well )
>
> The most promising FS is Reiserfs v4
> http://www.namesys.com/v4/v4.html
>
> If you cant wait I suggest XFS or JFS.

ReiserFS may seem "promising," but I wouldn't touch it for DBMS work
for quite some time to come.

Its design has always been directed to the efficient handling of tiny
files, and I don't see version 4 changing that.  That's not ideal for
PostgreSQL, because it tends to access fairly large files.

ReiserFS has a history of losing data when crashes take place (e.g. -
unclean shutdown).  I haven't experienced any _enormous_ horrors, but
have experienced enough small problems that I'm not interested in
having DBMS files on it...
--
let name="cbbrowne" and tld="libertyrms.info" in String.concat "@" [name;tld];;
<http://dev6.int.libertyrms.com/>
Christopher Browne
(416) 646 3304 x124 (land)

pgsql-general by date:

Previous
From: Randolf Richardson
Date:
Subject: Re: Index on array element
Next
From: Randolf Richardson
Date:
Subject: Re: Open source data modeling tools for PostgreSQL