Thread

[WIP] Allow pg_upgrade to copy segments of the same relfilenode in parallel

Jaime Casanova <jcasanov@systemguards.com.ec> — 2022-02-02T02:57:00Z

Hi,

This patch adds a new option (-J num, --jobs-per-disk=num) in 
pg_upgrade to speed up copy mode. This generates upto ${num} 
processes per tablespace to copy segments of the same relfilenode 
in parallel.

This can help when you have many multi gigabyte tables (each segment 
is 1GB by default) in different tablespaces (each tablespace in a 
different disk) and multiple processors.

In a customer's database (~20Tb) it went down from 6h to 4h 45min.

It lacks documentation and I need help with WIN32 part of it, I created
this new mail to put the patch on the next commitfest.

Original thread: https://www.postgresql.org/message-id/flat/YZVbtHKYP02AZDIO%40ahch-to

-- 
Jaime Casanova
Director de Servicios Profesionales
SystemGuards - Consultores de PostgreSQL