session waiting IO while background writer writing data

From: James Pang <jamespang886(at)gmail(dot)com>
To: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: session waiting IO while background writer writing data
Date: 2025-04-14 05:30:07
Message-ID: CAHgTRfd4kwVBgQ5Pc+i+CRTRaWm1y7wGpZMyMEbfdyjG7bGKVg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Browse pgsql-performance by date

  From Date Subject
Next Message Yura Sokolov 2025-04-15 09:16:40 Re: many sessions wait on LWlock WALWrite suddenly
Previous Message MichaelDBA 2025-04-11 22:43:10 Re: many sessions wait on LWlock WALWrite suddenly