From owner-freebsd-performance@FreeBSD.ORG Wed Aug 27 02:42:01 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 A022216A4BF; Wed, 27 Aug 2003 02:42:01 -0700 (PDT) Received: from mailout01.sul.t-online.com (mailout01.sul.t-online.com [194.25.134.80]) by mx1.FreeBSD.org (Postfix) with ESMTP id 8A9F343FBD; Wed, 27 Aug 2003 02:42:00 -0700 (PDT) (envelope-from Alexander@Leidinger.net) Received: from fwd02.aul.t-online.de by mailout01.sul.t-online.com with smtp id 19rwoR-0001hV-00; Wed, 27 Aug 2003 11:41:59 +0200 Received: from Andro-Beta.Leidinger.net (Gn3VbeZFwetCv-kc+sWe9dqEklA6TOWM2LcaO7-SajLcj3uBjxum8k@[80.131.113.207]) by fmrl02.sul.t-online.com with esmtp id 19rwo8-1nj51c0; Wed, 27 Aug 2003 11:41:40 +0200 Received: from Magelan.Leidinger.net (Magelan [192.168.1.1]) h7R9gg9O084999; Wed, 27 Aug 2003 11:42:42 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Received: from Magelan.Leidinger.net (netchild@localhost [127.0.0.1]) by Magelan.Leidinger.net (8.12.9/8.12.9) with SMTP id h7R9hGBA008201; Wed, 27 Aug 2003 11:43:16 +0200 (CEST) (envelope-from Alexander@Leidinger.net) Date: Wed, 27 Aug 2003 11:43:16 +0200 From: Alexander Leidinger To: freebsd-performance@freebsd.org Message-Id: <20030827114316.300fd455.Alexander@Leidinger.net> In-Reply-To: <3F4C143D.7000909@potentialtech.com> References: <3F4C143D.7000909@potentialtech.com> X-Mailer: Sylpheed version 0.9.3claws (GTK+ 1.2.10; i386-portbld-freebsd5.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Seen: false X-ID: Gn3VbeZFwetCv-kc+sWe9dqEklA6TOWM2LcaO7-SajLcj3uBjxum8k@t-dialin.net cc: freebsd-fs@freebsd.org cc: Bill Moran 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 09:42:01 -0000 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. The ext2fs async mount may lose the FS in the power failure case, ufs+SU doesn't. 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. About the "without debugging" description: did you really only remove INVARIANTS? If yes: you also need to remove WITNESS. 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. Bye, Alexander. -- I believe the technical term is "Oops!" http://www.Leidinger.net Alexander @ Leidinger.net GPG fingerprint = C518 BC70 E67F 143F BE91 3365 79E2 9C60 B006 3FE7