From owner-freebsd-performance@FreeBSD.ORG Wed Mar 14 07:16:11 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 516BA16A400 for ; Wed, 14 Mar 2007 07:16:11 +0000 (UTC) (envelope-from kris@obsecurity.org) Received: from elvis.mu.org (elvis.mu.org [192.203.228.196]) by mx1.freebsd.org (Postfix) with ESMTP id 4023A13C459 for ; Wed, 14 Mar 2007 07:16:11 +0000 (UTC) (envelope-from kris@obsecurity.org) Received: from obsecurity.dyndns.org (elvis.mu.org [192.203.228.196]) by elvis.mu.org (Postfix) with ESMTP id 0FAC91A3C1A; Wed, 14 Mar 2007 00:16:11 -0700 (PDT) Received: by obsecurity.dyndns.org (Postfix, from userid 1000) id 31C8A5187D; Wed, 14 Mar 2007 03:16:10 -0400 (EDT) Date: Wed, 14 Mar 2007 03:16:10 -0400 From: Kris Kennaway To: Boris Samorodov Message-ID: <20070314071609.GA19728@xor.obsecurity.org> 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> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <45849703_-_@srv.sem.ipt.ru> User-Agent: Mutt/1.4.2.2i Cc: freebsd-performance@freebsd.org, Kris Kennaway Subject: Re: postgresql benchmarking (was: Re: FreeBSD mysql Benchmark on 4BSD/ULE scheduler and i386/amd64) 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:16:11 -0000 On Wed, Mar 14, 2007 at 09:42:00AM +0300, Boris Samorodov wrote: > (transferring the thread from freebsd-stable@ to freebsd-performance@) > > 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 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. Kris