From owner-freebsd-stable@FreeBSD.ORG  Wed Jan  9 18:51:05 2008
Return-Path: <owner-freebsd-stable@FreeBSD.ORG>
Delivered-To: stable@freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id E63BE16A419
	for <stable@freebsd.org>; Wed,  9 Jan 2008 18:51:05 +0000 (UTC)
	(envelope-from kris@FreeBSD.org)
Received: from weak.local (freefall.freebsd.org [IPv6:2001:4f8:fff6::28])
	by mx1.freebsd.org (Postfix) with ESMTP id B99DA13C461;
	Wed,  9 Jan 2008 18:51:04 +0000 (UTC)
	(envelope-from kris@FreeBSD.org)
Message-ID: <47851797.8050200@FreeBSD.org>
Date: Wed, 09 Jan 2008 19:51:03 +0100
From: Kris Kennaway <kris@FreeBSD.org>
User-Agent: Thunderbird 2.0.0.9 (Macintosh/20071031)
MIME-Version: 1.0
To: Krassimir Slavchev <krassi@bulinfo.net>
References: <476A5EE1.9000003@bulinfo.net> <476FF662.6050604@FreeBSD.org>
	<477BB7C0.3060603@bulinfo.net> <477C1FA3.2070904@FreeBSD.org>
	<477CC7DC.6060801@bulinfo.net> <47840D21.6060807@FreeBSD.org>
	<47847681.9040304@bulinfo.net> <478479CA.7070000@FreeBSD.org>
	<4784A4B0.5070403@bulinfo.net> <4784A817.2080305@FreeBSD.org>
	<4784C0B1.3060108@bulinfo.net>
In-Reply-To: <4784C0B1.3060108@bulinfo.net>
Content-Type: text/plain; charset=ISO-8859-2; format=flowed
Content-Transfer-Encoding: 7bit
Cc: stable@freebsd.org
Subject: Re: Performance!
X-BeenThere: freebsd-stable@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Production branch of FreeBSD source code <freebsd-stable.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>, 
	<mailto:freebsd-stable-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-stable>
List-Post: <mailto:freebsd-stable@freebsd.org>
List-Help: <mailto:freebsd-stable-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-stable>,
	<mailto:freebsd-stable-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Wed, 09 Jan 2008 18:51:06 -0000

Krassimir Slavchev wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
> 
> Hello,
> 
> Kris Kennaway wrote:
>> Krassimir Slavchev wrote:
>>> -----BEGIN PGP SIGNED MESSAGE-----
>>> Hash: SHA1
>>>
>>> Hello,
>>>
>>> Here are lock profiling results with select patch applied.
>> OK, you are doing I/O over TCP.  Are you sure you are using TCP on both
>> systems?  Linux may not be defaulting to TCP transport for local queries.
>>
>> Add --pgsql-host="" to your sysbench command line to make it communicate
>> over a local domain socket, which is much more efficient.
>>
>> Kris
>>
> 
> Hmm, Yes linux uses local domain sockets!
> Here are results using local domain sockets on FreeBSD too:
> #threads        #tranzactions/sec
> 1               728
> 5               2996
> 10              5301
> 20              3931
> 40              2466
> 60              1852
> 80              1424
> 100             1216
> 
> Just to remember:
> Linux (2.6.18)
> #threads        #transactions/sec
> 1               693
> 5               3539
> 10              5789
> 20              5791
> 40              5661
> 60              5517
> 80              5401
> 100             5319
> 
> I have results using Fedora 8 on the same hardware:
> Linux (2.6.23)
> #threads        #transactions/sec
> 1               740
> 5               2675
> 10              6486
> 20              6893
> 40              6623
> 60              6623
> 80              6522
> 100             6417
> 
> If we look at the results with up to 10 threads the performance of
> FreeBSD is very good.
> May be something can be tuned for number of threads > number of CPUs?
> 
> Are you interested in lock profiling statistics with more threads than
> the number of CPUs?

Yes, it's still performing anomalously.  Glad we're making progress 
though :)

Kris