From owner-freebsd-stable@FreeBSD.ORG Thu Dec 20 12:24:10 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 8B9F616A417 for ; Thu, 20 Dec 2007 12:24:10 +0000 (UTC) (envelope-from krassi@bulinfo.net) Received: from mx.bulinfo.net (mx.bulinfo.net [193.194.156.1]) by mx1.freebsd.org (Postfix) with ESMTP id 76C4513C45B for ; Thu, 20 Dec 2007 12:24:09 +0000 (UTC) (envelope-from krassi@bulinfo.net) Received: from localhost (localhost [127.0.0.1]) by mx.bulinfo.net (Postfix) with ESMTP id 204216272E for ; Thu, 20 Dec 2007 14:24:08 +0200 (EET) Received: from mx.bulinfo.net ([127.0.0.1]) by localhost (mx.bulinfo.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 64529-03 for ; Thu, 20 Dec 2007 14:24:04 +0200 (EET) Received: from [192.168.2.188] (pythia.bulinfo.net [212.72.195.5]) by mx.bulinfo.net (Postfix) with ESMTP id 1D37E62757 for ; Thu, 20 Dec 2007 14:24:04 +0200 (EET) Message-ID: <476A5EE1.9000003@bulinfo.net> Date: Thu, 20 Dec 2007 14:24:01 +0200 From: Krassimir Slavchev User-Agent: Thunderbird 2.0.0.9 (X11/20071122) MIME-Version: 1.0 To: FreeBSD X-Enigmail-Version: 0.95.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: amavisd-new at mx.bulinfo.net Subject: 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 12:24:10 -0000 -----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-----