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 26090.1270583440@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>)
Re: SELECT constant; takes 15x longer on 9.0?  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
"David E. Wheeler" <david@kineticode.com> writes:
> On Apr 6, 2010, at 11:15 AM, Tom Lane wrote:
>> 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 doing this on a Mac?

I hadn't, but since you mention it: 100000 iterations take about 7.5sec
with non-assert CVS HEAD and 15sec with asserts, on a 2008 Macbook Pro.
Color me still confused.
        regards, tom lane


pgsql-hackers by date:

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