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

I'm in agreement with Joshua in some aspects of his reply but not
others.  I use Reiserfs on many production servers and have done so for
a couple of years.  I have needed perform one repair only on the
filesystem, which was automated with the tools provided.  Reiser is
still beta, in the same way that Debian uses the term testing to refer
to non-"stable" software.  Many people us it in a production environment
successfully.  But, as a caveat to my praises to Reiser, if you decide
to use it , understand that you *must* know your subject, how to use the
tools and how to recover from failures.  It is not enough to merely rely
on fsck getting the job done, and, in some circumstances the
incantations required to performa fix can be quite terse IMHO.

The next fs I install will be XFS after much deliberation and
conversation with like minded fellow compugeeks, since it's at least as
good as any other journaling fs, but has the added bonus that
filesystems can be *grown* without the aid of LVM, etc.  Which would be
a huge bonus.

Just my 2 cents.

Tony.

Joshua D. Drake wrote:

> | Don't go on EXT2, its not reliable and takes lots of time to start
> after an
>
> Actually EXT2 is quite reliable and it is also quite fast. However your
> point is accurate about start up time after a crash.
>
>> The most promising FS is Reiserfs v4
>> http://www.namesys.com/v4/v4.html
>>
>>
>>
> Although Reiser is promising, I wouldn't touch it. It is beta, frankly my
> experience is that even their stable stuff is still beta.
>
> If you want a native, reliable, stable FS for Linux. Use JFS or XFS
> (when 2.6 comes out)
>
> Sincerely,
>
> Joshua D. Drake
>
>
>
>
>
>
>
>
>> If you cant wait I suggest XFS or JFS.
>>
>> Look in the archives for all the explanations.
>>
>> Ohhh, and don't use IDE Drives, only SCSI.
>>
>> Cheer
>> --------------------------
>> Canaan Surfing Ltd.
>> Internet Service Providers
>> Ben-Nes Michael - Manager
>> Tel: 972-4-6991122
>> Fax: 972-4-6990098
>> http://www.canaan.net.il
>> --------------------------
>> ----- Original Message ----- From: "Carmen Wai" <wai_carmen@hotmail.com>
>> To: <pgsql-general@postgresql.org>
>> Sent: Thursday, November 27, 2003 5:00 PM
>> Subject: [GENERAL] Postgresql on file system EXT2 or EXT3
>>
>>
>>
>>
>>> Hello:
>>>
>>> I would like to know whether there is any different in installing
>>>
>>
>> Postgresql
>>
>>
>>> on the Linux system with file system of EXT2 or EXT3. I have two
>>> machines
>>> with idential OS (Red Hat 7.3 install with postgresql 7.3.4) but with
>>> different file system, 1 is EXT2 and the other is EXT3. When I insert
>>>
>>
>> 10,000
>>
>>
>>> records to the two machines, I found that the machine with EXT2 insert
>>>
>>
>> much
>>
>>
>>> quicker than the other with EXT3.
>>>
>>> Is postgresqk perform better with EXT2 file system?
>>>
>>> Thanks a lot!
>>> Carmen
>>>
>>> _________________________________________________________________
>>> Linguaphone :  Learning English? Get Japanese lessons for FREE
>>> http://go.msnserver.com/HK/30476.asp
>>>
>>>
>>> ---------------------------(end of
>>> broadcast)---------------------------
>>> TIP 7: don't forget to increase your free space map settings
>>>
>>>
>>
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>>
>>
>