On Tue, Jul 6, 2021, 7:54 PM Vijaykumar Jain <vijaykumarjain.github@xxxxxxxxx> wrote:
On Tue, Jul 6, 2021, 7:44 PM Yambu <hyambu@xxxxxxxxx> wrote:HelloI'm seeing a lot of WALWriteLocks , is this a bad sign , what might cause this?pg versioncloud or on premWhen 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 ?
