Joshua D. Drake wrote: > We just queue/audit the changes as they happen and sync up the changes > after the initial sync completes.
This already happens. There is an initial sync, and there's logical decoding that queues any changes that exist "after" the sync's snapshot. What you seem to want is to have multiple processes doing the initial COPY in parallel -- each doing one fraction of the table. Of course, they would have to use the same snapshot. That would make sense only if the COPY itself is the bottleneck and not the network, or the I/O speed of the origin server. This doesn't sound a common scenario to me. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
