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@burggraben.net> wrote:
> ## 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.
>
>