BenchmarkSQL is open source, but, I don't think anyone has published version
5.2 yet on pgFoundry.   Amongst other goodies, version 5.2 allows for the
running of Java based tpcC and/or tpcB like benchmarks from the command line
or the cutsie gui.   We've also added consistency checks to the end of the
tpc-c run (which mysql always fails).

Affan is coming out shortly with version 5.3, he'll publish by early next
week.

As a side note and different topic:  The tpcB is an example of a verrryy
disk intensive little transaction.  Running it with a mocked up version
COMMIT NOWAIT produces a 4x performance increase for disk setups where fsync
is not "free".

--Luss
  http://www.enterprisedb.com


On 2/27/07, Gregory Stark <stark(at)enterprisedb(dot)com> wrote:
>
>
>
> I've been doing some benchmarking, I see a 9.7% space saving on the
> Benchmark-SQL 5.2 schema which translates into about a 8% performance
> gain.
> The DBT2 benchmarks show a smaller 5.3% space saving because we had
> already
> done a lot more optimizing of the schema.
>
>

In response to

• Packed short varlenas, what next? at 2007-02-27 13:46:18 from Gregory Stark

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2007-03-01 06:17:03
	Subject: Re: Resumable vacuum proposal and design overview
Previous:	From: Tom Lane	Date: 2007-03-01 06:06:04
	Subject: Re: Is there a way to run heap_insert() AFTER ExecInsertIndexTuples() ?