[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: postgresql benchmarking
- To: Boris Samorodov <bsam_(_at_)_ipt_(_dot_)_ru>
- Subject: Re: postgresql benchmarking
- From: Kris Kennaway <kris_(_at_)_obsecurity_(_dot_)_org>
- Date: Wed, 14 Mar 2007 03:41:01 -0400
- Cc: freebsd-performance_(_at_)_freebsd_(_dot_)_org, Kris Kennaway <kris_(_at_)_obsecurity_(_dot_)_org>
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
freebsd-performance_(_at_)_freebsd_(_dot_)_org mailing list
To unsubscribe, send any mail to "freebsd-performance-unsubscribe_(_at_)_freebsd_(_dot_)_org"