I can confirm, when I call ps.setPrepareThreshold(1) the query is slow immediately, so the plan must be different with the server prepared statements.
Thanks, Rob On Sun, Jun 26, 2011 at 5:11 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > David Johnston <pol...@yahoo.com> writes: >> This is likely the case where the first few "prepared statements" are >> not truly prepared. Once you hit five the cache kicks in and computes >> a generic query plan to cache. > > Not so much that as that JDBC decides that it should tell the backend to > start using a prepared plan. See the JDBC docs. > > regards, tom lane > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
