From: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Migration from CentOS7 to RedHat 9 |
Date: | 2024-08-10 18:36:25 |
Message-ID: | CANzqJaBoUmoYyN=Okvb9sL0jBSMhn4imAUQ2DEM1z22e3HHLqg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 <wasimd60(at)gmail(dot)com> 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(at)gmail(dot)com>
> wrote:
>
>> On Sat, Aug 10, 2024 at 7:14 AM Wasim Devale <wasimd60(at)gmail(dot)com> 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(at)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!
From | Date | Subject | |
---|---|---|---|
Next Message | Wasim Devale | 2024-08-11 05:21:34 | Re: Migration from CentOS7 to RedHat 9 |
Previous Message | Motog Plus | 2024-08-10 14:21:12 | Re: Seeking Guidance on Upgrading from PostgreSQL 12 to 1 |