Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 07ADC9FA1DE for ; Mon, 11 Dec 2006 10:06:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 34869-10 for ; Mon, 11 Dec 2006 10:06:32 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from cassarossa.samfundet.no (cassarossa.samfundet.no [129.241.93.19]) by postgresql.org (Postfix) with ESMTP id 83BA19F9F47 for ; Mon, 11 Dec 2006 10:06:32 -0400 (AST) Received: from trofast.ipv6.sesse.net ([2001:700:300:1803:20e:cff:fe36:a766] helo=trofast.sesse.net) by cassarossa.samfundet.no with esmtp (Exim 4.50) id 1Gtlna-0000hY-Nk for pgsql-performance@postgresql.org; Mon, 11 Dec 2006 15:06:31 +0100 Received: from sesse by trofast.sesse.net with local (Exim 3.36 #1 (Debian)) id 1Gtlni-0006nY-00 for ; Mon, 11 Dec 2006 15:06:38 +0100 Date: Mon, 11 Dec 2006 15:06:38 +0100 From: "Steinar H. Gunderson" To: pgsql-performance@postgresql.org Subject: Re: New to PostgreSQL, performance considerations Message-ID: <20061211140638.GB25975@uio.no> Mail-Followup-To: pgsql-performance@postgresql.org 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> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <8a0c7af10612110531sbb019ck259fb16d131fdb50@mail.gmail.com> X-Operating-System: Linux 2.6.19 on a x86_64 X-Message-Flag: Outlook? --> http://www.mozilla.org/products/thunderbird/ User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/228 X-Sequence-Number: 22284 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 */ -- Homepage: http://www.sesse.net/