Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group