Re: New to PostgreSQL, performance considerations

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



At 05:39 PM 12/14/2006, Alexander Staubo wrote:
On Dec 14, 2006, at 20:28 , Ron wrote:

Can you do runs with just CFLAGS="-O3" and just CFLAGS="-msse2 - mfpmath=sse -funroll-loops -m64 - march=opteron -pipe" as well ?

All right. From my perspective, the effect of -O3 is significant, whereas architecture-related optimizations have no statistically significant effect.

Is this opinion? Or have you rerun the tests using the flags I suggested? If so, can you post the results?

If "-O3 -msse2 - mfpmath=sse -funroll-loops -m64 - march=opteron -pipe" results in a 30-40% speed up over "-O0", and " -msse2 - mfpmath=sse -funroll-loops -m64 - march=opteron -pipe" results in a 5-10% speedup, then ~ 1/8 - 1/3 of the total possible speedup is due to arch specific optimizations.

(testing "-O3" in isolation in addition tests for independence of factors as well as showing what "plain" "-O3" can accomplish.)

Some might argue that a 5-10% speedup which represents 1/8 - 1/3 of the total speedup is significant...

But enough speculating.  I look forward to seeing your data.

Ron Peacetree


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux