Re: pgdump slowness

Ron <ronljohnsonjr@xxxxxxxxx> · Thu, 12 Sep 2019 11:48:28 -0500



    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@xxxxxxxxx> 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@xxxxxxxxx>
              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.