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

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Takahiro Itagaki <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
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 16:08:44
Message-ID: B80E6FB9-7E71-4E3F-985A-235DF1FC4B06@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

No.

David

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David E. Wheeler 2010-04-06 16:09:07 Re: SELECT constant; takes 15x longer on 9.0?
Previous Message Tom Lane 2010-04-06 16:07:08 Re: Remaining Streaming Replication Open Items