Tracking replication slot "blockings"

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Tracking replication slot "blockings"
Дата
Msg-id CABUevEyD1Q_MGQ6dcwy1yiV8J8wqXXTw+-dY+7C3zUyj-pJS_w@mail.gmail.com
обсуждение исходный текст
Ответы Re: Tracking replication slot "blockings"  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
I'm thinking it could be interesting to know how many times (or in some other useful unit than "times" - how often) a specific replication slot has "blocked" xlog rotation. Since this AFAIK only happens during checkpoints, it seems it should be "reasonably cheap" to track? It would serve as an indicator of which slave(s) are having enough trouble keeping up to potentially cause issues.

Not having looked at that code at all yet, would this be something that's simple to add?

Or is it a silly idea? :)

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Ctrl+C from sh can shut down daemonized PostgreSQL cluster
Следующее
От: Marco Atzeri
Дата:
Сообщение: Re: test failure on latest source