Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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(-)

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group