On Tue, Sep 18, 2018 at 7:50 PM, Jinhua Luo <luajit...@gmail.com> wrote: > I was testing PG10. > > Sorry, the example is not so proper. I just think even if it's a > simple example, e.g. join two co-located tables, the planner should > work out to push down it. Can you confirm the postgresql could detect > co-located tables on the same foreign server and push down queries on > them? Could you give an actual example or point out the relevant > source code paths for reference? >
You can check "postgresGetForeignJoinPaths" function or you can refer commit "e4106b2528727c4b48639c0e12bf2f70a766b910". -- Regards, Dilip Kumar EnterpriseDB: http://www.enterprisedb.com
