In pg_upgrade, dump each database separately and use
Bruce Momjian <bruce@momjian.us>
In pg_upgrade, dump each database separately and use --single-transaction to restore each database schema. This yields performance improvements for databases with many tables. Also, remove split_old_dump() as it is no longer needed.
Files
| Path | Change | +/− |
|---|---|---|
| contrib/pg_upgrade/check.c | modified | +1 −4 |
| contrib/pg_upgrade/dump.c | modified | +20 −81 |
| contrib/pg_upgrade/exec.c | modified | +3 −1 |
| contrib/pg_upgrade/pg_upgrade.c | modified | +39 −9 |
| contrib/pg_upgrade/pg_upgrade.h | modified | +4 −5 |
| contrib/pg_upgrade/relfilenode.c | modified | +1 −3 |
| contrib/pg_upgrade/util.c | modified | +12 −0 |
| src/bin/pg_dump/pg_dumpall.c | modified | +5 −3 |