Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tvEcJ-002dY7-Si for pgsql-general@arkaria.postgresql.org; Thu, 20 Mar 2025 12:03:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tvEcI-0005UU-Kt for pgsql-general@arkaria.postgresql.org; Thu, 20 Mar 2025 12:03:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tvEYu-0000jc-Sl for pgsql-general@lists.postgresql.org; Thu, 20 Mar 2025 11:59:48 +0000 Received: from mail-ed1-x52e.google.com ([2a00:1450:4864:20::52e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tvEYs-0007vP-2K for pgsql-general@lists.postgresql.org; Thu, 20 Mar 2025 11:59:48 +0000 Received: by mail-ed1-x52e.google.com with SMTP id 4fb4d7f45d1cf-5e5c7d6b96fso1282445a12.3 for ; Thu, 20 Mar 2025 04:59:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1742471985; x=1743076785; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=ELF/lFVQoYaMHR6O+8lbn81jK8W1T1sdeF0iUy1f+wU=; b=olXgWFHmbx2c7M4Epeq/hdjqslgiupj4oLgTG1Bq+2zS9nryPUuW52Dipteoo/L+LL 9WX15/7syez7U7Z7Ohj3zW8hVtY2iEeeoCPvRERG0acRT7coE3XRimXbQTO/9E9Hx9/i gxfPBfZrK/JR6czln/m0+4pFGZ4GtmFzFGgYgiWSW3LXGXoWmVpArQquSybspnHFzrNR TG+4nR/LZ1IQeJaMPjbeg0kHgTQjNPdAdpPVC7H+LOHYVB54DJvWvEj6L+R+xQOuvLOa BzaJHp6tv5HXAzv2qYZ4OtnrEkfkQl01nKx8O93BJ8oyGUBrNNHX2yGSyA+E74Cugu8D PaUg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742471985; x=1743076785; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=ELF/lFVQoYaMHR6O+8lbn81jK8W1T1sdeF0iUy1f+wU=; b=ZETWS+0wuA53qNYN6xWvCKTtgAWmUWJ7URQ90a/pPmqHMHpYwnoSPEE8PN+9BLvYEv YnUd2UyMjaCgxYekV+f/Vc7YCX08IrsIMpcTp4356m6dwkb+z9hwL7o7Rn+kBFNiFWXb Xl9cd/G35GJcGlHB8DQglUeUdp3p2nCV/gTqzbCcWNqgYH5PcSJMPnl8uQOQ1tuCBxx8 Km6A13tiRFN+3ezp9OAgASQji2xK2GvyR40+chDg6g7JGWjgtCiDIEB6HCcdVEJUV8/t nDaf3dZMph1/wBava82waCN4rS9PDOAKSR/8LsrbfLUrivbcWdoIEdtaNtPYr/9CWctn 5ARQ== X-Forwarded-Encrypted: i=1; AJvYcCXm5y8xKTem2oR/bSOLfnorlYS4u9k8T9hLaVX56kONCPJ2jct9LOGBs7E3/4uPCcl1LsHRDqukZfK4t5Ci@lists.postgresql.org X-Gm-Message-State: AOJu0YysnYUVdhnmjc3vY+KTBNCDcH67OJ1DYMCLwZCYP/e0pvep1Uwl UsmMi15cg2cBHa4L4MhkQX6NbQAef8wJXHAZxTqczkdhWRyuS4653CsIZIzyZTKjQNlo/3nJdD9 K X-Gm-Gg: ASbGnctCoo6utJ/g/mpVPKS0miJ+oKw/xg0AUPb/LHqfyJdT39/jHxy0aCfd2dg5H2+ drN2OuogXtUJ/L027vVB7ZV3dhOBzdaA5wRSHhC4tqQooQS4Skum5Du+fhOjJyy1F5BAc2I2Ovs NeVSmvNRV5quwlrKXnfNKZ7XnkmPmwcHKkYIaSAgiFuHsdzY9TbLJGGvyr2cJBTQiO4LQA5n5Nx dxmFDsBnh9eYoEcKD7y9W3c/C95xZ6hAnaMorRnoWbTWgMipQMpQ3lanrv+lL9E7m1HQqixPFym 1vD7baJY6PQbu9XL2JvaqkAszFpWL9/MqRbuc91OXq8ggwb3EggiM2y5rdKLiDc= X-Google-Smtp-Source: AGHT+IHg/L4eO2AXaQevNg4a3498ammcbkROhXvkujNaFMTuRxJ4DeY7HUqOErO29yamhjD7P+tCBg== X-Received: by 2002:a17:907:940e:b0:ac3:26ff:11a0 with SMTP id a640c23a62f3a-ac3ce14c654mr278879066b.38.1742471985291; Thu, 20 Mar 2025 04:59:45 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:4a1:e980:793b:ea4c:4c10]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-ac3dd62bc4asm75116066b.88.2025.03.20.04.59.44 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 20 Mar 2025 04:59:44 -0700 (PDT) Message-ID: Subject: Re: Export operation efficiency in read replica From: Laurenz Albe To: Siraj G , pgsql-general@lists.postgresql.org Date: Thu, 20 Mar 2025 12:59:44 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2025-03-20 at 17:22 +0530, Siraj G wrote: > I have a DB with 1TB in size serving needs of one of our critical > applications. I have a requirement to take export of the DB on a > daily basis, but want to carry out this operation in read replica. > The postgresql version is:=C2=A016.6 >=20 > What would be the RPO of such backup? Depends on the speed of disk and network and on what an RPO is. > What would be the impact on the READ REPLICA with a long running > export operation? Potentially severe. You could look into storage technologies that allow you to take a snapshot and clone it. Yours, Laurenz Albe