Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0F1FE9FA173 for ; Fri, 15 Dec 2006 05:54:43 -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 73929-06 for ; Fri, 15 Dec 2006 05:54:38 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from zaphod.byzantine.no (unknown [194.63.250.118]) by postgresql.org (Postfix) with ESMTP id 918F89FA0EF for ; Fri, 15 Dec 2006 05:54:38 -0400 (AST) Received: from [10.0.0.13] (235.80-203-102.nextgentel.com [80.203.102.235]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) by zaphod.byzantine.no (Postfix) with ESMTP id 0B233FA49; Fri, 15 Dec 2006 10:54:37 +0100 (CET) In-Reply-To: References: <457EA39E.1020207@streppone.it> <20061212124803.GA29167@mathom.us> <4580264F.8030109@streppone.it> <4CD99FDA-14B5-4EA9-9440-55E2548C34C1@purefiction.net> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <8BAB8EBF-548C-45EC-ABC0-3C301B482BA7@purefiction.net> Cc: Postgresql Performance list Content-Transfer-Encoding: 7bit From: Alexander Staubo Subject: Re: New to PostgreSQL, performance considerations Date: Fri, 15 Dec 2006 10:53:25 +0100 To: Ron X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/397 X-Sequence-Number: 22453 On Dec 15, 2006, at 04:09 , Ron wrote: > At 07:27 PM 12/14/2006, Alexander Staubo wrote: > >> Sorry, I neglected to include the pertinent graph: >> >> http://purefiction.net/paste/pgbench2.pdf > In fact, your graph suggests that using arch specific options in > addition to -O3 actually =hurts= performance. The difference is very slight. I'm going to run without -funroll- loops and -pipe (which are not arch-related) to get better data. Alexander.