pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
centos 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