From owner-freebsd-fs@FreeBSD.ORG  Wed Aug 27 08:51:22 2003
Return-Path: <owner-freebsd-fs@FreeBSD.ORG>
Delivered-To: freebsd-fs@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 8699016A4BF
	for <freebsd-fs@freebsd.org>; Wed, 27 Aug 2003 08:51:22 -0700 (PDT)
Received: from smtp.mho.com (smtp.mho.net [64.58.4.6])
	by mx1.FreeBSD.org (Postfix) with SMTP id 36DCC43FE5
	for <freebsd-fs@freebsd.org>; Wed, 27 Aug 2003 08:51:20 -0700 (PDT)
	(envelope-from scottl@freebsd.org)
Received: (qmail 29108 invoked by uid 1002); 27 Aug 2003 15:51:19 -0000
Received: from unknown (HELO freebsd.org) (64.58.1.252)
  by smtp.mho.net with SMTP; 27 Aug 2003 15:51:19 -0000
Message-ID: <3F4CD36C.40604@freebsd.org>
Date: Wed, 27 Aug 2003 09:51:08 -0600
From: Scott Long <scottl@freebsd.org>
User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.3) Gecko/20030425
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: Bill Moran <wmoran@potentialtech.com>
References: <3F4C143D.7000909@potentialtech.com>
	<20030827114316.300fd455.Alexander@Leidinger.net>
	<3F4CB7D2.9000503@potentialtech.com>
In-Reply-To: <3F4CB7D2.9000503@potentialtech.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
cc: freebsd-fs@freebsd.org
cc: Alexander Leidinger <Alexander@Leidinger.net>
cc: freebsd-performance@freebsd.org
Subject: Re: Performance tests I did with FreeBSD, Linux and PostgreSQL
X-BeenThere: freebsd-fs@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: Filesystems <freebsd-fs.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-fs>,
	<mailto:freebsd-fs-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-fs>
List-Post: <mailto:freebsd-fs@freebsd.org>
List-Help: <mailto:freebsd-fs-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-fs>,
	<mailto:freebsd-fs-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 27 Aug 2003 15:51:22 -0000

Bill Moran wrote:
> Alexander Leidinger wrote:
>> 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.

malloc debugging is disabled in 5.0-R and 5.1-R.  Once we hit
5-STABLE it will be turned off for good in the branch.

> 
> 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 ...
> 

It would be interesting to see if the recent locking of the ATA driver
has any benefit on these tests.  Of course if you update to 5-CURRENT
then you'll need to disable INVARIANTS, WITNESS, and malloc debugging.

Scott