> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
