Re: New to PostgreSQL, performance considerations

On 12/11/06, Chris Browne <cbbrowne@acm.org> wrote:
> daniel.colchete@gmail.com ("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.