Re: WAL replay is too slow on secondary server

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: WAL replay is too slow on secondary server
Дата
Msg-id ce7a0632877f187246a96bde9c41e590c8986703.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: WAL replay is too slow on secondary server  (Shubhang Joshi <shubhangjoshi2405@gmail.com>)
Ответы Re: WAL replay is too slow on secondary server
Список pgsql-admin
On Thu, 2025-10-30 at 17:08 +0530, Shubhang Joshi wrote:
> On Thu, 30 Oct, 2025, 10:07 am OMPRAKASH SAHU, <sahuop2121@gmail.com> wrote:
> > We have a postgresql cluster setup using patroni.
> > The DB is being used for heavy transactional application, now the problem is that on replica server WAL replay is
tooslow. 
> > We have increased the IOPS to 6k and Throughput to 600 on nvme EBS volume of wal directory and 10k &800 on data
directory.
> >
> > but the WAL is being accumulated on the replica as usual and applying wal is having no improvement.
>
> Please check the network speed — we faced a similar issue earlier, and it turned out to be related to network
performance.
> Kindly verify the network latency with your network team as well.

If WAL is piling up on the standby, how can network speed be the problem?

Yours,
Laurenz Albe



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