From: Daniel van Ham Colchete <daniel.colchete@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: New to PostgreSQL, performance considerations
Date: Mon, 11 Dec 2006 11:31:48 -0200
Message-ID: <8a0c7af10612110531sbb019ck259fb16d131fdb50@mail.gmail.com> (raw)
In-Reply-To: <87u002mv49.fsf@wolfe.cbbrowne.com>
References: <8a0c7af10612101141n2c7727c3r2f92345753960808@mail.gmail.com>
<430d92a20612101336r3de8862coe618277fccb4006a@mail.gmail.com>
<8a0c7af10612101702i49b5a533v4a2300d90d9dae6b@mail.gmail.com>
<20061211021847.GE16692@mathom.us>
<8a0c7af10612110305u305124b2v3d63491b5f57a86b@mail.gmail.com>
<87u002mv49.fsf@wolfe.cbbrowne.com>
You are right Christopher.
Okay. Let's solve this matter.
What PostgreSQL benchmark software should I use???
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).
I'm not saying that Gentoo is faster than FC6. I just want to prove
that if you compile your software to make better use of your
processor, it will run faster.
It might take a few days because I'm pretty busy right now at my job.
Best regards,
Daniel
On 12/11/06, Christopher Browne <cbbrowne@acm.org> wrote:
> Oops! daniel.colchete@gmail.com ("Daniel van Ham Colchete") was seen spray-painting on a wall:
> > But, trust me on this one. It's worth it.
>
> No, the point of performance analysis is that you *can't* trust the
> people that say "trust me on this one."
>
> If you haven't got a benchmark where you can demonstrate a material
> and repeatable difference, then you're just some Gentoo "speed racer"
> making things up.
> --
> select 'cbbrowne' || '@' || 'acm.org';
> http://linuxdatabases.info/info/wp.html
> One last point about metaphor, poetry, etc. As an example to
> illustrate these capabilities in Sastric Sanskrit, consider the
> "bahuvrihi" construct (literally "man with a lot of rice") which is
> used currently in linguistics to describe references outside of
> compounds.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: daniel.colchete@gmail.com
Subject: Re: New to PostgreSQL, performance considerations
In-Reply-To: <8a0c7af10612110531sbb019ck259fb16d131fdb50@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox