From: Shankar K <shan0075@yahoo.com>
To: pgsql-performance@postgresql.org
Cc: Jeffrey D. Brower <jeff@pointhere.net>
Subject: Re: ext3 filesystem / linux 7.3
Date: Tue, 1 Apr 2003 09:39:17 -0800 (PST)
Message-ID: <20030401173917.19476.qmail@web21101.mail.yahoo.com> (raw)
In-Reply-To: <08f801c2f874$c6aac3d0$0b02a8c0@pointhere.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: shan0075@yahoo.com, jeff@pointhere.net
Subject: Re: ext3 filesystem / linux 7.3
In-Reply-To: <20030401173917.19476.qmail@web21101.mail.yahoo.com>
References: <08f801c2f874$c6aac3d0$0b02a8c0@pointhere.net> <20030401173917.19476.qmail@web21101.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox