Postgres Pro
Downloads
Home   >   mailing lists

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 B80E6FB9-7E71-4E3F-985A-235DF1FC4B06@kineticode.com
Whole thread Raw
In response to Re: SELECT constant; takes 15x longer on 9.0?  (Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>)
Responses Re: SELECT constant; takes 15x longer on 9.0?  (Merlin Moncure <mmoncure@gmail.com>)
Re: SELECT constant; takes 15x longer on 9.0?  ("David E. Wheeler" <david@kineticode.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Remaining Streaming Replication Open Items
Next
From: "David E. Wheeler"
Date:
Subject: Re: SELECT constant; takes 15x longer on 9.0?