apgdiff icon indicating copy to clipboard operation
apgdiff copied to clipboard

apgdiff hangs with big dump with data

Open kripper opened this issue 4 years ago • 0 comments

When trying to get a diff between a big dump with data and a dump of schema only, the command hangs using 100% cpu. When comparing only schema dumps it works fine, so it seems like apgdiff is very inefficient in parsing the schema info from the dump.

The data dump is 33 GB. The schema only dump is 68 K.

It let it running for 20 hours and had to cancel the process with no results. Backing up and restoring is way faster.

kripper avatar Oct 20 '19 21:10 kripper