Re: many sessions wait on LWlock WALWrite suddenly - Mailing list pgsql-performance

From Laurenz Albe
Subject Re: many sessions wait on LWlock WALWrite suddenly
Date
Msg-id d3027d5bda539fbb8e4c6011c256cb82bc8415cd.camel@cybertec.at
Whole thread Raw
In response to many sessions wait on LWlock WALWrite suddenly  (James Pang <jamespang886@gmail.com>)
List 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



pgsql-performance by date:

Previous
From: James Pang
Date:
Subject: many sessions wait on LWlock WALWrite suddenly
Next
From: MichaelDBA
Date:
Subject: Re: many sessions wait on LWlock WALWrite suddenly