pgsql: During pg_upgrade, conditionally skip transfer of FSMs.

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

pgsql: During pg_upgrade, conditionally skip transfer of FSMs.

Amit Kapila-3
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(-)