Re: SELECT constant; takes 15x longer on 9.0? - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: SELECT constant; takes 15x longer on 9.0?
Date
Msg-id 38864387-BA76-44EF-B1D8-A0D87FFA5ACC@kineticode.com
Whole thread Raw
In response to Re: SELECT constant; takes 15x longer on 9.0?  ("David E. Wheeler" <david@kineticode.com>)
List pgsql-hackers
On Apr 6, 2010, at 10:52 AM, David E. Wheeler wrote:

> Oh FFS! I was looking at the wrong build script. It was indeed built with  --enable-cassert --enable-debug. Grrr.
>
> Well, that's likely the culprit right there. I'm rebuilding without those now and hopefully my tests will be back
downto 45s. 
>
> Many apologies for the noise and wasted time.

And just to close out this thread, I rebuilt without `--enable-cassert --enable-debug` and now the tests pass in 57s
and46s over two runs, just like on 8.4 (though with just the default postgresql.conf, unlike my 8.4 install). 

Phew! Knew it had to be somehting stup^H^H^Himple.

Best,

David



pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: SELECT constant; takes 15x longer on 9.0?
Next
From: Robert Haas
Date:
Subject: Re: Proposal: Add JSON support