Postgres Pro
Downloads
Home   >   mailing lists

Re: pgdump slowness - Mailing list pgsql-admin

From nikhil raj
Subject Re: pgdump slowness
Date
Msg-id CAG1ps1yyxE9YfYsODe0oYCJ0Ovxmk=30Oeug=TL7vbGscRvw4A@mail.gmail.com
Whole thread Raw
In response to pgdump slowness  (Dhandapani Shanmugam <postgresql95@gmail.com>)
Responses Re: pgdump slowness  (Dhandapani Shanmugam <postgresql95@gmail.com>)
List pgsql-admin
Tree view
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, <postgresql95@gmail.com> 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

pgsql-admin by date:

Previous
From: Dhandapani Shanmugam
Date:
Subject: pgdump slowness
Next
From: Ron
Date:
Subject: Re: pgdump slowness