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>
index | next in thread | previous in thread | raw e-mail
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. Krishome | help
Want to link to this message? Use this
URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20070314074101.GA20470>