From owner-freebsd-performance@FreeBSD.ORG Tue Jan 29 14:36:22 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 DC36C16A476 for ; Tue, 29 Jan 2008 14:36:22 +0000 (UTC) (envelope-from mike@sentex.net) Received: from smarthost2.sentex.ca (smarthost2.sentex.ca [205.211.164.50]) by mx1.freebsd.org (Postfix) with ESMTP id 9F0A813C468 for ; Tue, 29 Jan 2008 14:36:22 +0000 (UTC) (envelope-from mike@sentex.net) Received: from lava.sentex.ca (pyroxene.sentex.ca [199.212.134.18]) by smarthost2.sentex.ca (8.14.2/8.14.2) with ESMTP id m0TEIcAa028487; Tue, 29 Jan 2008 09:18:38 -0500 (EST) (envelope-from mike@sentex.net) Received: from mdt-xp.sentex.net (simeon.sentex.ca [192.168.43.27]) by lava.sentex.ca (8.13.8/8.13.3) with ESMTP id m0TEIbsw076723 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Tue, 29 Jan 2008 09:18:38 -0500 (EST) (envelope-from mike@sentex.net) Message-Id: <200801291418.m0TEIbsw076723@lava.sentex.ca> X-Mailer: QUALCOMM Windows Eudora Version 7.1.0.9 Date: Tue, 29 Jan 2008 09:16:45 -0500 To: "Claus Guttesen" From: Mike Tancsa In-Reply-To: References: <200801281024.11571.darcyb@commandprompt.com> <479E3C5E.1070405@FreeBSD.org> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Cc: freebsd-performance@freebsd.org Subject: Re: 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: Tue, 29 Jan 2008 14:36:23 -0000 At 03:46 PM 1/28/2008, Claus Guttesen wrote: >I had (allready) saved the thread in my mail-account so I could look >it up before I started testing. :-) So I compiled postgresql with the >option WITH_THREADSAFE=true and used sysbench with --pgsql-host="" . >As pointed out by Ivan my test also involved r/w whereas the thread >you (probably) mention at >http://groups.google.com/group/mailing.freebsd.stable/browse_thread/thread/e224cd4f76e9ec2d >is a read-only test. > >I forgot to mention in my first post that I'm using ULE. The p800 >controller has a (factory set) 25/75 read/write cache ratio. I am still going through my own testing. One thing I noticed, on a 4G RAM machine (still waiting for the RAM to test with 8G), the disks are not that busy. It seems to be the CPU that is the bottleneck on FreeBSD. I tried the test with 900,000 rows instead. procs memory page disks faults cpu r b w avm fre flt re pi po fr sr ad5 da0 in sy cs us sy id 38 1 0 271024 3439656 6329 0 0 0 4 0 0 1703 1709 120725 41505 44 18 37 0 38 0 271024 3438860 9590 0 0 0 8 0 0 1932 1938 183844 47958 70 28 3 6 33 0 271024 3438120 7814 0 0 0 0 0 0 1823 1827 169969 44914 62 25 13 39 0 0 271024 3437960 1530 0 0 0 0 0 0 994 998 36521 14927 13 8 79 38 1 0 271024 3437244 7374 0 0 0 0 0 0 2724 2731 173493 51821 71 20 9 0 39 0 271024 3436620 4773 0 0 0 8 0 0 2727 2734 125699 39962 47 20 33 37 1 0 271024 3435836 6884 0 0 0 8 0 0 2796 2804 177453 58430 70 26 4 I am also using ULE, pgsql with WITH_THREADSAFE=true and not using TCP to connect. How busy were your disks in your testing ? ---Mike