On 12/11/06, Chris Browne <cbbrowne@xxxxxxx> wrote:
daniel.colchete@xxxxxxxxx ("Daniel van Ham Colchete") writes:
> You are right Christopher.
>
> Okay. Let's solve this matter.
>
> What PostgreSQL benchmark software should I use???
pgbench is one option.
There's a TPC-W at pgFoundry
(<http://pgfoundry.org/projects/tpc-w-php/>).
There's the Open Source Database Benchmark.
(<http://osdb.sourceforge.net/>)
Those are three reasonable options.
Thanks Chris, I'm going to take a look at those options.
> I'll test PostgreSQL 8.1 on a Fedora Core 6 and on a Gentoo. I'll get
> the same version FC6 uses and install it at my Gentoo. I'll use the
> same hardware (diferent partitions to each).
Wrong approach. You'll be comparing apples to oranges, because Gentoo
and Fedora pluck sources from different points in the source code
stream.
In order to prove what you want to prove, you need to run the
benchmarks all on Gentoo, where you run with 4 categorizations:
1. Where you run PostgreSQL and GLIBC without any processor-specific
optimizations
2. Where you run PostgreSQL and GLIBC with all relevant
processor-specific optimizations
3. Where you run PostgreSQL with, and GLIBC without
processor-specific optimizations
4. Where you run PostgreSQL without, and GLIBC with processor-specific
optimizations
That would allow one to clearly distinguish which optimizations are
particularly relevant.
Good ideia also. And it is much easier to do as well.
