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
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".
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
> The DBT2 benchmarks show a smaller 5.3% space saving because we had
> done a lot more optimizing of the schema.
In response to
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() ? |