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 62BA7D1C4C7 for ; Mon, 21 Jul 2003 11:22:55 +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 00308-05 for ; Mon, 21 Jul 2003 11:22:54 +0000 (GMT) Received: from cerebro.int-bytecraft.com (unknown [219.93.229.26]) by svr1.postgresql.org (Postfix) with ESMTP id C5EBED1C4CA for ; Mon, 21 Jul 2003 08:22:52 -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 h6LBJqA16776; Mon, 21 Jul 2003 19:19:52 +0800 Message-ID: <3F1BCE3A.5080402@bytecraft.com.my> Date: Mon, 21 Jul 2003 19:27:54 +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: shridhar_daithankar@persistent.co.in Cc: pgsql-performance@postgresql.org Subject: Re: Tuning PostgreSQL References: <3F1C00B2.20319.147235A4@localhost> <3F1C0E65.27609.14A7BA43@localhost> In-Reply-To: <3F1C0E65.27609.14A7BA43@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="------------enig6BA4B68749CB87984025A765" X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/327 X-Sequence-Number: 2620 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig6BA4B68749CB87984025A765 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Shridhar Daithankar wrote: > Good for you. You have time at hand to find out which one suits you best. Do > the testing before you have load that needs another FS..:-) Kinda my point is that when we've more load, we'd be using RAID-0 over RAID-5, or getting faster SCSI drives, or even turn fsync off if that's a bottleneck, because the different filesystems do not have that much performance difference[1] -- the filesystem is not a bottleneck. Just need to tweak most of them a bit, like noatime,data=writeback. [1] That is, AFAIK, from our testing. Please, please correct me if I'm wrong: has anyone found that different filesystems produces wildly different performance for postgresql, FreeBSD's filesystems not included? -- Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux 7:00pm up 207 days, 10:05, 5 users, load average: 5.00, 5.03, 5.06 --------------enig6BA4B68749CB87984025A765 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/G848NYbTUIgzwfARAiK+AKCtNjt53kaBUR9RkNeIlyQqJ5ch/ACg32gd BLoG6cHM1L4yagcZvF630yI= =RzxQ -----END PGP SIGNATURE----- --------------enig6BA4B68749CB87984025A765--