[HN Gopher] Parallel Snapshotting: make pg_dump and pg_restore m...
___________________________________________________________________
Parallel Snapshotting: make pg_dump and pg_restore multi-threaded
per table
Author : spathak
Score : 40 points
Date : 2024-04-25 17:24 UTC (5 hours ago)
(HTM) web link (blog.peerdb.io)
(TXT) w3m dump (blog.peerdb.io)
| porsager wrote:
| I was expecting to see https://github.com/dimitri/pgcopydb when
| clicking this. How is this different?
| digger495 wrote:
| Because this is advertising :)
| joevandyk wrote:
| does pgcopydb support copying a single table in multiple
| threads?
| saisrirampur wrote:
| OP here. pgcopydb is also a great tool. It does
| pg_dump|pg_restore. It cannot multi-thread (parallelize) single
| table data migration
| fyrn_ wrote:
| It only uses pg_dump and pg_restore for transfer of the
| schema, the actual data transfer is a custom mechanism.
___________________________________________________________________
(page generated 2024-04-25 23:00 UTC)