Re: WALWriteLocks

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: WALWriteLocks
Дата
Msg-id 6e8a24089781301efb1e06d0b0b0924439e10b4a.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: WALWriteLocks  (Don Seiler <don@seiler.us>)
Ответы Re: WALWriteLocks  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Список pgsql-admin
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 по дате отправления:

Предыдущее
От: Don Seiler
Дата:
Сообщение: Re: WALWriteLocks
Следующее
От: "Godfrin, Philippe E"
Дата:
Сообщение: RE: [EXTERNAL] timescaledb backup, pg_dump warnings