Re: Export operation efficiency in read replica

2025-04-05 Thread Adrian Klaver
On 3/20/25 05:58, Siraj G wrote: Hello Laurenz As per my understanding coming to a proper conclusion wrt RPO You still have not defined what RPO is. -- Adrian Klaver adrian.kla...@aklaver.com

Re: Export operation efficiency in read replica

2025-03-21 Thread Siraj G
Thank you everyone! On Fri, Mar 21, 2025 at 7:23 PM Guillaume Lelarge < guillaume.lela...@dalibo.com> wrote: > On 20/03/2025 15:04, Adrian Klaver wrote: > > On 3/20/25 05:58, Siraj G wrote: > >> Hello Laurenz > >> > >> As per my understanding coming to a proper conclusion wrt RPO > > > > You stil

Re: Export operation efficiency in read replica

2025-03-21 Thread Guillaume Lelarge
On 20/03/2025 15:04, Adrian Klaver wrote: On 3/20/25 05:58, Siraj G wrote: Hello Laurenz As per my understanding coming to a proper conclusion wrt RPO You still have not defined what RPO is. I guess the OP is talking about Recovery Point Objective, which is one of two important parameter

Re: Export operation efficiency in read replica

2025-03-20 Thread Laurenz Albe
On Thu, 2025-03-20 at 18:28 +0530, Siraj G wrote: > As per my understanding coming to a proper conclusion wrt RPO with > export operation is challenging. Eg., the export started at x and > ended at z, the time stamp here for many data sets is different. > Moreover, I do not think there is an increm

Re: Export operation efficiency in read replica

2025-03-20 Thread Ron Johnson
On Thu, Mar 20, 2025 at 7:52 AM Siraj G wrote: > Hello Experts! > > 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

Re: Export operation efficiency in read replica

2025-03-20 Thread Siraj G
Hello Laurenz As per my understanding coming to a proper conclusion wrt RPO with export operation is challenging. Eg., the export started at x and ended at z, the time stamp here for many data sets is different. Moreover, I do not think there is an incremental way available for export, correct? P

Re: Export operation efficiency in read replica

2025-03-20 Thread Laurenz Albe
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: 16.6 > > What w

Export operation efficiency in read replica

2025-03-20 Thread Siraj G
Hello Experts! 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: 16.6 What would be the RPO of such backup? What would be