Re: Packed short varlenas, what next?

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.
>
>