Date: Wed, 14 Mar 2007 03:41:01 -0400 From: Kris Kennaway <kris@obsecurity.org> To: Boris Samorodov <bsam@ipt.ru> Cc: freebsd-performance@freebsd.org, Kris Kennaway <kris@obsecurity.org> Subject: Re: postgresql benchmarking Message-ID: <20070314074101.GA20470@xor.obsecurity.org> In-Reply-To: <79766847@srv.sem.ipt.ru> 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> <79766847@srv.sem.ipt.ru>
next in thread | previous in thread | raw e-mail | index | archive | help
On Wed, Mar 14, 2007 at 10:29:36AM +0300, Boris Samorodov wrote: > 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. If that's not the target workload you're trying to model, that's quite reasonable. For me the only reason I have been using localhost exclusively is because the test machines are currently only connected by 100baseTX ethernet, which is not good enough for achieving high query loads. Kris
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20070314074101.GA20470>