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