Re: pgdump slowness

IO load?  Slow disks, low channel bandwidth, etc?

Is this a VM on an over-subscribed host?

On 9/12/19 10:54 AM, Dhandapani Shanmugam wrote:
> Hi Nikhil,
>
> I don't see any resource issues on server. the cpu shows 90% idle and the
> load of the server is very normal. I am using 6 parallel process.
>
> -D
>
> On Thu, Sep 12, 2019 at 9:22 PM nikhil raj <nikhilraj474(at)gmail(dot)com
> <mailto:nikhilraj474(at)gmail(dot)com>> wrote:
>
> 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 <mailto: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
>

--
Angular momentum makes the world go 'round.