pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedcentos install
3+ messages / 3 participants
[nested] [flat]
* centos install
@ 2013-01-17 16:39 dx k9 <bitsandbytes88@hotmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: dx k9 @ 2013-01-17 16:39 UTC (permalink / raw)
To: pgsql-admin
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 =
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: centos install
@ 2013-01-17 17:19 Casey Allen Shobe <casey@shobe.info>
parent: dx k9 <bitsandbytes88@hotmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Casey Allen Shobe @ 2013-01-17 17:19 UTC (permalink / raw)
To: dx k9 <bitsandbytes88@hotmail.com>; +Cc: pgsql-admin
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@shobe.info
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: centos install
@ 2013-01-17 17:54 Devrim GÜNDÜZ <devrim@gunduz.org>
parent: dx k9 <bitsandbytes88@hotmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Devrim GÜNDÜZ @ 2013-01-17 17:54 UTC (permalink / raw)
To: dx k9 <bitsandbytes88@hotmail.com>; +Cc: pgsql-admin
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
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2013-01-17 17:54 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2013-01-17 16:39 centos install dx k9 <bitsandbytes88@hotmail.com>
2013-01-17 17:19 ` Casey Allen Shobe <casey@shobe.info>
2013-01-17 17:54 ` Devrim GÜNDÜZ <devrim@gunduz.org>
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