Re: 8.0beta5 results w/ dbt2

On Mon, 2004-11-29 at 16:01 -0800, 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

It appears that WAL archiving (archive_command) is configured in 191 and
disabled (unset) in 199. Perhaps this accounts for some of the
difference?

--