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

[Unihost Web Hosting]

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" <[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]
 


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])