Re: pgdump slowness

nikhil raj <[email protected]>
Newsgroups gmane.comp.db.postgresql.admin
Message-ID <CAG1ps1yyxE9YfYsODe0oYCJ0Ovxmk=30Oeug=TL7vbGscRvw4A@mail.gmail.com> 
Hi Dhandapani,

That is the system  configuration and version  and how many parallel job
you are running in the command.

Please let know the details.

On Thu, 12 Sep 2019, 9:05 pm Dhandapani Shanmugam, <[email protected]>
wrote:

> Hi Guys,
>
> We are having wired issue. pg_dump taking more time to backup 320 GB of
> table,the table has bytea data type with TOAST table associated it. Please
> let me know, if this is the expected behavior of pg_dump or do i need to
> tune any of the parameters.  I tried to run pg_dump with parallel -j option
> , still no improvement and there is no lock on the table as well. any
> inputs are welcome
>
> -D
>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.