X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 10E0C47621C for ; Tue, 1 Apr 2003 12:25:39 -0500 (EST) Received: from localhost.localdomain (208-41-234-242.client.dsl.net [208.41.234.242]) by postgresql.org (Postfix) with ESMTP id A9CF0476178 for ; Tue, 1 Apr 2003 12:25:34 -0500 (EST) Received: from endeavour (endeavour.pointhere.net [192.168.2.11]) by localhost.localdomain (8.11.6/8.11.6) with SMTP id h31HFXr08210; Tue, 1 Apr 2003 12:15:33 -0500 Message-ID: <08f801c2f874$c6aac3d0$0b02a8c0@pointhere.net> Reply-To: "Jeffrey D. Brower" From: "Jeffrey D. Brower" To: "Shankar K" , References: <20030331205544.19785.qmail@web21104.mail.yahoo.com> Subject: Re: ext3 filesystem / linux 7.3 Date: Tue, 1 Apr 2003 12:33:15 -0500 Organization: A Basic Marketing Company MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Spam-Status: No, hits=-16.9 required=5.0 tests=BAYES_20,MAILTO_TO_SPAM_ADDR,ORIGINAL_MESSAGE, QUOTED_EMAIL_TEXT,RCVD_IN_NJABL,REFERENCES, X_NJABL_OPEN_PROXY autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/2 X-Sequence-Number: 1508 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" To: 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