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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: SELECT constant; takes 15x longer on 9.0?
Date: 2010-04-06 19:50:40
Message-ID: 26090.1270583440@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"David E. Wheeler" <david(at)kineticode(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David E. Wheeler 2010-04-06 19:53:33 Re: SELECT constant; takes 15x longer on 9.0?
Previous Message Yeb Havinga 2010-04-06 19:39:44 Re: Proposal: Add JSON support