X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A54883A1D0C for ; Mon, 20 Dec 2004 04:45:26 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 88846-01 for ; Mon, 20 Dec 2004 04:45:22 +0000 (GMT) Received: from r163ip.btv.lv (r163ip.btv.lv [217.198.224.163]) by svr1.postgresql.org (Postfix) with ESMTP id C74CB3A1ADC for ; Mon, 20 Dec 2004 04:45:20 +0000 (GMT) Received: from p4 (pIV.homenet [192.168.88.4]) by r163ip.btv.lv (8.12.9/8.12.6) with ESMTP id iBK4jFoh050055 for ; Mon, 20 Dec 2004 06:45:18 +0200 (EET) (envelope-from postgres@bilteks.com) From: "Alexander Kirpa" To: pgsql-performance@postgresql.org Date: Mon, 20 Dec 2004 06:45:11 +0200 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: Processor optimization compile options? Message-ID: <41C674F7.11670.6A82BE2@localhost> X-mailer: Pegasus Mail for Win32 (v3.12c) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200412/258 X-Sequence-Number: 9633 Starting from 7.4.1 on P4 and FreeBSD 5.x (exclude 5.0 - gcc in this edition have optimization error) I use next configure command ---------------------------------- ./configure --prefix=/opt/postgres-7.4.1 --with-pgport=5432 --with-pam --enable-syslog --enable-depend 'CFLAGS= -O3 -pipe -mfpmath=sse -msse2 -msse -mmmx -march=pentium4 -mcpu=pentium4' --------------------------------- w/o any problem. As I remember improvement as always task depended and have 30-100%. Best regards, Alexander Kirpa