On Mon, May 6, 2019 at 10:44 AM Vitaly Baranovsky <barvetalforums(at)gmail(dot)com>
wrote:
> Hello all,
>
> I faced strange behavior of PostgreSQL during the query execution.
>
...
> Also, please, note, that SQL without WHERE clause has been set to the
> foreign server:
> " Remote SQL: SELECT primary_uuid FROM public.foreign_table"
>
> So, the optimizer doesn't select optimal plans for such executions :(
>
It works the way you want in version 12, which is currently under
development and should be released in 5 months or so.
Cheers,
Jeff
>