pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Processor optimization compile options?
2+ messages / 2 participants
[nested] [flat]

* Processor optimization compile options?
@ 2004-12-06 17:26  Josh Berkus <josh@agliodbs.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Josh Berkus @ 2004-12-06 17:26 UTC (permalink / raw)
  To: pgsql-performance

Folks,

I'm wondering if people have had success with 7.4 and 8.0 using specific 
compile optimizations not provided by the default PG install.    Since -O2 
and others have been built into config, I've not been doing much myself.   

What are other people's experiences in this area?   Do you have any stats to 
back it up?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Processor optimization compile options?
@ 2004-12-20 04:45  Alexander Kirpa <postgres@bilteks.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Alexander Kirpa @ 2004-12-20 04:45 UTC (permalink / raw)
  To: pgsql-performance

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




^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-12-20 04:45 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-12-06 17:26 Processor optimization compile options? Josh Berkus <josh@agliodbs.com>
2004-12-20 04:45 Re: Processor optimization compile options? Alexander Kirpa <postgres@bilteks.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox