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
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.

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
>