Re: SELECT constant; takes 15x longer on 9.0? - Mailing list pgsql-hackers

From Takahiro Itagaki
Subject Re: SELECT constant; takes 15x longer on 9.0?
Date
Msg-id 20100406183237.9C63.52131E4D@oss.ntt.co.jp
Whole thread Raw
In response to SELECT constant; takes 15x longer on 9.0?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: SELECT constant; takes 15x longer on 9.0?  ("David E. Wheeler" <david@kineticode.com>)
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> wrote:

> SELECT 'DBD::Pg ping test';
> 
> 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?
For example, --enable-debug or --enable-cassert.

Regards,
---
Takahiro Itagaki
NTT Open Source Software Center




pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: Remaining Streaming Replication Open Items
Next
From: Simon Riggs
Date:
Subject: Re: message clarifications