Re: PG11 to PG14 Migration Slowness - Mailing list pgsql-hackers

From Aleksander Alekseev
Subject Re: PG11 to PG14 Migration Slowness
Date
Msg-id CAJ7c6TOcUc5s77iJbHTKK8+7z2_ce3wT8h8c_SN8Gcp5QyOTnQ@mail.gmail.com
Whole thread Raw
In response to PG11 to PG14 Migration Slowness  (Vigneshk Kvignesh <krrvignesh2@gmail.com>)
List pgsql-hackers
Hi Vigneshk,

>       I'm migrating  our existing PG instances from PG11.4  to PG14.3. I have around 5 Million Tables in a single
database.When migrating using pg_upgrade, its taking 3 hours for the process to complete. I'm not sure if its the
intendedbehaviour or we're missing something here. 

Thanks for reporting this. I would say this is more or less an
expected behaviour. This being said I think we could do better than
that.

Could you identify the bottleneck or perhaps provide the minimal
automated steps (ideally, a script) to reproduce your issue in a clean
environment?

--
Best regards,
Aleksander Alekseev



pgsql-hackers by date:

Previous
From: Nitin Jadhav
Date:
Subject: Fix GUC_NO_SHOW_ALL test scenario in 003_check_guc.pl
Next
From: Aleksander Alekseev
Date:
Subject: Re: No Callbacks on FATAL