Re: SELECT constant; takes 15x longer on 9.0?

David E. Wheeler wrote:
> By stupidly having configured with --enable-cassert --enable-debug without realizing it. I've just rebuilt without
themand run the tests again using the default postgresql.conf and I'm back down to 57s and 46s over two runs.
 
>   

Every performance test I run, regardless of where the binaries come from 
or how I thought they were built, starts like this:
postgres=# show debug_assertions; debug_assertions ------------------ off(1 row)


It's a really good habit to get into, or even enforce in your testing 
script if practical.

-- 
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us