WAL restore is very slow

Поиск
Список
Период
Сортировка
От Madhu Sudan
Тема WAL restore is very slow
Дата
Msg-id CABai+ZMELUgce33KXvMXmRcHfhRkdbmkfP6kWdq_kQC8KtU81A@mail.gmail.com
обсуждение исходный текст
Ответы Re: WAL restore is very slow  (John Scalia <jayknowsunix@gmail.com>)
Re: WAL restore is very slow  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-admin
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
2. Memory consumption and swap
3. EFS IO throughput
4.checkpoint_completion_target = 0.9
5. wal_buffers = 16MB
6. wal_log_hints = on
7. Verified logs and didn't find anything useful related to the issue

Can you please suggest how to improve the WAL restore performance 

Thank you 
Madhu Sudan



В списке pgsql-admin по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: max_wal_size and wal_keep_size
Следующее
От: John Scalia
Дата:
Сообщение: Re: WAL restore is very slow