Postgres Pro
Downloads
Home   >   mailing lists

pgsql: In pg_upgrade, remove functions that did sequential array scans - Mailing list pgsql-committers

From Bruce Momjian
Subject pgsql: In pg_upgrade, remove functions that did sequential array scans
Date
Msg-id E1Pbdn3-0005QB-Bt@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
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(-)

pgsql-committers by date:

Previous
From: Bruce Momjian
Date:
Subject: pgsql: In pg_upgrade, clarify use of install_db_support_functions().
Next
From: Tom Lane
Date:
Subject: pgsql: Refactor GIN's handling of duplicate search entries.