Re: Performance bug in prepared statement binding in 9.2? - Mailing list pgsql-performance

From Bruce Momjian
Subject Re: Performance bug in prepared statement binding in 9.2?
Date
Msg-id 20130910115018.GD32160@momjian.us
Whole thread Raw
In response to Re: Performance bug in prepared statement binding in 9.2?  (Mel Llaguno <mllaguno@coverity.com>)
List pgsql-performance
On Tue, Sep 10, 2013 at 05:43:16AM +0000, Mel Llaguno wrote:
> Bruce,
>
> First of all, I'd like to thank you for taking some interest in this
> issue. We'd love to migrate to the latest PG version, but this issue
> is currently preventing us from doing so.
>
> Regardless of the DB used (base application schema _or_ restored DB
> with additional app data + base application schema), seed information
> is present in all tests. I guess my question is this - why would
> having existing data change the bind behavior at all? Is it possible
> that the way indexes are created has changed between 8.4 -> 9.x?

I don't know as you have not shown us exactly what is slower between
versions --- you only said the bug appears or not in certain
circumstances.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +


pgsql-performance by date:

Previous
From: Mel Llaguno
Date:
Subject: Re: Performance bug in prepared statement binding in 9.2?
Next
From: Andres Freund
Date:
Subject: Re: Performance bug in prepared statement binding in 9.2?