X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id EAF72D1B8EF for ; Sat, 30 Aug 2003 02:34:55 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 80948-07 for ; Fri, 29 Aug 2003 23:34:48 -0300 (ADT) Received: from candle.pha.pa.us (momjian.navpoint.com [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id 93818D1B8EE for ; Fri, 29 Aug 2003 23:34:43 -0300 (ADT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id h7U2YYf12104; Fri, 29 Aug 2003 22:34:34 -0400 (EDT) From: Bruce Momjian Message-Id: <200308300234.h7U2YYf12104@candle.pha.pa.us> Subject: Re: The results of my PostgreSQL/filesystem performance tests In-Reply-To: <001201c36d24$3c572460$0500a8c0@MOBILE01> To: Balazs Wellisch Date: Fri, 29 Aug 2003 22:34:34 -0400 (EDT) Cc: pgsql-performance@postgresql.org X-Mailer: ELM [version 2.4ME+ PL106 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/516 X-Sequence-Number: 3332 Balazs Wellisch wrote: > > Bill, > > Very interesting results. I'd like to command you on your honesty. > Having started out with the intentions of proving that FreeBSD is faster > than Linux only to find that the opposite is true must not have been > rewarding for you. However, these unexpected results serve only to > reinforce the integrity of your tests. Looking at the results, ext2 is out because it isn't crash safe, and I have heard Reiser uses a lot more CPU to do its work. It does show ext3 as slow, which was expected. Interesting how JFS came out, and XFS would be interesting. And, of course, it is multiple backends that really shows PostgreSQL off, so it could radically affect the results. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073