Home > mailing lists

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

From	James Pang
Subject	many sessions wait on LWlock WALWrite suddenly
Date	April 11 17:36:57
Msg-id	CAHgTRffKZ8DvcFJHRpwkBMQZg5XLRbd5yWe+pSGeVRqbqXDsDg@mail.gmail.com Whole thread Raw
Responses	Re: many sessions wait on LWlock WALWrite suddenly Re: many sessions wait on LWlock WALWrite suddenly Re: many sessions wait on LWlock WALWrite suddenly
List	pgsql-performance

Tree view

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 ?

Thanks,

James

pgsql-performance by date:

From: Hannu Krosing
Date: 10 April, 09:50:33
Subject: Re: parallel pg_restore blocks on heavy random read I/O on all children processes

From: Laurenz Albe
Date: 11 April, 22:59:29
Subject: Re: many sessions wait on LWlock WALWrite suddenly

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

Previous

Next