## GPT (gptmailinglists@gmail.com):
> So, this kind of switch after a few goes is a normal behavior or
> something unexpected which will change in future?
It's expected, and even documented (when you look at the user-level
interface):
https://www.postgresql.org/docs/current/static/sql-prepare.html
Prepared statements can use generic plans rather than re-planning
with each set of supplied EXECUTE values. This occurs immediately
for prepared statements with no parameters; otherwise it occurs
only after five or more executions produce plans whose estimated
cost average (including planning overhead) is more expensive than
the generic plan cost estimate.
Regards,
Christoph
--
Spare Space.