Re: many sessions wait on LWlock WALWrite suddenly

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: James Pang <jamespang886(at)gmail(dot)com>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: many sessions wait on LWlock WALWrite suddenly
Date: 2025-04-11 19:59:29
Message-ID: d3027d5bda539fbb8e4c6011c256cb82bc8415cd.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, 2025-04-11 at 22:36 +0800, James Pang wrote:
> pgv14.8 , during peak time, we suddenly see hundreds of active sessions waiting on LWlock
> WALWrite at the same time, but we did not find any issue on storage .
> any suggestions ? 

You should get a reasonably sized (much smaller) connection pool.
That will probably take care of the problem and will probably
improve your overall performance.

Yours,
Laurenz Albe

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message MichaelDBA 2025-04-11 22:43:10 Re: many sessions wait on LWlock WALWrite suddenly
Previous Message James Pang 2025-04-11 14:36:57 many sessions wait on LWlock WALWrite suddenly