| From: | "Yotsunaga, Naoki" <yotsunaga(dot)naoki(at)jp(dot)fujitsu(dot)com> |
|---|---|
| To: | 'Phil Florent' <philflorent(at)hotmail(dot)com>, 'Michael Paquier' <michael(at)paquier(dot)xyz> |
| Cc: | 'Tomas Vondra' <tomas(dot)vondra(at)2ndquadrant(dot)com>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | RE: [Proposal] Add accumulated statistics |
| Date: | 2018-11-06 04:26:03 |
| Message-ID: | 8E9126CB6CE2CD42962059AB0FBF7B0DC61229@g01jpexmbkw23 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2018-11-06 04:29:36 | Re: Strange failure in LWLock on skink in REL9_5_STABLE |
| Previous Message | Masahiko Sawada | 2018-11-06 04:16:00 | Re: [HACKERS] Two pass CheckDeadlock in contentent case |