Re: Moving large table between servers: logical replication or postgres_fdw

Поиск
Список
Период
Сортировка
От Rene Romero Benavides
Тема Re: Moving large table between servers: logical replication or postgres_fdw
Дата
Msg-id CANaGW0-Nri3sdbbPvcKOTo8r2mHPKSF1MShgyL7MxY6HZqr9xA@mail.gmail.com
обсуждение исходный текст
Ответ на Moving large table between servers: logical replication or postgres_fdw  ("Rhys A.D. Stewart" <rhys.stewart@gmail.com>)
Ответы Re: Moving large table between servers: logical replication orpostgres_fdw
Re: Moving large table between servers: logical replication or postgres_fdw
Список pgsql-general
Дерево обсуждения
I tend to believe that a backup (pg_dump) in custom format (-F c) using multiple jobs (parallel) -> restore (pg_restore) also with multiple concurrent jobs would be better.

Am Di., 4. Dez. 2018 um 21:14 Uhr schrieb Rhys A.D. Stewart <rhys.stewart@gmail.com>:
Greetings Folks,

I have a relatively large table (100m rows) that I want to move to a
new box with more resources. The table isn't doing anything...i.e its
not being updated or read from. Which approach would be faster to move
the data over:

  a). Use pg_fdw and do "create local_table as select * from foreign_table".
  b). setup logical replication between the two servers.

Regards,

Rhys
Peace & Love|Live Long & Prosper



--
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/

В списке pgsql-general по дате отправления:

Предыдущее
От: Ron
Дата:
Сообщение: Re: Moving large table between servers: logical replication orpostgres_fdw
Следующее
От: Ron
Дата:
Сообщение: Re: Moving large table between servers: logical replication orpostgres_fdw