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 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?