| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | pgsql-committers(at)postgresql(dot)org |
| Subject: | pgsql: In pg_upgrade, dump each database separately and use |
| Date: | 2012-11-30 21:30:17 |
| Message-ID: | E1TeYA5-0005Hl-Ug@gemulon.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
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.
Branch
------
master
Details
-------
http://git.postgresql.org/pg/commitdiff/12ee6ec71f8754ff3573711032b9b4d5a764ba84
Modified Files
--------------
contrib/pg_upgrade/check.c | 5 +--
contrib/pg_upgrade/dump.c | 101 ++++++++------------------------------
contrib/pg_upgrade/exec.c | 4 +-
contrib/pg_upgrade/pg_upgrade.c | 48 +++++++++++++++---
contrib/pg_upgrade/pg_upgrade.h | 9 ++--
contrib/pg_upgrade/relfilenode.c | 4 +-
contrib/pg_upgrade/util.c | 12 +++++
src/bin/pg_dump/pg_dumpall.c | 8 ++-
8 files changed, 85 insertions(+), 106 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2012-11-30 21:45:13 | pgsql: Split initdb.c main() code into multiple functions, for easier |
| Previous Message | Bruce Momjian | 2012-11-30 19:50:00 | pgsql: Move long_options structures to the top of main() functions, for |