Re: what is the best way to access cold data on another server? - Mailing list pgsql-admin

From Jeff Janes
Subject Re: what is the best way to access cold data on another server?
Date
Msg-id CAMkU=1wkqYx8DhhovYECyBE-ZtPfBPyekX_vd=XciT_qp__uAA@mail.gmail.com
Whole thread Raw
In response to Re: what is the best way to access cold data on another server?  (Holger Jakobs <holger@jakobs.com>)
List pgsql-admin
On Wed, May 13, 2020 at 3:24 AM Holger Jakobs <holger@jakobs.com> 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

pgsql-admin by date:

Previous
From: Wim Bertels
Date:
Subject: Re: viewing connectioninfo used by subscriber on the publicationserver when inactive
Next
From: Ankush Chawla
Date:
Subject: Postgres Upgrades could not open version file PG_VERSIOn