## GPT (gptmailingli...@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.
