PGSQL PERFORMANCE 37 RE PROCESSOR OPTIMIZATION COMPILE OPTIONS
From: postgres@no-spam ("Alexander Kirpa")
Subject: Re: Processor optimization compile options?
Date: Mon, 20 Dec 2004 06:45:11 +0200


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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html