Re: Benchmarking PGSQL?

Thanks for the tips, Josh. Would you know of where I can find the TpC-E
effort online? I've looked, and have only found references to the 'summer of
code' project that Riklas was doing/mentoring.

Also, I'm going to spend some time digging into the code, for the WAL log
issue you mentioned. Let's see what I can come up with... (I must confess
I'm not a Guru with Database internals, but I'll give this my best...)

Krishna

On 2/15/07, Josh Berkus <josh(at)agliodbs(dot)com> wrote:
>
> Krisna,
>
> > I'm a performance engineer, quite interested in getting deep into the
> > PGSQL performance enhancement effort. In that regard, I have the
> > following questions :
> > 1. Is there a benchmarking setup, that I can access online?
> > 2. What benchmarks are we running , for performance numbers?
> > 3. What are the current issues, related to performance?
> > 4. Where can I start, with the PGSQL performance effort?
>
> Hey, I work for Sun and we've been working on PostgreSQL & benchmarks.
> Hopefully we will soon have a server which runs Spec benchmarks which the
> community can legally use for testing (it's waiting on some setup issues).
>
> Help we could use right now includes work on an open source TPCE-like
> workload, being run by Rilson and Mark Wong. Another issue which could
> use help is reducing our WAL transaction log volume; it's higher than any
> other database. Or you could work on multi-processor scalability; we are
> still trying to identify the bottlenecks which are holding us back there.
>
> --
> --Josh
>
> Josh Berkus
> PostgreSQL @ Sun
> San Francisco
>