Re: what is the best way to access cold data on another server?

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: what is the best way to access cold data on another server?
Дата
Msg-id CAMkU=1wkqYx8DhhovYECyBE-ZtPfBPyekX_vd=XciT_qp__uAA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: what is the best way to access cold data on another server?  (Holger Jakobs <holger@jakobs.com>)
Список 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 по дате отправления:

Предыдущее
От: Wim Bertels
Дата:
Сообщение: Re: viewing connectioninfo used by subscriber on the publicationserver when inactive
Следующее
От: Ankush Chawla
Дата:
Сообщение: Postgres Upgrades could not open version file PG_VERSIOn