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 97C8694E-6BAA-41DB-AB62-23181D92B1D6@kineticode.com
Whole thread Raw
In response to Re: SELECT constant; takes 15x longer on 9.0?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: SELECT constant; takes 15x longer on 9.0?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On Apr 6, 2010, at 12:50 PM, Tom Lane wrote:

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

Well it's not just pings that the bricolage tests were running, of course.

Josh, might you have got the numbers wrong when trying to match up query runtimes to their queries in the CSVLOG
output?That might explain it. Most of the queries were BINDs. 

Best,

David




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: SELECT constant; takes 15x longer on 9.0?
Next
From: Pavel Stehule
Date:
Subject: Re: SELECT constant; takes 15x longer on 9.0?