> On Dec 4, 2018, at 8:14 PM, Rhys A.D. Stewart <rhys.stewart@xxxxxxxxx> wrote: > > 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 > Can’t help but think an unread unwritten table goes to quietly to /dev/null :)
