Hi, 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.
Thanks and Regards, Vignesh K. On Thu, 12 Jan 2023 at 21:18, Tom Lane <t...@sss.pgh.pa.us> wrote: > Vigneshk Kvignesh <krrvigne...@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? > > regards, tom lane >
