Re: Postgresql on file system EXT2 or EXT3

Quoting Carmen Wai <wai_carmen@hotmail.com>:

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

Keep in mind that with a journaling type fs, you have additional overhead for
the journal.  I've heard people make this comment before about EXT 3 being
slower that EXT 2.  I personally haven't seen any signficant slow down but for
Linux keep in mind that you could also use ReiserFS which I've heard is faster
than EXT 3 in the same scenario.  JFS is also an option.

You might also want to adjust your inode size down on the EXT2/3 filesystems.
The default is 4k.  I use 2k but you can go as low as 1k.  Thats not something
you can do on the fly though.  You'll have to backup everything and redo the
filesystem.

--
Keith C. Perry, MS E.E.
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com

____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com