From: Jeffrey D. Brower <jeff@pointhere.net>
To: Shankar K <shan0075@yahoo.com>
To: pgsql-performance@postgresql.org
Subject: Re: ext3 filesystem / linux 7.3
Date: Tue, 1 Apr 2003 12:33:15 -0500
Message-ID: <08f801c2f874$c6aac3d0$0b02a8c0@pointhere.net> (raw)
References: <20030331205544.19785.qmail@web21104.mail.yahoo.com>
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
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: jeff@pointhere.net, shan0075@yahoo.com
Subject: Re: ext3 filesystem / linux 7.3
In-Reply-To: <08f801c2f874$c6aac3d0$0b02a8c0@pointhere.net>
References: <20030331205544.19785.qmail@web21104.mail.yahoo.com> <08f801c2f874$c6aac3d0$0b02a8c0@pointhere.net>
* 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