Re: ext3 filesystem / linux 7.3 - Mailing list pgsql-performance

I have heard XFS with the mount option is fastest.

---------------------------------------------------------------------------

Shankar K wrote:
> hi jeff,
>
> go to
> http://www.ca.postgresql.org/docs/momjian/hw_performance/
> under 'filesystems' slide.
>
> snip
>
> File system choice is particularly difficult on Linux
> because there are so many file system choices, and
> none of them are optimal: ext2 is not entirely
> crash-safe, ext3, XFS, and JFS are journal-based, and
> Reiser is optimized for small files and does
> journalling. The journalling file systems can be
> significantly slower than ext2 but when crash recovery
> is required, ext2 isn't an option. If ext2 must be
> used, mount it with sync enabled. Some people
> recommend XFS or an ext3 filesystem mounted with
> data=writeback.
>
> /snip
>
> --- "Jeffrey D. Brower" <jeff@pointhere.net> wrote:
> > What is the URL of that article?  I understood that
> > ext2 was faster with PG
> > and so I went to a lot of trouble of creating an
> > ext2 partition just for PG
> > and gave up the journalling to do that.  Something
> > about double effort since
> > PG already does a lot of that.
> >
> > Bruce, is there a final determination of which is
> > faster/safer?
> >
> >     Jeff
> >
> > ----- Original Message -----
> > From: "Shankar K" <shan0075@yahoo.com>
> > To: <pgsql-performance@postgresql.org>
> > Sent: Monday, March 31, 2003 3:55 PM
> > Subject: [PERFORM] ext3 filesystem / linux 7.3
> >
> >
> > > hi there,
> > >
> > > I was reading bruce's 'postgresql hardware
> > performance
> > > tuning' article and he has suggested ext3
> > filesystem
> > > with data mode = writeback for high performance.
> > >
> > > I would really appreciate if anyone could share
> > your
> > > experiences with ext3 from a production stand
> > point or
> > > any other suggestions for best read/write
> > performance.
> > >
> > > Our applications is an hybrid of heavy
> > inserts/updates
> > > and DSS queries.
> > >
> > > version - postgres 7.3.2
> > > hardware - raid 5 (5 x 73 g hardware raid), 4g
> > ram, 2
> > > * 2.8 GHz cpu, redhat 7.3
> > >
> > > Note : we don't have the luxury of raid 1+0
> > (dedicated
> > > disks) for xlog and clog files to start with but
> > may
> > > be down the line we might look into those options,
> > but
> > > for now i've planned on having them on local
> > drives
> > > rather than raid 5.
> > >
> > > thanks for any inputs,
> > > Shankar
> > >
> > >
> > >
> > >
> > >
> > >
> > > __________________________________________________
> > > Do you Yahoo!?
> > > Yahoo! Platinum - Watch CBS' NCAA March Madness,
> > live on your desktop!
> > > http://platinum.yahoo.com
> > >
> > >
> > > ---------------------------(end of
> > broadcast)---------------------------
> > > TIP 1: subscribe and unsubscribe commands go to
> > majordomo@postgresql.org
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - File online, calculators, forms, and more
> http://platinum.yahoo.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073