| From: | Aleksander Alekseev <aleksander(at)timescale(dot)com> |
|---|---|
| To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Cc: | Vigneshk Kvignesh <krrvignesh2(at)gmail(dot)com> |
| Subject: | Re: PG11 to PG14 Migration Slowness |
| Date: | 2023-01-13 13:02:00 |
| Message-ID: | CAJ7c6TOcUc5s77iJbHTKK8+7z2_ce3wT8h8c_SN8Gcp5QyOTnQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 intended behaviour 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Aleksander Alekseev | 2023-01-13 13:14:11 | Re: No Callbacks on FATAL |
| Previous Message | Nitin Jadhav | 2023-01-13 12:45:38 | Fix GUC_NO_SHOW_ALL test scenario in 003_check_guc.pl |