Merlin Moncure <mmoncure@xxxxxxxxx> writes: > On Wed, Mar 30, 2016 at 3:52 AM, Alexander Reshetov > <alexander.v.reshetov@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
