pgsql: During pg_upgrade, conditionally skip transfer of FSMs.

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема pgsql: During pg_upgrade, conditionally skip transfer of FSMs.
Дата
Msg-id E1h4d6v-0000MY-5Y@gemulon.postgresql.org
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: pgsql: Fix thinko when bumping on temporary directories inpg_verify_ch
Следующее
От: Thomas Munro
Дата:
Сообщение: pgsql: Enable parallel query with SERIALIZABLE isolation.