Horton

Re: [Proposal] Add accumulated statistics

Bruce Momjian <bruce@momjian.us>

View thread
From: Bruce Momjian <bruce@momjian.us>
To: "Yotsunaga, Naoki" <yotsunaga.naoki@jp.fujitsu.com>
Cc: 'Phil Florent' <philflorent@hotmail.com>, 'Michael Paquier' <michael@paquier.xyz>, 'Tomas Vondra' <tomas.vondra@2ndquadrant.com>, "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Date: 2018-11-21T21:27:25Z
Lists: pgsql-hackers 
On Tue, Nov  6, 2018 at 04:26:03AM +0000, Yotsunaga, Naoki wrote:
> 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.

I am replying late, but one of the reasons that sampling is used is that
decreasing the sampling interval increases to overhead of the sampling
process, but doesn't affect the running backends.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +