Re: Migration from CentOS7 to RedHat 9

[Wasim Devale <wasimd60@xxxxxxxxx>]

Thanks it took 3 hours to complete the restoration. The existing CentOS7 resources were limited as you rightly said about CPU and all. Thanks

On Sun, 11 Aug, 2024, 12:06 am Ron Johnson, <ronljohnsonjr@xxxxxxxxx> wrote:

"RHEL9" has almost nothing to do with how fast it will restore.  It's all about how fast your disk are, number of CPUs, postgresql.conf settings.

And, of course, blobs are slow.

On Sat, Aug 10, 2024 at 9:26 AM Wasim Devale <wasimd60@xxxxxxxxx> wrote:

Yes, I used the same command I changed the values for this email. And that particular table with BLOBS took a longer time.

I am running a pg_restore now using -j 10 in the command. Please confirm, what you anticipate, will it take same time for restoration on Red Hat 9?

Thanks,
Wasim

On Sat, 10 Aug, 2024, 6:35 pm Ron Johnson, <ronljohnsonjr@xxxxxxxxx> wrote:

On Sat, Aug 10, 2024 at 7:14 AM Wasim Devale <wasimd60@xxxxxxxxx> wrote:

Hi All

I took dump via pg_dump doing ssh from Red hat it took almost 10 hours for 400GB data including 99GB of BLOBS large objects.

ssh postgres@ipaddre "pg_dump -U postgres -d DB1 F c -b -v" > /path/pg.dump

I see a typo.  Is this a copy/paste of what you ran?

Is this normal?

Maybe.  Blobs are slow.  I'd have done a multi-threaded pg_dump, though blobs might be the bottleneck.

--

Death to America, and butter sauce.

Iraq lobster!

--

Death to America, and butter sauce.

Iraq lobster!