RE: [Proposal] Add accumulated statistics

Поиск
Список
Период
Сортировка
От Yotsunaga, Naoki
Тема RE: [Proposal] Add accumulated statistics
Дата
Msg-id 8E9126CB6CE2CD42962059AB0FBF7B0DC61229@g01jpexmbkw23
обсуждение исходный текст
Ответ на Re: [Proposal] Add accumulated statistics for wait event  (Michael Paquier <michael@paquier.xyz>)
Ответы RE: [Proposal] Add accumulated statistics  ("Yotsunaga, Naoki" <yotsunaga.naoki@jp.fujitsu.com>)
Re: [Proposal] Add accumulated statistics  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers

On Sat, Nov 3, 2018 at 1:28 AM, Phil Florent wrote:

 

>2) it consumes system resources

While the system is running, you are always sampling system information, do not you? Like Oracle ASH.

If so, does sampling have no significant impact on performance? Even if the interval is 0.01 s or more.

 

>The main interest of sampling is to discard negligible activity to allow the DBA to work on meaningful queries and events.

In other words, do you mean narrowing down candidate of problems?

 

---------------------------

Naoki Yotsunaga

 

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

Предыдущее
От: Masahiko Sawada
Дата:
Сообщение: Re: [HACKERS] Two pass CheckDeadlock in contentent case
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: Strange failure in LWLock on skink in REL9_5_STABLE