Postgres Pro
Downloads
Home   >   mailing lists

Re: WALWriteLock - Mailing list pgsql-admin

From Vijaykumar Jain
Subject Re: WALWriteLock
Date
Msg-id CAM+6J94_5S=c_KxtbeQ8grMM2FBZ01WByYrr9FjfAFyA7MDxEA@mail.gmail.com
Whole thread Raw
In response to WALWriteLock  (Yambu <hyambu@gmail.com>)
Responses Re: WALWriteLock  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
List pgsql-admin
Tree view

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?




pgsql-admin by date:

Previous
From: Yambu
Date:
Subject: WALWriteLock
Next
From: Vijaykumar Jain
Date:
Subject: Re: WALWriteLock