Postgres Pro
Downloads
Home   >   mailing lists

Re: WALWriteLock - Mailing list pgsql-admin

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


On Tue, Jul 6, 2021, 7:54 PM Vijaykumar Jain <vijaykumarjain.github@gmail.com> wrote:

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?

Also, is it during checkpointing ?
how much is the checkpoint spread, 
You can enable logging checkpoints,
to help relate correlation between checkpoint windows and walwrite locks piling up ? 

pgsql-admin by date:

Previous
From: Vijaykumar Jain
Date:
Subject: Re: WALWriteLock
Next
From: Jeff Janes
Date:
Subject: Re: Archive cleanup