Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id D69EE9F9EED for ; Mon, 11 Dec 2006 16:10:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 38112-08 for ; Mon, 11 Dec 2006 16:10:14 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.226]) by postgresql.org (Postfix) with ESMTP id 78C3D9F9312 for ; Mon, 11 Dec 2006 16:10:13 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id i30so861463wra for ; Mon, 11 Dec 2006 12:10:13 -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=ciK+mcmRElBZb4rzHYXKNLD8t0iqjlPe8HlUhpIzPFdzoejJAKHPlwFp4bzvUQFEsoLB6pBEy5Rmr/8d24bP9f5Cm7b19uj+bprcsEoc+K3vaItW2KyWktgonEt6wDffXboeXRB5PCcSybL/BX5of/X+3fClGzTclxPOuIO593A= Received: by 10.90.96.20 with SMTP id t20mr7364656agb.1165867812851; Mon, 11 Dec 2006 12:10:12 -0800 (PST) Received: by 10.65.215.20 with HTTP; Mon, 11 Dec 2006 12:10:12 -0800 (PST) Message-ID: <8a0c7af10612111210u224b2d22w540ca19785f5c9e4@mail.gmail.com> Date: Mon, 11 Dec 2006 18:10:12 -0200 From: "Daniel van Ham Colchete" To: pgsql-performance@postgresql.org Subject: Re: New to PostgreSQL, performance considerations In-Reply-To: <20061211140638.GB25975@uio.no> 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> <8a0c7af10612110531sbb019ck259fb16d131fdb50@mail.gmail.com> <20061211140638.GB25975@uio.no> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/261 X-Sequence-Number: 22317 On 12/11/06, Steinar H. Gunderson wrote: > On Mon, Dec 11, 2006 at 11:31:48AM -0200, Daniel van Ham Colchete wrote: > > What PostgreSQL benchmark software should I use??? > > Look up the list archives; search for "TPC". > > > 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). > > Why do you want to compare FC6 and Gentoo? Wasn't your point that the -march= > was supposed to be the relevant factor here? In that case, you want to keep > all other things equal; so use the same distribution, only with -O2 > -march=i686 vs. -march=athlon-xp (or whatever). > > /* Steinar */ Using Gentoo is just a easy way to make cflag optimizations to all the other libs as well: glibc, ... I can also mesure performance on Gentoo with cflag optimized PostgreSQL and plain PostgreSQL as well.