Comment by porsager | Hacker News Reader

Top New Best Ask Show Jobs

Comment by porsager | Hacker News Reader

I was expecting to see https://github.com/dimitri/pgcopydb when clicking this. How is this different?

OP here. pgcopydb is also a great tool. It does pg_dump|pg_restore. It cannot multi-thread (parallelize) single table data migration

It only uses pg_dump and pg_restore for transfer of the schema, the actual data transfer is a custom mechanism.

seems like it can parallelize to an extent: https://pgcopydb.readthedocs.io/en/latest/concurrency.html#s...

does pgcopydb support copying a single table in multiple threads?

https://pgcopydb.readthedocs.io/en/latest/concurrency.html#s...

Because this is advertising :)

Reply on news.ycombinator.com