pgsql: During pg_upgrade, conditionally skip transfer of FSMs.

From: Amit Kapila <akapila(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: During pg_upgrade, conditionally skip transfer of FSMs.
Date: 2019-03-15 03:02:17
Message-ID: E1h4d6v-0000MY-5Y@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

During pg_upgrade, conditionally skip transfer of FSMs.

If a heap on the old cluster has 4 pages or fewer, and the old cluster
was PG v11 or earlier, don't copy or link the FSM. This will shrink
space usage for installations with large numbers of small tables.

This will allow pg_upgrade to take advantage of commit b0eaa4c51b where
we have avoided creation of the free space map for small heap relations.

Author: John Naylor
Reviewed-by: Amit Kapila
Discussion: https://postgr.es/m/CACPNZCu4cOdm3uGnNEGXivy7Gz8UWyQjynDpdkPGabQ18_zK6g%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/13e8643bfc29d3c1455c0946281cdfc24758ffb6

Modified Files
--------------
doc/src/sgml/ref/pgupgrade.sgml | 7 +++++
src/bin/pg_upgrade/info.c | 16 ++++++++--
src/bin/pg_upgrade/pg_upgrade.h | 6 ++++
src/bin/pg_upgrade/relfilenode.c | 63 +++++++++++++++++++++++++++++++++++++++-
4 files changed, 89 insertions(+), 3 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Thomas Munro 2019-03-15 04:49:49 pgsql: Enable parallel query with SERIALIZABLE isolation.
Previous Message Michael Paquier 2019-03-15 00:54:40 Re: pgsql: Fix thinko when bumping on temporary directories in pg_verify_ch