> 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 ..)? >From the PostgreSQL activity log. BIND gets logged separately. -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
