|The PostgreSQL 9.0 Reference Manual - Volume 3 - Server Administration Guide
by The PostgreSQL Global Development Group
Paperback (6"x9"), 274 pages
RRP £9.95 ($14.95)
Sales of this book support the PostgreSQL project! Get a printed copy>>>
22.214.171.124 Compiling for optimal performance
On the SPARC architecture, Sun Studio is strongly recommended for
compilation. Try using the
flag to generate significantly faster binaries. Do not use any
flags that modify behavior of floating-point operations
errno processing (e.g.,
-fast). These flags could raise some
nonstandard PostgreSQL behavior for example in the date/time
If you do not have a reason to use 64-bit binaries on SPARC, prefer the 32-bit version. The 64-bit operations are slower and 64-bit binaries are slower than the 32-bit variants. And on other hand, 32-bit code on the AMD64 CPU family is not native, and that is why 32-bit code is significant slower on this CPU family.
Some tricks for tuning PostgreSQL and Solaris for performance can be found at http://www.sun.com/servers/coolthreads/tnb/applications_postgresql.jsp. This article is primary focused on T2000 platform, but many of the recommendations are also useful on other hardware with Solaris.
|ISBN 9781906966072||The PostgreSQL 9.0 Reference Manual - Volume 3 - Server Administration Guide||See the print edition|