Skip site navigation (1) Skip section navigation (2)

Re: 8.0beta5 results w/ dbt2

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Mark Wong <markw(at)osdl(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org, testperf-general(at)pgfoundry(dot)org
Subject: Re: 8.0beta5 results w/ dbt2
Date: 2004-11-30 02:50:51
Message-ID: 200411300250.iAU2ope10141@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Mark Wong wrote:
> I have some initial results using 8.0beta5 with our OLTP workload.
> Off the bat I see about a 23% improvement in overall throughput.  The
> most significant thing I've noticed was in the oprofile report where
> FunctionCall2 and hash_seq_search have moved down the profile a bit.
> 
> Also, I have libc with symbols now so we can see what it's doing with
> in the oprofile output.
> 
> 8.0beta5 results:
> 	http://www.osdl.org/projects/dbt2dev/results/dev4-010/199/
> 	throughput: 4076.97
> 
> 8.0beta4 results:
> 	http://www.osdl.org/projects/dbt2dev/results/dev4-010/191/
> 	throughput: 3323.07

You saw an improvement of 23% from beta4 to beta5?  I didn't think we
did any major performance changes between those releases. Tom?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-hackers by date

Next:From: Greg Sabino MullaneDate: 2004-11-30 03:04:45
Subject: Re: Opinions on Usenet ...
Previous:From: Marc G. FournierDate: 2004-11-30 02:47:42
Subject: Re: Opinions on Usenet ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group