public inbox for [email protected]help / color / mirror / Atom feed
Migration from CentOS7 to RedHat 9 6+ messages / 3 participants [nested] [flat]
* Migration from CentOS7 to RedHat 9 @ 2024-08-10 11:14 Wasim Devale <[email protected]> 2024-08-10 13:05 ` Re: Migration from CentOS7 to RedHat 9 Ron Johnson <[email protected]> 2024-08-12 05:47 ` Re: Migration from CentOS7 to RedHat 9 Muhammad Waqas <[email protected]> 0 siblings, 2 replies; 6+ messages in thread From: Wasim Devale @ 2024-08-10 11:14 UTC (permalink / raw) To: Pgsql-admin <[email protected]>; pgsql-admin 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 Is this normal? Thanks, Wasim ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Migration from CentOS7 to RedHat 9 2024-08-10 11:14 Migration from CentOS7 to RedHat 9 Wasim Devale <[email protected]> @ 2024-08-10 13:05 ` Ron Johnson <[email protected]> 2024-08-10 13:25 ` Re: Migration from CentOS7 to RedHat 9 Wasim Devale <[email protected]> 1 sibling, 1 reply; 6+ messages in thread From: Ron Johnson @ 2024-08-10 13:05 UTC (permalink / raw) To: pgsql-admin On Sat, Aug 10, 2024 at 7:14 AM Wasim Devale <[email protected]> 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! ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Migration from CentOS7 to RedHat 9 2024-08-10 11:14 Migration from CentOS7 to RedHat 9 Wasim Devale <[email protected]> 2024-08-10 13:05 ` Re: Migration from CentOS7 to RedHat 9 Ron Johnson <[email protected]> @ 2024-08-10 13:25 ` Wasim Devale <[email protected]> 2024-08-10 18:36 ` Re: Migration from CentOS7 to RedHat 9 Ron Johnson <[email protected]> 0 siblings, 1 reply; 6+ messages in thread From: Wasim Devale @ 2024-08-10 13:25 UTC (permalink / raw) To: Ron Johnson <[email protected]>; +Cc: pgsql-admin 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, <[email protected]> wrote: > On Sat, Aug 10, 2024 at 7:14 AM Wasim Devale <[email protected]> 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! > ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Migration from CentOS7 to RedHat 9 2024-08-10 11:14 Migration from CentOS7 to RedHat 9 Wasim Devale <[email protected]> 2024-08-10 13:05 ` Re: Migration from CentOS7 to RedHat 9 Ron Johnson <[email protected]> 2024-08-10 13:25 ` Re: Migration from CentOS7 to RedHat 9 Wasim Devale <[email protected]> @ 2024-08-10 18:36 ` Ron Johnson <[email protected]> 2024-08-11 05:21 ` Re: Migration from CentOS7 to RedHat 9 Wasim Devale <[email protected]> 0 siblings, 1 reply; 6+ messages in thread From: Ron Johnson @ 2024-08-10 18:36 UTC (permalink / raw) To: pgsql-admin "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 <[email protected]> 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, <[email protected]> > wrote: > >> On Sat, Aug 10, 2024 at 7:14 AM Wasim Devale <[email protected]> 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! ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Migration from CentOS7 to RedHat 9 2024-08-10 11:14 Migration from CentOS7 to RedHat 9 Wasim Devale <[email protected]> 2024-08-10 13:05 ` Re: Migration from CentOS7 to RedHat 9 Ron Johnson <[email protected]> 2024-08-10 13:25 ` Re: Migration from CentOS7 to RedHat 9 Wasim Devale <[email protected]> 2024-08-10 18:36 ` Re: Migration from CentOS7 to RedHat 9 Ron Johnson <[email protected]> @ 2024-08-11 05:21 ` Wasim Devale <[email protected]> 0 siblings, 0 replies; 6+ messages in thread From: Wasim Devale @ 2024-08-11 05:21 UTC (permalink / raw) To: Ron Johnson <[email protected]>; +Cc: pgsql-admin 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, <[email protected]> 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 <[email protected]> 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, <[email protected]> >> wrote: >> >>> On Sat, Aug 10, 2024 at 7:14 AM Wasim Devale <[email protected]> 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! > ^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Migration from CentOS7 to RedHat 9 2024-08-10 11:14 Migration from CentOS7 to RedHat 9 Wasim Devale <[email protected]> @ 2024-08-12 05:47 ` Muhammad Waqas <[email protected]> 1 sibling, 0 replies; 6+ messages in thread From: Muhammad Waqas @ 2024-08-12 05:47 UTC (permalink / raw) To: Wasim Devale <[email protected]>; +Cc: Pgsql-admin <[email protected]>; pgsql-admin what is the bandwidth between source and destination? what is the memory of your source server? 2024년 8월 10일 (토) 오후 4:14, Wasim Devale <[email protected]>님이 작성: > 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 > > Is this normal? > > Thanks, > Wasim > -- *Muhammad Waqas* *Senior Technical Support Engineer - Tech Support Center (Karachi)* Mobile: +92-322-2844150 Email: *[email protected] <[email protected]>* 1st floor, suit no F-04, COLABS Karachi, 8-C Khayaban-e-Tanzeem, DHA Phase 5 Tauheed Commercial Area, Defense V Defense Housing Authority, Karachi, Karachi City, Sindh, 75500 Pakistan. ^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2024-08-12 05:47 UTC | newest] Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-08-10 11:14 Migration from CentOS7 to RedHat 9 Wasim Devale <[email protected]> 2024-08-10 13:05 ` Ron Johnson <[email protected]> 2024-08-10 13:25 ` Wasim Devale <[email protected]> 2024-08-10 18:36 ` Ron Johnson <[email protected]> 2024-08-11 05:21 ` Wasim Devale <[email protected]> 2024-08-12 05:47 ` Muhammad Waqas <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox