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!