Postgres Pro
Downloads
Home   >   mailing lists

Export operation efficiency in read replica - Mailing list pgsql-general

From Siraj G
Subject Export operation efficiency in read replica
Date
Msg-id CAC5iy60ZzcsxL1GKAdUdiqA7TFv_yQW3ZkN07VJM8J1Xkdk8Gg@mail.gmail.com
Whole thread Raw
Responses Re: Export operation efficiency in read replica
Re: Export operation efficiency in read replica
List pgsql-general
Tree view
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 the impact on the READ REPLICA with a long running export operation?

Thank you!
Siraj

pgsql-general by date:

Previous
From: Paul Allen
Date:
Subject: Bloated toast table with empty associated table
Next
From: Laurenz Albe
Date:
Subject: Re: Export operation efficiency in read replica