pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: Amit Kapila <amit.kapila@huawei.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance bug in prepared statement binding in 9.2?
Date: Fri, 31 May 2013 11:54:15 -0700
Message-ID: <51A8F1D7.2000109@agliodbs.com> (raw)
In-Reply-To: <WM!c84cb8479a8b2ec21d1061c951095da00bc52608e9822124f1438b9de432ec7ebedaf25085801b67d581eed6d368c344!@asav-2.01.com>
References: <51A699E6.3000008@agliodbs.com>
	<00b301ce5d3d$697449a0$3c5cdce0$@kapila@huawei.com>
	<WM!f3d412a8ff9fb2a52f4cfd0f48c225b6122ba5bf1e1523173b5dbc63db143b9cab09ac3f5518a12a19d2507538472d98!@asav-1.01.com>
	<51A79512.4020200@agliodbs.com>
	<000601ce5dd1$ec1d6320$c4582960$@kapila@huawei.com>
	<WM!c84cb8479a8b2ec21d1061c951095da00bc52608e9822124f1438b9de432ec7ebedaf25085801b67d581eed6d368c344!@asav-2.01.com>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>


> When you say interactively, does it mean that you are using psql to test the same?

Yes.  Of course, on the psql command line, there's no separate BIND
step, just PREPARE and EXECUTE.

> From the changes, it doesn't seem that any of such changes can cause the problem you have seen.

No, but clearly in this case something is broken.

> Do you think it can be due to
> a. JDBC - communication, encoding or some other changes
> b. can we assume that plans generated for all statements are same, if not it might have some cost for query plan initialization (InitPlan) but again it should not be that big cost.

I don't think we can assume that, no.

> How do measure  individual bind time cost (is the cost of only server side or it includes client bind or ..)?



view thread (43+ messages)  latest in thread

Message-ID: <51A8F1D7.2000109@agliodbs.com>
Permalink:  ../51A8F1D7.2000109@agliodbs.com/
Also on:    postgresql.org/message-id/51A8F1D7.2000109@agliodbs.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: josh@agliodbs.com, amit.kapila@huawei.com
  Subject: Re: Performance bug in prepared statement binding in 9.2?
  In-Reply-To: <51A8F1D7.2000109@agliodbs.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox