Re: New to PostgreSQL, performance considerations

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