Re: proposal for 9.5: monitoring lock time for slow queries

Поиск
Список
Период
Сортировка
От MauMau
Тема Re: proposal for 9.5: monitoring lock time for slow queries
Дата
Msg-id 5655F5E79C8E46D7AA89C9DA003A1FD3@maumau
обсуждение исходный текст
Ответ на Re: proposal for 9.5: monitoring lock time for slow queries  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
From: "Alvaro Herrera" <alvherre@2ndquadrant.com>
> Is this supposed to be session-local data, or is it visible from remote
> sessions too?  How durable is it supposed to be?  Keep in mind that in
> case of a crash, all pgstats data is erased.

I want it to be visible from other sessions.  I'm okay about the data 
erasure during recovery.  We can probably extend pg_statsinfo to save the 
new info for long-term trend analysis.  TBH, I want a feature like 
pg_statsinfo in core.

Regards
MauMau




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

Предыдущее
От: "MauMau"
Дата:
Сообщение: Re: [patch] pg_copy - a command for reliable WAL archiving
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Reporting the commit LSN at commit time