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

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
Cc: Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, 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 17:47:56
Message-ID: h2pb42b73151004061047u38f69a7dp680d9e40a0e1a19a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Apr 6, 2010 at 12:08 PM, David E. Wheeler <david(at)kineticode(dot)com> wrote:
> On Apr 6, 2010, at 2:32 AM, Takahiro Itagaki wrote:
>
>>> In our test, which does 5801 of these pings during the test, they take
>>> an average of 15x longer to execute on 9.0 as 8.4 ( 0.77ms vs. 0.05ms ).
>>>
>>> Any clue why this would be?
>>
>> Did you use the same configure options between them?
>
> Yes.
>
>> For example, --enable-debug or --enable-cassert.

hmm. ssl? (I don't see any interesting difference in time either
btw). can you log in w/psql and confirm the difference there w/timing
switch?

merlin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message David E. Wheeler 2010-04-06 17:52:25 Re: SELECT constant; takes 15x longer on 9.0?
Previous Message Magnus Hagander 2010-04-06 17:39:56 Re: BUG #5394: invalid declspec for PG_MODULE_MAGIC