From owner-freebsd-performance@FreeBSD.ORG Tue Jan 29 14:27:36 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 D336016A420 for ; Tue, 29 Jan 2008 14:27:36 +0000 (UTC) (envelope-from kometen@gmail.com) Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.245]) by mx1.freebsd.org (Postfix) with ESMTP id 8B02513C469 for ; Tue, 29 Jan 2008 14:27:36 +0000 (UTC) (envelope-from kometen@gmail.com) Received: by an-out-0708.google.com with SMTP id c14so565796anc.13 for ; Tue, 29 Jan 2008 06:27:35 -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=BtSgU9mPsmSjZ4b6nTbMtjLC1mE8Kwn2Uje6x2aM83c=; b=XTQqAOZq4lOCZEEUJR1pkuB+6RdTfWfgeL6LXWxkXoqYj+9zTgXTP+04H+aV6WRdThZNMDSRU/PLcehQELSAnUnRm7psDfJ1PC5ymWsOc9zyTcVLLvUU6766qMANppT0LD1+57Vshm+Zw1IEaa8cJN1QOC0kXa4+gwgPYY9DJVc= 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=e2fulleActKXFiaQ4s1/nfwDlOlTe6WYvJxrsRQ5L0GO90M8RhJpPXtQWShQT877jQFRoMOnZTU1eoulMzU/kJMKa0lVQjbdnaGCYNpqB5GNCSElQrABc1MWL3fDRmBe7WxTs0doODY5GMfM/6PeIkfT3BJ35rfqv4ewZcp7J6g= Received: by 10.100.57.6 with SMTP id f6mr14752207ana.113.1201616831119; Tue, 29 Jan 2008 06:27:11 -0800 (PST) Received: by 10.100.242.10 with HTTP; Tue, 29 Jan 2008 06:27:11 -0800 (PST) Message-ID: Date: Tue, 29 Jan 2008 15:27:11 +0100 From: "Claus Guttesen" To: "Mike Tancsa" In-Reply-To: <200801291418.m0TEIbsw076723@lava.sentex.ca> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <200801281024.11571.darcyb@commandprompt.com> <479E3C5E.1070405@FreeBSD.org> <200801291418.m0TEIbsw076723@lava.sentex.ca> 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:27:36 -0000 > >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 ? Approx. 15-25 MB with spikes at approx. 45-50 MB. Context-swithces were sometimes 140.000 with 20-30 clients (systat -vmstat 1). -- regards Claus When lenity and cruelty play for a kingdom, the gentlest gamester is the soonest winner. Shakespeare