Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id AC3E99F9398 for ; Tue, 12 Dec 2006 11:17:56 -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 76263-03 for ; Tue, 12 Dec 2006 11:17:29 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from mx01.bfk.de (mx01.bfk.de [193.227.124.2]) by postgresql.org (Postfix) with ESMTP id E47B39FA0B7 for ; Tue, 12 Dec 2006 11:17:29 -0400 (AST) Received: from [10.119.110.2] (helo=mx00.int.bfk.de) by mx01.bfk.de with esmtp id 1Gu9No-0004wq-4y; Tue, 12 Dec 2006 16:17:28 +0100 Received: from fweimer by bfk.de with local id 1Gu9Nn-00080L-Gy; Tue, 12 Dec 2006 16:17:27 +0100 To: Cosimo Streppone Cc: Postgresql Performance list Subject: Re: New to PostgreSQL, performance considerations References: <457EA39E.1020207@streppone.it> From: Florian Weimer Date: Tue, 12 Dec 2006 16:17:27 +0100 In-Reply-To: <457EA39E.1020207@streppone.it> (Cosimo Streppone's message of "Tue, 12 Dec 2006 13:42:06 +0100") Message-ID: <82psapuos8.fsf@mid.bfk.de> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/293 X-Sequence-Number: 22349 * Cosimo Streppone: > "-O0" ~ 957 tps > "-O1 -mcpu=3Dpentium4 -mtune=3Dpentium4" ~ 1186 tps > "-O2 -mcpu=3Dpentium4 -mtune=3Dpentium4" ~ 1229 tps > "-O3 -mcpu=3Dpentium4 -mtune=3Dpentium4" ~ 1257 tps > "-O6 -mcpu=3Dpentium4 -mtune=3Dpentium4" ~ 1254 tps -mcpu and -mtune are synonymous. You really should -march here (but the result is non-generic code). Keep in mind that GCC does not contain an instruction scheduler for the Pentium 4s. I also believe that the GCC switches are not fine-grained enough to cover the various Pentium 4 variants. For instance, some chips don't like the CMOV instruction at all, but others can process it with decent speed. --=20 Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstra=DFe 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99