Date: Mon, 9 Sep 2013 22:16:44 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Mel Llaguno <mllaguno@coverity.com>
Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: Performance bug in prepared statement binding in 9.2?
Message-ID: <20130910021644.GC32160@momjian.us>
References: 
 <E1FB7FBAE29E634FA58D6CC0D59F288B3412B4FD@CH1PRD0511MB442.namprd05.prod.outlook.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <E1FB7FBAE29E634FA58D6CC0D59F288B3412B4FD@CH1PRD0511MB442.namprd05.prod.outlook.com>
User-Agent: Mutt/1.5.20 (2009-06-14)
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

On Tue, Sep 10, 2013 at 02:06:08AM +0000, Mel Llaguno wrote:
> We're currently using an embedded PG 8.4.17 for our application. Our
> PG 9.x tests consists of one of the following :
>
> - Take a 8.4.17 DB which contains only our application schema and
> required seed data and use pg_upgrade to create a 9.x database
> directory, run the analyze_new_cluster.sh script and fire up the
> application. Under this set of conditions, the bind connection issue
> is present during our test.
>
> - Start with a fresh PG 9.x DB (using use create_db) and use psql
> to recreate our application schema and required seed data. When the
> application is started and our test executed, the bind connection
> issue is still present.
>
> In both of the above cases, a base application schema is used.
>
> If I upgrade an 8.4.17 DB that contains additional application data
> (generated by interaction with our application) to 9.x, the bind
> connection issue is no longer present. Restoring this upgraded 9.x DB
> into any PG instance in the previously described scenarios also seems
> to fix the bind connection issue.
>
> Please let me know if this clarifies my earlier post.

Yes, that is clear.  So it is the seed data that is causing the problem?
That is the only different I see from #2 and #3.

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

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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance