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 <[email protected] 
> <mailto:[email protected]>> 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,
>     <[email protected] <mailto:[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
>

-- 
Angular momentum makes the world go 'round.