Postgres Pro
Downloads
Home   >   mailing lists

session waiting IO while background writer writing data - Mailing list pgsql-performance

From James Pang
Subject session waiting IO while background writer writing data
Date
Msg-id CAHgTRfd4kwVBgQ5Pc+i+CRTRaWm1y7wGpZMyMEbfdyjG7bGKVg@mail.gmail.com
Whole thread Raw
List pgsql-performance
Tree view
   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

pgsql-performance by date:

Previous
From: MichaelDBA
Date:
Subject: Re: many sessions wait on LWlock WALWrite suddenly
Next
From: Yura Sokolov
Date:
Subject: Re: many sessions wait on LWlock WALWrite suddenly