Re: WALWriteLocks - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: WALWriteLocks
Date
Msg-id 6e8a24089781301efb1e06d0b0b0924439e10b4a.camel@cybertec.at
Whole thread Raw
In response to Re: WALWriteLocks  (Don Seiler <don@seiler.us>)
Responses Re: WALWriteLocks
List 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 by date:

Previous
From: Don Seiler
Date:
Subject: Re: WALWriteLocks
Next
From: "Godfrin, Philippe E"
Date:
Subject: RE: [EXTERNAL] timescaledb backup, pg_dump warnings