centos install

[dx k9]

Greetings, Are there any compile options I should use when compiling(configure) posgresql-9.1.7 from source on a new centos 6.3 box? Just wondering what different gcc compile options are used in the postgresql 9.1 centos RPM that we could copy in an effort to increase kernel performance, get higher TPS on pgbench.
Thread model: posix
gcc version 4.4.6 20120305 (Red Hat 4.4.6-4) (GCC) -O2?
Thanks,~DjK

[Casey Allen Shobe]

Post by dx k9
Are there any compile options I should use when compiling(configure)
posgresql-9.1.7 from source on a new centos 6.3 box? Just wondering what
different gcc compile options are used in the postgresql 9.1 centos RPM
that we could copy in an effort to increase kernel performance, get higher
TPS on pgbench.

You can see what the current RPM build uses by executing pg_config, which
will show the CFLAGS, configure options, etc.

Does pgbench even do any CPU-intensive operations? If it's disk I/O-bound,
compiler optimizations aren't going to make any difference.

Cheers,

[Devrim GÜNDÜZ]

Hi,

Post by dx k9
Just wondering what different gcc compile options are used in the
postgresql 9.1 centos RPM that we could copy in an effort to increase
kernel performance, get higher TPS on pgbench.

http://svn.pgrpms.org/browser/rpm/redhat/9.1/postgresql/EL-6/postgresql-9.1.spec#L306

Regards,