X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id 27202CCC70 for ; Fri, 18 Jul 2003 07:03:05 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 63528-09 for ; Fri, 18 Jul 2003 07:03:32 +0000 (GMT) Received: from cerebro.int-bytecraft.com (unknown [219.93.229.26]) by svr1.postgresql.org (Postfix) with ESMTP id E51B2CCC53 for ; Fri, 18 Jul 2003 04:02:56 -0300 (ADT) Received: from bytecraft.com.my (home.int-bytecraft.com [127.0.0.1]) by cerebro.int-bytecraft.com (8.11.6/8.11.6) with ESMTP id h6I70WA02601 for ; Fri, 18 Jul 2003 15:00:35 +0800 Message-ID: <3F179CF6.5070400@bytecraft.com.my> Date: Fri, 18 Jul 2003 15:08:38 +0800 From: Ang Chin Han User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Pgsql-Performance@Postgresql. Org" Subject: Re: Sanity check requested References: <3F13E18A.21241.4B86CB0@localhost> <3F17E2A2.28685.45CC782@localhost> In-Reply-To: <3F17E2A2.28685.45CC782@localhost> X-Enigmail-Version: 0.76.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig95FD033B917BFAD74E6511BE" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/284 X-Sequence-Number: 2577 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig95FD033B917BFAD74E6511BE Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Shridhar Daithankar wrote: > On 17 Jul 2003 at 10:41, Nick Fankhauser wrote: > >>I'm using ext2. For now, I'll leave this and the OS version alone. If I > > > I appreciate your approach but it almost proven that ext2 is not the best and > fastest out there. Agreed. > IMO, you can safely change that to reiserfs or XFS. Or course, testing is > always recommended. We've been using ext3fs for our production systems. (Red Hat Advanced Server 2.1) And since your (Nick) system is based on Debian, I have done some rough testing on Debian sarge (testing) (with custom 2.4.20) with ext3fs, reiserfs and jfs. Can't get XFS going easily on Debian, though. I used a single partition mkfs'd with ext3fs, reiserfs and jfs one after the other on an IDE disk. Ran pgbench and osdb-x0.15-0 on it. jfs's has been underperforming for me. Somehow the CPU usage is higher than the other two. As for ext3fs and reiserfs, I can't detect any significant difference. So if you're in a hurry, it'll be easier to convert your ext2 to ext3 (using tune2fs) and use that. Otherwise, it'd be nice if you could do your own testing, and post it to the list. -- Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux 2:30pm up 204 days, 5:35, 5 users, load average: 5.50, 5.18, 5.13 --------------enig95FD033B917BFAD74E6511BE Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE/F5z5NYbTUIgzwfARAlOTAJ0dfrmjX5x2vN43XJDnZ8s2VroMlQCgrB8M WmeImydWP01V8KP7AEA2C9o= =fYEo -----END PGP SIGNATURE----- --------------enig95FD033B917BFAD74E6511BE--