Re: PostgreSQL optimizer use seq scan instead of pkey index only scan (in queries with postgres_fdw)

[Jeff Janes <jeff.janes@xxxxxxxxx>]

On Mon, May 6, 2019 at 10:44 AM Vitaly Baranovsky <barvetalforums@xxxxxxxxx> 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