Re: [HACKERS] An issue in remote query optimization

On 2017/01/31 19:53, Abbas Butt wrote:
> On Tue, Jan 31, 2017 at 2:25 AM, Etsuro Fujita
> <fujita.etsuro@lab.ntt.co.jp <mailto:fujita.etsuro@lab.ntt.co.jp>> wrote:
>     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?

> No.
>
> analyze ts.tickets;
> WARNING:  skipping "tickets" --- cannot analyze this foreign table
> ANALYZE

How the foreign table ts.tickets is defined?

Best regards,
Etsuro Fujita