RE: [Proposal] Add accumulated statistics

Поиск
Список
Период
Сортировка
От Yotsunaga, Naoki
Тема RE: [Proposal] Add accumulated statistics
Дата
Msg-id 8E9126CB6CE2CD42962059AB0FBF7B0DC9B9F6@g01jpexmbkw23
обсуждение исходный текст
Ответ на Re: [Proposal] Add accumulated statistics  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Thu, Jan 10, 2019 at 8:42 PM, Robert Hass wrote:

Thanks for comments.

>or at least not nearly as useful the results of a sampling approach.
I agree with your opinion.
Because it can't be asserted that the wait event is a bottleneck just because the number of wait event is large.
The same thing is mentioned in Oracle.
It also suggests that it is important to acquire waiting time for that.
----

https://docs.oracle.com/en/database/oracle/oracle-database/18/tgdba/measuring-database-performance.html#GUID-811E9E65-C64A-4028-A90E-102BBFF6E68F
5.2.3 Using Wait Events without Timed Statistics
----

>The data that LWLOCK_STATS produce are downright misleading 
Is that so?
I do not know the need for this function.

---
Naoki Yotsunaga

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: What to name the current heap after pluggable storage / what torename?
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Making WAL receiver startup rely on GUC context forprimary_conninfo and primary_slot_name