Re: PostgreSQL optimizer use seq scan instead of pkey index only scan (in queries with postgres_fdw)
Jeff Janes <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.performance |
|---|---|
| Message-ID | <CAMkU=1xTHcVOpSZU2zbdUv32xwhNOdurQ5tjO9=GXPLmGheGew@mail.gmail.com> |
On Mon, May 6, 2019 at 10:44 AM Vitaly Baranovsky <[email protected]> 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 >