Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id F17DB9FA0EE for ; Mon, 11 Dec 2006 09:32:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 46962-08 for ; Mon, 11 Dec 2006 09:31:41 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0102.google.com (nz-out-0506.google.com [64.233.162.231]) by postgresql.org (Postfix) with ESMTP id 1A97E9F931E for ; Mon, 11 Dec 2006 09:31:51 -0400 (AST) Received: by nz-out-0102.google.com with SMTP id i11so759556nzh for ; Mon, 11 Dec 2006 05:31:50 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=dHBphIG6NgMobikkq43EZ6JrICw6lGfIZMKhM4tC+nkTN/kocHLLNBaUT69egzP+627uoSlROt+BSBRkdRP2Lg62f0nrT8ic+OypAzxcZHcRr898GVSOq0RZFaGjTRqw+Mj85HV5XqrAVfIQ6l2IsasQEmmSexJ2SlNCHmu+Khs= Received: by 10.64.184.14 with SMTP id h14mr10896363qbf.1165843908756; Mon, 11 Dec 2006 05:31:48 -0800 (PST) Received: by 10.65.215.20 with HTTP; Mon, 11 Dec 2006 05:31:48 -0800 (PST) Message-ID: <8a0c7af10612110531sbb019ck259fb16d131fdb50@mail.gmail.com> Date: Mon, 11 Dec 2006 11:31:48 -0200 From: "Daniel van Ham Colchete" To: pgsql-performance@postgresql.org Subject: Re: New to PostgreSQL, performance considerations In-Reply-To: <87u002mv49.fsf@wolfe.cbbrowne.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/224 X-Sequence-Number: 22280 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 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 >