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

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: SELECT constant; takes 15x longer on 9.0?
Date: 2010-04-06 18:06:42
Message-ID: 38864387-BA76-44EF-B1D8-A0D87FFA5ACC@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 down to 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 and 46s 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2010-04-06 18:10:32 Re: Proposal: Add JSON support
Previous Message David E. Wheeler 2010-04-06 18:04:15 Re: SELECT constant; takes 15x longer on 9.0?