Re: [Todo item] Add entry creation timestamp column topg_stat_replication

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: [Todo item] Add entry creation timestamp column topg_stat_replication
Дата
Msg-id 20181204060657.GA6859@paquier.xyz
обсуждение исходный текст
Ответ на Re: [Todo item] Add entry creation timestamp column topg_stat_replication  (Michael Paquier <michael@paquier.xyz>)
Ответы RE: [Todo item] Add entry creation timestamp column topg_stat_replication  ("myungkyu.lim" <myungkyu.lim@samsung.com>)
Список pgsql-hackers
On Tue, Dec 04, 2018 at 12:56:25PM +0900, Michael Paquier wrote:
> I have been looking at this patch more in-depth, and you missed one
> critical thing: hot standby feedback messages also include the timestamp
> the client used when sending the message, so if we want to track the
> latest time when a message has been sent we should track it as much as
> the timestamp from status update messages.
>
> Fixing that and updating a couple of comments and variables, I am
> finishing with the attached.  Thoughts?
>
> (The catversion bump is a self-reminder, don't worry about it.)

Another thing which is crossing my mind is if it would make sense to
report the timestamp of the last HS feedback message and the timestamp
of the last status update message into two separate columns.  As the
point of this field is to help with the debugging of mostly idle systems
it seems to me that merging both is fine, but I'd like to hear extra
opinions about that.
--
Michael

Вложения

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

Предыдущее
От: Tatsuro Yamada
Дата:
Сообщение: Re: Tab completion for ALTER INDEX|TABLE ALTER COLUMN SET STATISTICS
Следующее
От: Pavel Stehule
Дата:
Сообщение: slow queries over information schema.tables