X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CEACA475D91 for ; Mon, 31 Mar 2003 15:55:44 -0500 (EST) Received: from web21104.mail.yahoo.com (web21104.mail.yahoo.com [216.136.227.106]) by postgresql.org (Postfix) with SMTP id DF5CE475AF8 for ; Mon, 31 Mar 2003 15:55:43 -0500 (EST) Message-ID: <20030331205544.19785.qmail@web21104.mail.yahoo.com> Received: from [208.253.218.33] by web21104.mail.yahoo.com via HTTP; Mon, 31 Mar 2003 12:55:44 PST Date: Mon, 31 Mar 2003 12:55:44 -0800 (PST) From: Shankar K Subject: ext3 filesystem / linux 7.3 To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Spam-Status: No, hits=-5.1 required=5.0 tests=BAYES_10,FROM_ENDS_IN_NUMS version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/203 X-Sequence-Number: 1501 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