Re: WAL restore is very slow

[Jeff Janes <jeff.janes@xxxxxxxxx>]

On Mon, Aug 29, 2022 at 6:10 AM Madhu Sudan <madhusudan0429@xxxxxxxxx> wrote:

Hi

We have PG-14 with a huge data set of 14 TB running on r5b.2xlarge. We have set up WAL archiving and restoring them onto a replica server. The WAL restore on the replica is very slow and we are not able to achieve the 4 hour delayed replica. It is always behind 30 hrs with the huge WAL generation.

I have checked the following and they look fine

1. Bottlenecks on the replica server

How did you check for bottlenecks, and what did you see to conclude it looked fine?  Clearly there is a bottleneck somewhere.

Cheers,

Jeff