Re: Export operation efficiency in read replica

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 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