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