Re: WALWriteLock

Поиск
Список
Период
Сортировка
От Vijaykumar Jain
Тема Re: WALWriteLock
Дата
Msg-id CAM+6J96Ofhc=WE1JLZfZQq54JP8v2ztFBb--wC+LVR4eZwueQA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: WALWriteLock  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Список pgsql-admin


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 по дате отправления:

Предыдущее
От: Vijaykumar Jain
Дата:
Сообщение: Re: WALWriteLock
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Archive cleanup