From: | Rene Romero Benavides <rene(dot)romero(dot)b(at)gmail(dot)com> |
---|---|
To: | rhys(dot)stewart(at)gmail(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Moving large table between servers: logical replication or postgres_fdw |
Date: | 2018-12-05 06:13:57 |
Message-ID: | CANaGW0-Nri3sdbbPvcKOTo8r2mHPKSF1MShgyL7MxY6HZqr9xA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)stewart(at)gmail(dot)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/
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2018-12-05 06:17:49 | Re: Moving large table between servers: logical replication or postgres_fdw |
Previous Message | Ron | 2018-12-05 06:13:50 | Re: Moving large table between servers: logical replication or postgres_fdw |