Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nHQ8m-00066f-DL for pgsql-admin@arkaria.postgresql.org; Tue, 08 Feb 2022 13:02:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nHQ8l-0008Mq-83 for pgsql-admin@arkaria.postgresql.org; Tue, 08 Feb 2022 13:02:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nHQ8k-0008Mh-RS for pgsql-admin@lists.postgresql.org; Tue, 08 Feb 2022 13:02:38 +0000 Received: from mail-pj1-x102a.google.com ([2607:f8b0:4864:20::102a]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nHQ8e-00006s-R4 for pgsql-admin@lists.postgresql.org; Tue, 08 Feb 2022 13:02:38 +0000 Received: by mail-pj1-x102a.google.com with SMTP id c5-20020a17090a1d0500b001b904a7046dso463037pjd.1 for ; Tue, 08 Feb 2022 05:02:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to; bh=kY3/G8DzznGy1R2UawlI06f04A1/+swwBh/yTaDeAOU=; b=JQOK6RknIfzwLIV5KyuY2rDqsXksNosgG7O1ZwAVmvvTCpnmH0RnN3s24hN0qCIxum D+PZqfauudnnRnqh783/B/L7Jv0BrrNBkpv82QY0Fv/j69/U3nWz9vdMVn2cQwKqHfc0 rZt1QpRX0dTQZTeSjhE0e3vMvHsmYLcHj2dlzcTPIZ/CrSPjIyWI/G8GRDVc2sO31zks MtRAMkUIg6XSnjuFfMSkSvOjbZYWzmI2932e/Ph4wRVg3zeajodFXxr33C0wFSNYKfKx Gj+gAxpgHjzGkw+dFrO8nf/j5PJFwMp4rsCjWR0CTnC9RwdDW5FxXhb8wN0x4xHIoVZS TKbQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to; bh=kY3/G8DzznGy1R2UawlI06f04A1/+swwBh/yTaDeAOU=; b=Ll0BMfpMPp8dV7+54gBpkJrzVDR80A90vIyVji0gARvOF5XcV6Zl+WO1kDET3+6ArA vmtO/ov7wEZJODqmpASJ7xBYUdj+U1upT5fGQkuQV9MN7FoNdTeiA40m9usAyqekU11S hHnnPDOaBXJnq5IIv2gMhOjqudCXQZFbQz/5LF9Z4/3y+CvE6RmnOBqVXCpVCPCEZP36 YPeD3Es+OqUvhwv/PI/QV+dIYBL1HnJEya2N1zidMLu5iaeErhe4XmmKqOasgmqrE/n4 yNf9TzwLhavLnjWGPB0IYCZ4ja42wX78DvYjuD2UH6uZppHamH79p6NPO97eDwAcfNNs oYQw== X-Gm-Message-State: AOAM532IEEbbZaEUxqZejM+cbdNGOgAmwsE1rgvOByiBV+uk6ZyJ03TB fWE/UaVLlJwiW4Qre3z5A6Q= X-Google-Smtp-Source: ABdhPJwMqALT4FVxsb5rBFaEnZT3QwFU/tjK7IfxbjsfNQ8/bk/vG5dsdrA71WKgzfGjQvtX2PudpQ== X-Received: by 2002:a17:90b:4d05:: with SMTP id mw5mr1249981pjb.218.1644325350157; Tue, 08 Feb 2022 05:02:30 -0800 (PST) Received: from jrouhaud (2001-b011-1005-1017-e46d-c4cf-ba2a-3e05.dynamic-ip6.hinet.net. [2001:b011:1005:1017:e46d:c4cf:ba2a:3e05]) by smtp.gmail.com with ESMTPSA id d10sm15869824pfl.16.2022.02.08.05.02.29 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 08 Feb 2022 05:02:29 -0800 (PST) Date: Tue, 8 Feb 2022 21:02:25 +0800 From: Julien Rouhaud To: Ram Pratap Maurya Cc: "'pgsql-admin@lists.postgresql.org'" , Ashish Chugh Subject: Re: PG_Base Backup take 8 to 9Hrs Message-ID: <20220208130225.kbecwy3oxvfi6iuk@jrouhaud> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, Please don't try to recall messages sent on a mailing list. That won't work and will spam everyone. On Tue, Feb 08, 2022 at 11:36:19AM +0000, Ram Pratap Maurya wrote: > > We are using Postgres -11 version and current PG DB size is 450 GB . > > Archive log enable in Database and we are running Full PG_Base backup and it > will take 8 to 9 Hrs to complete the backup , > > Please suggest how to reduce the full DB backup time. That's ~16MB/s, so many times slower than a single old 7200RPM drive. The problem is likely not with postgres, you should get a better storage or a better network.