From owner-freebsd-performance@FreeBSD.ORG Wed Mar 14 07:26:01 2007 Return-Path: X-Original-To: freebsd-performance@freebsd.org Delivered-To: freebsd-performance@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id EC86916A402 for ; Wed, 14 Mar 2007 07:26:01 +0000 (UTC) (envelope-from bsam@ipt.ru) Received: from mail.ipt.ru (mail.ipt.ru [80.253.10.82]) by mx1.freebsd.org (Postfix) with ESMTP id A58B013C465 for ; Wed, 14 Mar 2007 07:26:01 +0000 (UTC) (envelope-from bsam@ipt.ru) Received: from stat.sem.ipt.ru ([192.168.12.1] helo=ipt.ru) by mail.ipt.ru with esmtp (Exim 4.62 (FreeBSD)) (envelope-from ) id 1HRNs0-000OWI-K3; Wed, 14 Mar 2007 10:26:00 +0300 Received: from bsam by ipt.ru with local (Exim 4.63 (FreeBSD)) (envelope-from ) id 1HRNvU-0003An-Ao; Wed, 14 Mar 2007 10:29:36 +0300 To: Kris Kennaway References: <20070313154729.1ec6abb7@DELOREAN.manuelmartini.it> <20070313194206.GA5957@crodrigues.org> <20070313195756.GA11679@xor.obsecurity.org> <20070313211908.59de6504@DELOREAN.manuelmartini.it> <20070313214559.GB13079@xor.obsecurity.org> <330A1347-2309-417E-83B5-5B2CE005B9C8@solfertje.student.utwente.nl> <20070314005546.GA15742@xor.obsecurity.org> <45849703_-_@srv.sem.ipt.ru> <20070314071609.GA19728@xor.obsecurity.org> From: Boris Samorodov Date: Wed, 14 Mar 2007 10:29:36 +0300 In-Reply-To: <20070314071609.GA19728@xor.obsecurity.org> (Kris Kennaway's message of "Wed, 14 Mar 2007 03:16:10 -0400") Message-ID: <79766847@srv.sem.ipt.ru> User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.0.50 (berkeley-unix) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Cc: freebsd-performance@freebsd.org Subject: Re: postgresql benchmarking 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: Wed, 14 Mar 2007 07:26:02 -0000 On Wed, 14 Mar 2007 03:16:10 -0400 Kris Kennaway wrote: > On Wed, Mar 14, 2007 at 09:42:00AM +0300, Boris Samorodov wrote: > > On Tue, 13 Mar 2007 20:55:46 -0400 Kris Kennaway wrote: > > > > > On the same test postgresql is indeed faster, I haven't finished > > > benchmarking it yet though. > > > > Kris, I'm interested at postgresql benchmarking at two-xeon-quad-core > > server with 3WARE RAID adapter. Can you give me some tips? > > Thank you. > Well I'm using sysbench and the collection of patches in my > kris-contention p4 branch. Sorry, I don't have an extracted patch set > available for you to try, but we're hoping to get the most important > patches into 7.0 within a week or two. > On the pgsql side, disable the update_process_titles option (or > whatever it is called), because this has a 33% performance overhead > for me. Also if you're testing over localhost, use a unix socket As for me, I don't like testing with local clients. > instead of letting it use tcp because the latter is easily saturated > when you have many CPUs running client threads, and peak performance > is less than half of what it is over a unix socket. ULE is faster on > 7.0, but currently has some performance problems at intermediate > loads; Jeff hopes to fix this soon. Got it, thanks! WBR -- Boris Samorodov (bsam) Research Engineer, http://www.ipt.ru Telephone & Internet SP FreeBSD committer, http://www.FreeBSD.org The Power To Serve