From owner-freebsd-stable@FreeBSD.ORG Fri Dec 21 18:01:22 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 A386016A419 for ; Fri, 21 Dec 2007 18:01:22 +0000 (UTC) (envelope-from kip.macy@gmail.com) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.178]) by mx1.freebsd.org (Postfix) with ESMTP id 6407713C442 for ; Fri, 21 Dec 2007 18:01:22 +0000 (UTC) (envelope-from kip.macy@gmail.com) Received: by wa-out-1112.google.com with SMTP id k17so683547waf.3 for ; Fri, 21 Dec 2007 10:01:21 -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:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=Scux7xz1gbqa90Tr1yhcR4lbz1nIAUNN9zsOvx3sXA4=; b=oaUEFF+ZpceN2v2iQSUkAoYV8O1LqQIaLN9CXOb8WNXKc70riR+MacSJV4yMJRUCIKYjeM158K7igGAQVJ1S3CFEs92zL0x7CXSCptAr4Cw6zYJuwJwtF+zxjLDyrvDkn2xPGNid3b7hIoCTgF+wW4qt10qh1hPO1UhUDX08q3Y= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=SzSJ7vLzsmNiAOWfCLZJNZVEIYYrH4G1t+Wb+Gw/DGem+0PTdNYNPFujKiGLsPrTzuPnSCBNH8+YWK5MB7R2enRcCoOHaX5rgB20dXw4xkmjfMumMi/c8FC+JGk7htdIfTKl8yyOjN6+3FoYi0aSp2JfXoFrjEkZvMFTlfh1Po4= Received: by 10.115.74.1 with SMTP id b1mr497190wal.93.1198260081563; Fri, 21 Dec 2007 10:01:21 -0800 (PST) Received: by 10.114.255.11 with HTTP; Fri, 21 Dec 2007 10:01:21 -0800 (PST) Message-ID: Date: Fri, 21 Dec 2007 10:01:21 -0800 From: "Kip Macy" To: "Krassimir Slavchev" , FreeBSD 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: 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: Fri, 21 Dec 2007 18:01:22 -0000 Are you sure that the settitle call is disabled on FreeBSD? On 12/20/07, Krassimir Slavchev wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hello, > > 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. > > dmesg: > ... > CPU: Intel(R) Xeon(R) CPU X5450 @ 3.00GHz (3000.02-MHz > K8-class CPU) > Origin = "GenuineIntel" Id = 0x10676 Stepping = 6 > > Features=0xbfebfbff > > Features2=0xce3bd> > AMD Features=0x20000800 > AMD Features2=0x1 > Cores per package: 4 > usable memory = 8575655936 (8178 MB) > avail memory = 8288337920 (7904 MB) > ACPI APIC Table: > FreeBSD/SMP: Multiprocessor System Detected: 8 CPUs > ... > > test: > sysbench --num-threads=${i} --test=oltp --pgsql-user=bench > - --pgsql-db=bench --db-driver=pgsql --max-time=60 --max-requests=0 > - --oltp-read-only=on run > > tuning: > kern.ipc.shmmax=2147483647 > kern.ipc.shmall=524288 > kern.ipc.semmsl=512 > kern.ipc.semmap=256 > kern.ipc.somaxconn=2048 > kern.maxfiles=65536 > vfs.read_max=32 > > kern.ipc.semmni=256 > kern.ipc.semmns=2048 > > 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? > > Best Regards > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.7 (FreeBSD) > > iD8DBQFHal7hxJBWvpalMpkRAsaiAJ9G3ZoTv6cUbR4yix07TEMf7PKm7gCgoroM > +xvcXkcaFjSTxYfjk5rqMko= > =Tpsq > -----END PGP SIGNATURE----- > _______________________________________________ > freebsd-stable@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-stable > To unsubscribe, send any mail to "freebsd-stable-unsubscribe@freebsd.org" >