Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id F08D79FA0EF for ; Fri, 15 Dec 2006 06:28:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 75376-02 for ; Fri, 15 Dec 2006 06:28:27 -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 EACD29F9F08 for ; Fri, 15 Dec 2006 06:28:36 -0400 (AST) Received: from trofast.sesse.net ([129.241.93.32]) by cassarossa.samfundet.no with esmtp (Exim 4.50) id 1GvAIs-0001gI-3q for pgsql-performance@postgresql.org; Fri, 15 Dec 2006 11:28:34 +0100 Received: from sesse by trofast.sesse.net with local (Exim 3.36 #1 (Debian)) id 1GvAIh-0000YT-00 for ; Fri, 15 Dec 2006 11:28:23 +0100 Date: Fri, 15 Dec 2006 11:28:23 +0100 From: "Steinar H. Gunderson" To: pgsql-performance@postgresql.org Subject: Re: New to PostgreSQL, performance considerations Message-ID: <20061215102823.GA2024@uio.no> Mail-Followup-To: pgsql-performance@postgresql.org References: <4580264F.8030109@streppone.it> <4CD99FDA-14B5-4EA9-9440-55E2548C34C1@purefiction.net> <8BAB8EBF-548C-45EC-ABC0-3C301B482BA7@purefiction.net> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <8BAB8EBF-548C-45EC-ABC0-3C301B482BA7@purefiction.net> 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/398 X-Sequence-Number: 22454 On Fri, Dec 15, 2006 at 10:53:25AM +0100, Alexander Staubo wrote: > The difference is very slight. I'm going to run without -funroll- > loops and -pipe (which are not arch-related) to get better data. -pipe does not matter for the generated code; it only affects compiler speed. (It simply means that the compiler runs cpp | cc | as1 instead of cpp > tmp; cc < tmp > tmp2; as1 < tmp2.) /* Steinar */ -- Homepage: http://www.sesse.net/