Re: Reusing cached prepared statement slow after 5 executions - Mailing list pgsql-general

From Tom Lane
Subject Re: Reusing cached prepared statement slow after 5 executions
Date
Msg-id 11490.1309101104@sss.pgh.pa.us
Whole thread Raw
In response to Re: Reusing cached prepared statement slow after 5 executions  (David Johnston <polobo@yahoo.com>)
Responses Re: Reusing cached prepared statement slow after 5 executions
List pgsql-general
David Johnston <polobo@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

pgsql-general by date:

Previous
From: David Johnston
Date:
Subject: Re: Reusing cached prepared statement slow after 5 executions
Next
From: Stephen Frost
Date:
Subject: Re: An amusing MySQL weakness--not!