Thank you, people. The big problem in my case, which I have not mentioned, is that I think the network is a bottleneck, because I am running pg_basebackup through internet from local country to Amazon instance in Germany and the speed in copying is around 50 MB/sec max, that is why it takes 2 days for copying.
I will try using high compression for the basebackup to reduce the time.
pgbackrest is an alternative, too
Thank you again!
On Wed, Aug 17, 2022 at 11:13 PM Ivan N. Ivanov <ivan.ni@xxxxxxxxxxxxxxx> wrote:
Thank you for your answer! I have found this tool and I will try it tomorrow to see if this "read-ahead" feature will speed up the process.On Wed, Aug 17, 2022 at 11:09 PM Christophe Pettus <xof@xxxxxxxxxxxx> wrote:
> On Aug 17, 2022, at 13:06, Ivan N. Ivanov <ivan.ni@xxxxxxxxxxxxxxx> wrote:
>
> How to speed up recovering of WAL files?
Since you are running on your own hardware, you might take a look at:
https://github.com/TritonDataCenter/pg_prefaulter
