Re: Migration from CentOS7 to RedHat 9

[Ron Johnson <ronljohnsonjr@xxxxxxxxx>]

"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!