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.
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.