Learn how to make pg_dump and pg_restore faster using the concept of Parallel Snapshotting. PeerDB's implementation of Parallel Snapshotting enables faster migrations from one Postgres database to another, reducing downtime. Migrating a 1.5TB table took only 7 hours with Parallel Snapshotting, compared to 1.5 days with pg_dump and pg_restore.
Table of contents
Permalink A quick primer on pg_dump and pg_restorePermalink Parallel Snapshotting to make pg_dump & pg_restore multi-threaded per tablePermalink Conclusion and ReferencesSort: