Home > mailing lists

Re: WALWriteLock - Mailing list pgsql-admin

From	Vijaykumar Jain
Subject	Re: WALWriteLock
Date	July 6, 2021 17:24:31
Msg-id	CAM+6J94_5S=c_KxtbeQ8grMM2FBZ01WByYrr9FjfAFyA7MDxEA@mail.gmail.com Whole thread Raw
In response to	WALWriteLock (Yambu <hyambu@gmail.com>)
Responses	Re: WALWriteLock
List	pgsql-admin

On Tue, Jul 6, 2021, 7:44 PM Yambu <hyambu@gmail.com> wrote:

Hello

I'm seeing a lot of WALWriteLocks , is this a bad sign , what might cause this?

pg version

cloud or on prem

When do you see this piling up? Heavy concurrent usage or regular usage but random spike in locks?

Underlying storage shows any anomalies?

resource utilization normal or high?

pg part of master replica setup with synchronous replication or async ?

Disk iowait high?

From: Yambu
Date: 06 July 2021, 17:14:25
Subject: WALWriteLock

From: Vijaykumar Jain
Date: 06 July 2021, 17:28:35
Subject: Re: WALWriteLock