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

From Tom Lane
Subject Re: SELECT constant; takes 15x longer on 9.0?
Date
Msg-id 24362.1270577714@sss.pgh.pa.us
Whole thread Raw
In response to Re: SELECT constant; takes 15x longer on 9.0?  ("David E. Wheeler" <david@kineticode.com>)
Responses Re: SELECT constant; takes 15x longer on 9.0?  ("David E. Wheeler" <david@kineticode.com>)
List pgsql-hackers
"David E. Wheeler" <david@kineticode.com> writes:
> On Apr 6, 2010, at 10:17 AM, Tom Lane wrote:
>> So I'm not sure where your 15x is coming from, but I don't see it.

> 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.
 

Huh.  I'm still curious, because in my test the overhead of those
options seemed to be about 3x.  So there's still something considerably
different between what you did and what I did.

Are you testing a separate connection per ping query?  I think I
neglected to compare that case with and without assert overhead.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Proposal: Add JSON support
Next
From: Tom Lane
Date:
Subject: Re: Proposal: Add JSON support