From owner-freebsd-performance@FreeBSD.ORG Wed Aug 27 06:53:24 2003 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id 72AE116A4BF; Wed, 27 Aug 2003 06:53:24 -0700 (PDT) Received: from mta6.adelphia.net (mta6.adelphia.net [68.168.78.190]) by mx1.FreeBSD.org (Postfix) with ESMTP id 7087B44005; Wed, 27 Aug 2003 06:53:23 -0700 (PDT) (envelope-from wmoran@potentialtech.com) Received: from potentialtech.com ([24.53.179.151]) by mta6.adelphia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030827135324.UAND18217.mta6.adelphia.net@potentialtech.com>; Wed, 27 Aug 2003 09:53:24 -0400 Message-ID: <3F4CB7D2.9000503@potentialtech.com> Date: Wed, 27 Aug 2003 09:53:22 -0400 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.3) Gecko/20030429 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Alexander Leidinger References: <3F4C143D.7000909@potentialtech.com> <20030827114316.300fd455.Alexander@Leidinger.net> In-Reply-To: <20030827114316.300fd455.Alexander@Leidinger.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit cc: freebsd-fs@freebsd.org cc: freebsd-performance@freebsd.org Subject: Re: Performance tests I did with FreeBSD, Linux and PostgreSQL X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 27 Aug 2003 13:53:24 -0000 Alexander Leidinger wrote: > On Tue, 26 Aug 2003 22:15:25 -0400 > Bill Moran wrote: > >>http://www.potentialtech.com/wmoran/postgresql.php > > You don't talk about integrity on this page. Yes I do. It's in the conclusion section. It's not a major part of that document because I didn't test integrity, therefore I have no real conclusions beyond the fact that ext2 is not designed with integrity in mind. > You also present > only the ufs sync and async numbers, but not the noasync (default) > numbers, you should either present them or add a note why you don't > present them. You're right. I'll correct this. > About the "without debugging" description: did you really only remove > INVARIANTS? If yes: you also need to remove WITNESS. WITNESS is not enabled in the GENERIC kernel for 5.1-RELEASE, so there was no need to disable it. > I don't know if 5.1-RELEASE has malloc debugging enabled, but to be on > the safe side you should maybe do a "ln -s aj /etc/malloc.conf" before > you start PostgreSQL. I may look into that, but it seems like the more important thing to do is test 4.8 at this point. If you look at the times, these tests are time-consuming. I probably should have reduced the number of records involved, but if I do that now, I have to rerun all the tests ... -- Bill Moran Potential Technologies http://www.potentialtech.com