Re: WALWriteLock

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: WALWriteLock
Дата
Msg-id CAMkU=1yCHs98qsSEPvkR5-kLY4Zi0au0cwd1-xUWM8Kzfyo9pA@mail.gmail.com
обсуждение исходный текст
Ответ на WALWriteLock  (Yambu <hyambu@gmail.com>)
Ответы Re: WALWriteLock  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Список pgsql-admin
On Tue, Jul 6, 2021 at 10:14 AM Yambu <hyambu@gmail.com> wrote:
Hello

I'm seeing a lot of WALWriteLocks , is this a bad sign , what might cause this?

Are you having a performance problem you are trying to track down?  If so, this probably indicates the cause.  If not, then it is probably not a bad sign.

The likely cause is that multiple sessions are trying to COMMIT at the same time, and are blocking on the slow fsync of the WAL data.  One process will block on WALSync, all the ones queued up behind it will block on WALWrite.

Cheers,

Jeff

В списке pgsql-admin по дате отправления:

Предыдущее
От: Vijaykumar Jain
Дата:
Сообщение: Re: Patroni configuration issue
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: D in top results for checkpoint