Re: Postgresql on file system EXT2 or EXT3

| 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(at)hotmail(dot)com>
>To: <pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL