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

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:53:33
Message-ID: 97C8694E-6BAA-41DB-AB62-23181D92B1D6@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-04-06 19:55:01 Re: BUG #5394: invalid declspec for PG_MODULE_MAGIC
Previous Message Tom Lane 2010-04-06 19:50:40 Re: SELECT constant; takes 15x longer on 9.0?