Re: WALWriteLocks
| От | Vijaykumar Jain |
|---|---|
| Тема | Re: WALWriteLocks |
| Дата | |
| Msg-id | CAM+6J96N8SQ_eV1ttdVJmVEyHxz8m96Cp2A4YpZyX3FLf8E2pg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: WALWriteLocks (Laurenz Albe <laurenz.albe@cybertec.at>) |
| Ответы |
Re: WALWriteLocks
|
| Список | pgsql-admin |
Hey Don,
Was this resolved?
We're there any changes after moving wal to ssd ?
On Wed, May 5, 2021, 10:14 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Wed, 2021-05-05 at 11:25 -0500, Don Seiler wrote:
> What I want to know is if there are other events that would contribute
> to a WALWriteLock (eg writing to a data file or the postgresql.log file)
> or is it 100% writing to the WAL file.
You don't contribute to a lock...
The documentation says
(https://www.postgresql.org/docs/13/monitoring-stats.html#WAIT-EVENT-LOCK-TABLE):
> WALWrite Waiting for WAL buffers to be written to disk.
So it is contention while writing or flushing WAL.
You can read the code for the details.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com
В списке pgsql-admin по дате отправления: