Re: WALWriteLocks - Mailing list pgsql-admin

From Vijaykumar Jain
Subject Re: WALWriteLocks
Date
Msg-id CAM+6J96N8SQ_eV1ttdVJmVEyHxz8m96Cp2A4YpZyX3FLf8E2pg@mail.gmail.com
Whole thread Raw
In response to Re: WALWriteLocks  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: WALWriteLocks
List 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 by date:

Previous
From: "Michel SALAIS"
Date:
Subject: RE: Get stats of deletes ,inserts,trasnactions and updates daily in entire database
Next
From: Don Seiler
Date:
Subject: Re: WALWriteLocks