pgsql: During pg_upgrade, conditionally skip transfer of FSMs. - Mailing list pgsql-committers

From Amit Kapila
Subject pgsql: During pg_upgrade, conditionally skip transfer of FSMs.
Date
Msg-id E1h4d6v-0000MY-5Y@gemulon.postgresql.org
Whole thread Raw
List 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(-)


pgsql-committers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: pgsql: Fix thinko when bumping on temporary directories inpg_verify_ch
Next
From: Thomas Munro
Date:
Subject: pgsql: Enable parallel query with SERIALIZABLE isolation.