Re: Parallelize WAL Sender and WAL receiver

Поиск
Список
Период
Сортировка
От Muhammad Usman Khan
Тема Re: Parallelize WAL Sender and WAL receiver
Дата
Msg-id CAPnRvGui2Ze41TjDbpyH=KRR6e8mzowCY-WAuUQBjmS6nafiPA@mail.gmail.com
обсуждение исходный текст
Ответ на Parallelize WAL Sender and WAL receiver  (Karthik Yellapragada <karthik.yellapragada@gmail.com>)
Ответы Re: Parallelize WAL Sender and WAL receiver
Список pgsql-admin
Hi,
You can try to set the following parameters in the conf file which may help to overcome this problem.

wal_sender_timeout = 60s
wal_receiver_status_interval = 1s
Ensure you have sufficient WAL senders  like max_wal_senders = 10
max_wal_size = 2GB
min_wal_size = 80MB
wal_buffers = 16MB
wal_level = replica

On Thu, 5 Sept 2024 at 06:04, Karthik Yellapragada <karthik.yellapragada@gmail.com> wrote:
Hello all,

I frequently face the problem of wals generated faster than the wals transferred and applied.

Is there a way to speed up the process? So I don’t accumulate a lot of WALs at the primary?

Regards,
Karthik.
--
Thanks & Regards
Karthik Yellapragada
+1 860 830 5235

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