From owner-freebsd-stable@FreeBSD.ORG Thu Dec 20 14:35:54 2007 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 1895B16A419 for ; Thu, 20 Dec 2007 14:35:54 +0000 (UTC) (envelope-from kometen@gmail.com) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.250]) by mx1.freebsd.org (Postfix) with ESMTP id C764C13C442 for ; Thu, 20 Dec 2007 14:35:53 +0000 (UTC) (envelope-from kometen@gmail.com) Received: by an-out-0708.google.com with SMTP id c14so982542anc.13 for ; Thu, 20 Dec 2007 06:35:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=zQxfidO1x8+uYnfwRxx1VftC5JbwuFfc3RgT2e0MJT0=; b=JlA3+IUouPhThDc3hajXfbPly61DT5EwROr4C+2zrMZF+8jFwH3VSiF/TV4ZQv3ZdKEXL8WnTE2yrMCCSssgkAMTInX8mEDQf+6ZaHeuJqEZB0C9H3vC2n5wVZ1anpsiS4y9bJPPEQVo4UiO6ny61FiZqPyG+L72+lIV2Nww8cs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=jF9fi61oqGZYNW62eB1NLLGJV+mdFR/avcXUuQmsl6cNpOqpwR4fdrg725di4YPBZ1/cetnfQyDh8F+HCOayQfxiAPDy0RiA1w+iCGD2FP3thb7SdmveIMSkNS24X/8MrTfT6LCbrIAlkenh2ErNRB6PCqYW+hvTbaYg5MmCNnM= Received: by 10.100.229.10 with SMTP id b10mr93456anh.37.1198161352627; Thu, 20 Dec 2007 06:35:52 -0800 (PST) Received: by 10.100.228.15 with HTTP; Thu, 20 Dec 2007 06:35:52 -0800 (PST) Message-ID: Date: Thu, 20 Dec 2007 15:35:52 +0100 From: "Claus Guttesen" To: "Krassimir Slavchev" In-Reply-To: <476A5EE1.9000003@bulinfo.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <476A5EE1.9000003@bulinfo.net> Cc: FreeBSD 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 20 Dec 2007 14:35:54 -0000 > I have read all related threads about performance problems with multi > core systems but still have no idea what to do to make thinks better. > Below are results of testing postgresql on HP DL380G5 using sysbench. > The results are comparable to: > http://blog.insidesystems.net/articles/2007/04/11/postgresql-scaling-on-6-2-and-7-0 > but the same tests running on the same hardware using Linux (kernel > 2.6.18-53.1.4.el5 SMP x86_64) are very different. > PostgreSQL is tuned equal. > > results: > FreeBSD 7.0-BETA4 amd64 (cvsup on 20.12) GENERIC with SCHED_ULE > #threads #transactions/sec user/system > 1 500 7.4%,5.3% > 5 1990 30.9%,23.4% > 10 2510 39.9%,35.0% > 20 2549 44.5%,43.5% > 40 1921 29.8%,59.4% > 60 1580 22.7%,70.6% > 80 1341 18.9%,75.9% > 100 1227 16.5%,79.3% > > Linux > #threads #transactions/sec > 1 693 > 5 3539 > 10 5789 > 20 5791 > 40 5661 > 60 5517 > 80 5401 > 100 5319 > > What can be done to improve these results? What postgres-version did you use for this benchmark? Eventhough this is a synthetic benchmark the difference in performance may indicate some penalties on 8-core servers on FreeBSD. According to http://people.freebsd.org/~kris/scaling/mysql.html mysql scale the same until until 8 clients on both Linux and FreeBSD. This is an older test though and Linux has probably done some optimizations. Could be interesting so see whether the results differ if you disable one of the cpu's and rerun the tests. -- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare