Re: WALWriteLocks
От
Laurenz Albe
Тема
Re: WALWriteLocks
Дата
Msg-id
6e8a24089781301efb1e06d0b0b0924439e10b4a.camel@cybertec.at
Ответ на
Re: WALWriteLocks (Don Seiler)
Список
Дерево обсуждения
WALWriteLocks Don Seiler <don@seiler.us>
Re: WALWriteLocks Laurenz Albe <laurenz.albe@cybertec.at>
Re: WALWriteLocks Don Seiler <don@seiler.us>
Re: WALWriteLocks Laurenz Albe <laurenz.albe@cybertec.at>
Re: WALWriteLocks Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Re: WALWriteLocks Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Re: WALWriteLocks Laurenz Albe <laurenz.albe@cybertec.at>
Re: WALWriteLocks Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Re: WALWriteLocks Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Re: WALWriteLocks Don Seiler <don@seiler.us>
Re: WALWriteLocks Laurenz Albe <laurenz.albe@cybertec.at>
Re: WALWriteLocks Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Re: WALWriteLocks Don Seiler <don@seiler.us>
Re: WALWriteLocks Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Re: WALWriteLocks Don Seiler <don@seiler.us>
Re: WALWriteLocks Vijaykumar Jain <vijaykumarjain.github@gmail.com>
Re: WALWriteLocks Don Seiler <don@seiler.us>
RE: [EXTERNAL] Re: WALWriteLocks "Godfrin, Philippe E" <philippe.godfrin@nov.com>
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 по дате отправления
От: Godfrin, Philippe E
Дата:
