On 12/05/2018 12:05 AM, Rob Sargent wrote:
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.
Can’t help but think an unread unwritten table goes to quietly to /dev/null :)
Sigh, no.
The legal and audit teams, and the customer, would be most upset if the data
you're legally obligated to keep for 7 years suddenly disappears.
--
Angular momentum makes the world go 'round.
