many sessions wait on LWlock WALWrite suddenly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: many sessions wait on LWlock WALWrite suddenly
From: James Pang <jamespang886@xxxxxxxxx>
Date: Fri, 11 Apr 2025 22:36:57 +0800

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

Follow-Ups:
- Re: many sessions wait on LWlock WALWrite suddenly
  - From: Yura Sokolov
- Re: many sessions wait on LWlock WALWrite suddenly
  - From: MichaelDBA
- Re: many sessions wait on LWlock WALWrite suddenly
  - From: Laurenz Albe

Prev by Date: Re: parallel pg_restore blocks on heavy random read I/O on all children processes
Next by Date: Re: many sessions wait on LWlock WALWrite suddenly
Previous by thread: Question on what Duration in the log
Next by thread: Re: many sessions wait on LWlock WALWrite suddenly
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux