Re: [GENERAL] Postgresql on file system EXT2 or EXT3

[Joshua D. Drake]

| 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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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 [EMAIL PROTECTED]
 

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly