X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A4EA8565CB for ; Wed, 16 Mar 2005 16:56:03 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 48802-10 for ; Wed, 16 Mar 2005 16:55:57 +0000 (GMT) Received: from hobbit.corpit.ru (hobbit.corpit.ru [81.13.94.6]) by svr1.postgresql.org (Postfix) with ESMTP id 00A5B565BB for ; Wed, 16 Mar 2005 16:55:53 +0000 (GMT) Received: from localhost (localhost [127.0.0.1]) by hobbit.corpit.ru (Postfix) with ESMTP id 1819E295DD; Wed, 16 Mar 2005 19:55:50 +0300 (MSK) (envelope-from mjt@tls.msk.ru) Received: from [192.168.1.1] (paltus.tls.msk.ru [192.168.1.1]) by hobbit.corpit.ru (Postfix) with ESMTP; Wed, 16 Mar 2005 19:55:50 +0300 (MSK) (envelope-from mjt@tls.msk.ru) Message-ID: <42386515.1070103@tls.msk.ru> Date: Wed, 16 Mar 2005 19:55:49 +0300 From: Michael Tokarev User-Agent: Debian Thunderbird 1.0 (X11/20050116) X-Accept-Language: en-us, en MIME-Version: 1.0 To: David Dougall Cc: Arshavir Grigorian , linux-raid@vger.kernel.org, pgsql-performance@postgresql.org Subject: Re: Postgres on RAID5 References: <4231F5F2.6000509@m-cam.com> In-Reply-To: X-Enigmail-Version: 0.90.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/403 X-Sequence-Number: 11108 David Dougall wrote: > In my experience, if you are concerned about filesystem performance, don't > use ext3. It is one of the slowest filesystems I have ever used > especially for writes. I would suggest either reiserfs or xfs. I'm a bit afraid to start yet another filesystem flamewar, but. Please don't make such a claims without providing actual numbers and config details. Pretty please. ext3 performs well for databases, there's no reason for it to be slow. Ok, enable data=journal and use it with eg Oracle - you will see it is slow. But in that case it isn't the filesystem to blame, it's operator error, simple as that. And especially reiserfs, with its tail packing enabled by default, is NOT suitable for databases... /mjt