many sessions waiting DataFileRead and extend

2025-06-24 Thread James Pang
pgv14, RHEL8, xfs , we suddenly see tens of sessions waiting on "DataFileRead" and "extend", it last about 2 seconds(based on pg_stat_activity query) , during the waiting time, "%sys" cpu increased to 80% , but from "iostat" , no high iops and io read/write latency increased either. many sess

Re: many sessions waiting DataFileRead and extend

2025-06-24 Thread Laurenz Albe
On Wed, 2025-06-25 at 11:15 +0800, James Pang wrote: > pgv14, RHEL8, xfs , we suddenly see tens of sessions waiting on > "DataFileRead" and > "extend", it last about 2 seconds(based on pg_stat_activity query) , during > the > waiting time, "%sys" cpu increased to 80% , but from "iostat" , no high