pgdump slowness - Mailing list pgsql-admin

From Dhandapani Shanmugam
Subject pgdump slowness
Date
Msg-id CAAj4MFGc3voQYd850tRH5QeT=3MZ3tmz4QS2Riaz12cHU5RVWg@mail.gmail.com
Whole thread Raw
Responses Re: pgdump slowness  (Ron <ronljohnsonjr@gmail.com>)
Re: pgdump slowness  (nikhil raj <nikhilraj474@gmail.com>)
List pgsql-admin
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: Mariel Cherkassky
Date:
Subject: pg12 - foreign key to partitions
Next
From: nikhil raj
Date:
Subject: Re: pgdump slowness