On Fri, 2024-09-06 at 08:33 +0500, Muhammad Usman Khan wrote: > On Thu, 5 Sept 2024 at 06:04, Karthik Yellapragada <karthik.yellapragada@xxxxxxxxx> wrote: > > 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? > > > > 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 These settings won't do anything to mitigate the problem. All you can do is get more network bandwidth. Yours, Laurenz Albe
