I have searched in https://github.com/nahanni/rw_redis_fdw/blob/master/redis_fdw.c for PREPARE and EXECUTE keywords. There are not any of them, except in comments. So, the developer doesn´t use any PREPARE, EXECUTE statements. So, this change occurs internally. If I am correct then the PG fails to respond properly. Tia On 10/25/18, Christoph Moench-Tegeder <cmt@xxxxxxxxxxxxxx> wrote: > ## GPT (gptmailinglists@xxxxxxxxx): > >> 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. > >
