Обсуждение: centos install
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
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
On Thu, Jan 17, 2013 at 11:39 AM, dx k9 <bitsandbytes88@hotmail.com> wrote:
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,
--
Casey Allen Shobe
Casey Allen Shobe
Hi, On Thu, 2013-01-17 at 11:39 -0500, dx k9 wrote: > 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, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz