Re: Missed LIMIT clause pushdown in FDW API

Merlin Moncure <mmoncure@gmail.com> writes:
> On Wed, Mar 30, 2016 at 3:52 AM, Alexander Reshetov
> <alexander.v.reshetov@gmail.com> wrote:
>> As far as I know there is no LIMIT clause pushdown in FDW API.
>> Is there some reasons not to support LIMIT clause pushdown?

It was impossible to do it before 3fc6e2d7f5b652b4, committed 3 weeks
ago.  Now that that infrastructure exists, someone might look into
using it for this purpose ... but not before 9.7 at the earliest.

> Working for me on 9.5 with postgres_fdw...

Really?  It's true that postgres_fdw won't fetch more rows than it
actually needs from the remote --- but that's not the same as telling
the remote planner to prefer a fast-start plan.

            regards, tom lane