On Wed, May 13, 2020 at 3:24 AM Holger Jakobs <holger@xxxxxxxxxx> wrote:
dblink is outdated, postgres_fdw is current.
dblink may not be getting lots of improvements, but it is maintained to the same standards as postgres_fdw is. FDW inhibits parallel queries, on both sides. dblink maintains that possibility, (while tedious to do in a useful way). Also, FDW cannot push UDF calls, while dblink can if you manually write them into the sent query.
Cheers,
Jeff