Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i8SHo-0000RT-1y for pgsql-admin@arkaria.postgresql.org; Thu, 12 Sep 2019 16:49:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1i8SGp-0000cN-05 for pgsql-admin@arkaria.postgresql.org; Thu, 12 Sep 2019 16:48:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i8SGo-0000cF-Mc for pgsql-admin@lists.postgresql.org; Thu, 12 Sep 2019 16:48:34 +0000 Received: from mail-ot1-x330.google.com ([2607:f8b0:4864:20::330]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1i8SGm-0007NT-9e for pgsql-admin@lists.postgresql.org; Thu, 12 Sep 2019 16:48:33 +0000 Received: by mail-ot1-x330.google.com with SMTP id z26so17461181oto.1 for ; Thu, 12 Sep 2019 09:48:32 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=sMN0HMetOcCwkVsTjm18f4mephPYnDMEA6AESutipUc=; b=OQgqdQ8Xm3FRbYESeDHRV3XoAB0+VuFHjIY5bhLW3FgY4Z1M27WNnJFIru21OuQHWW 91fT4lPaKd5q5zbRzQ6ou7/0Aofwv7Yd+hLve4dxydLaJBEKI83hGekw+3wOcPCtb9nA lJb0Qo/3VlmtHZRJpAXgzlQmFOjPlZEEi/G0dFZvLpXAMgr9AGECYOLXLtGbChAxphnO FkJyXbw7ydXUhwQTLFX8MtQ3p1BLuQ2y7bacWNuFc1Maw2rQw9PKdN+yIPyjLqyEDXGJ /0j5ZeQBIgfqxCVNvty5YvDKIYirRgCbFmImzYhQ0MYOQoeRScV2gVta7VrI7sz66orv 1fsA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=sMN0HMetOcCwkVsTjm18f4mephPYnDMEA6AESutipUc=; b=sS3RT9FISBJFtkfxYltrE+DsmpkIUcXbMQB16vXSS3mvdkoygj5DMOEVOiy33PT9Zi ZFFOd/jZlDw9Jq32pXrEBZBUgFPKDe9kexlRkR3UehQ2+o1mav8v7eiUjJNqkgu/L/2j H7Azwkkne+qRN+2j40d/R2aageBdori7JR5QZIfvJQh8hshMQJ7bTIYJPUrA3O3dBF7m so4Qa1yOwq/gRDIFs2TdIYrgf79s0iHXpqV5x3pte8HbMoC3ZKiBr6Z7D5AW2q5ylOV3 ijjw+a+8z10kFvoeTw6/GE2uwkddymhW9GoP91/CvXCtfIYL5PDMaL8EHGv+fkjUrfdY fDmw== X-Gm-Message-State: APjAAAWK3pfaFdFt4NA0vH3Ju6aeiq4MTSh9MVh1KOax9YrOuf77Yi4m NohzYODMm8afr9wfvcNRwNLcYXtkdc5bXA== X-Google-Smtp-Source: APXvYqyWF7YWOja57otSvkw3kuEYfuH4Vdbh4h+9NPD6HC+c3qdOEy0BkV3HlMYsh3KycmcLypOMUw== X-Received: by 2002:a9d:550c:: with SMTP id l12mr6371338oth.152.1568306910266; Thu, 12 Sep 2019 09:48:30 -0700 (PDT) Received: from [192.168.1.10] (ip70-186-126-197.no.no.cox.net. [70.186.126.197]) by smtp.googlemail.com with ESMTPSA id m20sm9283373otn.59.2019.09.12.09.48.29 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Thu, 12 Sep 2019 09:48:29 -0700 (PDT) Subject: Re: pgdump slowness To: pgsql-admin@lists.postgresql.org References: From: Ron Message-ID: Date: Thu, 12 Sep 2019 11:48:28 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.8.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------76FCBA54CC75BC9F79D25B21" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------76FCBA54CC75BC9F79D25B21 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit 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 > 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, > > 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. --------------76FCBA54CC75BC9F79D25B21 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit 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@gmail.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@gmail.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.
--------------76FCBA54CC75BC9F79D25B21--