pgsql: In pg_upgrade, remove functions that did sequential array scans

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: In pg_upgrade, remove functions that did sequential array scans
Date: 2011-01-08 18:45:25
Message-ID: E1Pbdn3-0005QB-Bt@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

In pg_upgrade, remove functions that did sequential array scans looking
up relations, but rather order old/new relations and use the same array
index value for both. This should speed up pg_upgrade for databases
with many relations.

Branch
------
master

Details
-------
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=002c105a0706bd1c1e939fe0f47ecdceeae6c52d

Modified Files
--------------
contrib/pg_upgrade/function.c | 6 +-
contrib/pg_upgrade/info.c | 106 +++++---------------------------------
contrib/pg_upgrade/pg_upgrade.c | 9 ++--
contrib/pg_upgrade/pg_upgrade.h | 8 +--
contrib/pg_upgrade/relfilenode.c | 17 ++++--
5 files changed, 37 insertions(+), 109 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2011-01-08 19:48:48 pgsql: Refactor GIN's handling of duplicate search entries.
Previous Message Bruce Momjian 2011-01-08 14:12:24 pgsql: In pg_upgrade, clarify use of install_db_support_functions().