Re: PG11 to PG14 Migration Slowness

2023-01-27 Thread Vigneshk Kvignesh
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

Re: PG11 to PG14 Migration Slowness

2023-01-13 Thread Aleksander Alekseev
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

Re: PG11 to PG14 Migration Slowness

2023-01-12 Thread Tom Lane
Vigneshk Kvignesh 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

Re: PG11 to PG14 Migration Slowness

2023-01-12 Thread Ilya Anfimov
On Thu, Jan 12, 2023 at 02:45:41PM +0530, Vigneshk Kvignesh wrote: >Hi, > > 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

PG11 to PG14 Migration Slowness

2023-01-12 Thread Vigneshk Kvignesh
Hi, 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. Most of