| From: | nikhil raj <nikhilraj474(at)gmail(dot)com> |
|---|---|
| To: | Dhandapani Shanmugam <postgresql95(at)gmail(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: pgdump slowness |
| Date: | 2019-09-12 15:51:58 |
| Message-ID: | CAG1ps1yyxE9YfYsODe0oYCJ0Ovxmk=30Oeug=TL7vbGscRvw4A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(at)gmail(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2019-09-12 15:52:48 | Re: pgdump slowness |
| Previous Message | Dhandapani Shanmugam | 2019-09-12 15:35:42 | pgdump slowness |