Re: [HACKERS] An issue in remote query optimization

On 2017/01/31 18:24, Abbas Butt wrote:

Postgres_fdw optimizes remote queries by pushing down the where clause.
This feature does not work consistently when the query is executed from
within a pl/pgsql function. The optimization works when the function
executes the query for the first 5 times, and fails afterwards.

I understand that this is because PostgreSQL starts using generic plan
with pulled up where clause after the 5th invocation hoping that it
would be faster since we have skiped planning the query on each
invocation, but in this case this decision is causing the query to slow
down.

How should we fix this problem?

ANALYZE for the foreign table doesn't work?

Best regards,
Etsuro Fujita