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

Ron <ronljohnsonjr@xxxxxxxxx> · Wed, 5 Dec 2018 00:23:04 -0600



    pg_backup/pg_restore will work, but parallel is pointless on a
    single (unpartitioned) table.

    
    On 12/05/2018 12:13 AM, Rene Romero
      Benavides wrote:

    
      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@xxxxxxxxx>:

        
        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

          
    -- 

      Angular momentum makes the world go 'round.