From owner-freebsd-performance@FreeBSD.ORG Mon Jan 28 15:28:42 2008 Return-Path: Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 1DF9616A417 for ; Mon, 28 Jan 2008 15:28:42 +0000 (UTC) (envelope-from kometen@gmail.com) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.241]) by mx1.freebsd.org (Postfix) with ESMTP id D034813C457 for ; Mon, 28 Jan 2008 15:28:41 +0000 (UTC) (envelope-from kometen@gmail.com) Received: by an-out-0708.google.com with SMTP id c14so448045anc.13 for ; Mon, 28 Jan 2008 07:28:41 -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:mime-version:content-type:content-transfer-encoding:content-disposition; bh=ZoKXLTDuoGsZTT8FNhhCRTUNnzHdBeOHNC6wjqtR7mU=; b=KDTyfbBUe4Z+08blNl9aPUn5m4SoQ6NiM6oG/i7zG+1IFMXeoyNWCikwZuqAwsTwVVSvs9Kp/h7GTYWuTmzlSh7HkoAwy9BbEnQJpP3n36w5ZqjxPxSpnwrx5+qKwgM3dqXZy+bpPEF/QmVPOLl8aVc5bS6/nSb0lHAsd8ocC3g= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=Nm3abUHt3oz8TGh4SyqOoS7IlCGYOychg+TK5ec/uVaL/L1YQOKNRPCnCJ6D/ekPnp+sSNywlroaDjVM3bOB5NRZLMXpVgwuRTJelE5nv7mleREpg/aKLJb1psZFkvV3QgPY7HCe6lMqLZWHUg8xv72ugEx7SbCP4qBfiuWon5Y= Received: by 10.100.216.3 with SMTP id o3mr12065178ang.95.1201532471204; Mon, 28 Jan 2008 07:01:11 -0800 (PST) Received: by 10.100.242.10 with HTTP; Mon, 28 Jan 2008 07:01:11 -0800 (PST) Message-ID: Date: Mon, 28 Jan 2008 16:01:11 +0100 From: "Claus Guttesen" To: "FreeBSD Mailing Lists" MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Subject: postgresql-performance using sysbench X-BeenThere: freebsd-performance@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Performance/tuning List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 28 Jan 2008 15:28:42 -0000 Hi. I have a HP DL360 G5 with a p800 controller with 512 bbwc and a msa70 cabinet with eight 15K rpm sas-disks in raid 1+0. I installed FreeBSD 7.0 stable and ubuntu 7.10 server using postgresql 8.2.5 (from ports on FreeBSD and as an install-option on ubuntu). Both releases are amd64. Postgresql on FreeBSD was compiled with WITH_THREADSAFE=true (/var/db/ports/postgresql82/options). The server is a two x quad-core @ 2.33 GHz with 16 GB ram. I installed RC1 and csup'ed to latest FreeBSD 7 stable and recompiled world and kernel. Removed options and devices I don't need like msdos, ntfs, nfs. Ubuntu is a stock install, ie. kernel-upgrade. Kernel does not have WITNESS etc. Then I installed and ran sysbench on postgresql using these settings: Postgresql.conf is the stock-configuration as created when running initdb except I raised shared_buffers = 128MB on both FreeBSD and Ubuntu (and raised sysctl-values as well to accomodate the larger shared_buffers). sysbench --test=oltp --pgsql-user=claus --oltp-table-size=100000 prepare After that I ran sysbench using this loop: run=5 clients=50 for ((a=10; a<=$clients; a=a+2)) do for ((b=1; b<=$run; b++)) do psql -d sbtest -h localhost -U claus -c "vacuum analyse;" sysbench --test=oltp --num-threads=${a} --pgsql-user=claus --pgsql-host="" --max-time=300 --max-requests=10000 --oltp-table-size=100000 run >> sysbench-clients-${a} done done Ubuntu 7.10: grep "transactions:" sysbench-clients-24|sort transactions: 10000 (2354.49 per sec.) transactions: 10001 (2126.28 per sec.) transactions: 10001 (2215.52 per sec.) transactions: 10001 (2236.03 per sec.) FreeBSD 7.0 stable as of Jan. 28'th: grep "transactions:" sysbench-clients-24|sort transactions: 10001 (1600.36 per sec.) transactions: 10002 (1963.95 per sec.) transactions: 10005 (1973.17 per sec.) In other runs FreeBSD also seems to trail Ubuntu. Are there any knobs I could try on FreeBSD? -- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare