Horton

session waiting IO while background writer writing data

James Pang <jamespang886@gmail.com>

View thread View on postgr.es
From: James Pang <jamespang886@gmail.com>
To: pgsql-performance@lists.postgresql.org
Date: 2025-04-14T05:30:07Z
Lists: pgsql-performance 
   pgv14.8 , we found all session waiting on "DataFileWrite", and at the
same time, background writer is doing IO and waiting on "DataFileWrite". Is
it possible to see "background writer" block or impact user sessions IO
"DatafileWrite" if both running at the same time ?

Thanks,

James