Re: Postgresql on file system EXT2 or EXT3 - Mailing list pgsql-general

On Sat, 2003-11-29 at 02:07, Unihost Web Hosting wrote:
> 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.
>

resize_reiserfs
resize2fs

We grow a EXT3 file system all the time on a Linear RAID array. Works
fine without LVM. Shrinking can be a different issue though.

> 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" <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
> >>>
> >>>
> >>
> >>
> >>
> >>
> >> ---------------------------(end of broadcast)---------------------------
> >> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> >>
> >>
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
--
Best Regards,

Mike Benoit
NetNation Communications Inc.
Systems Engineer
Tel: 604-684-6892 or 888-983-6600
 ---------------------------------------

 Disclaimer: Opinions expressed here are my own and not
 necessarily those of my employer