Sorry for the delayed response. We have an fdw extension, we started code changes in the extension for PGv14 on 14.3, we just completed code changes, testing and benchmarking. We'll retarget to 14.6
Also we'll take a look at the changes for pg_dump in v15 . Thanks for the advice.
Vigneshk Kvignesh <krrvignesh2@gmail.com> writes: > 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.
There was some work done in v15 to make pg_dump deal better with zillions of tables. Don't know if you can consider retargeting to v15, or how much the speedups would help in your particular situation.
Why are you using 14.3, when the current release is 14.6?