Re: [Proposal] Add accumulated statistics - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [Proposal] Add accumulated statistics
Date
Msg-id 20181121212725.GA20251@momjian.us
Whole thread Raw
In response to RE: [Proposal] Add accumulated statistics  ("Yotsunaga, Naoki" <yotsunaga.naoki@jp.fujitsu.com>)
Responses RE: [Proposal] Add accumulated statistics
List 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 +


pgsql-hackers by date:

Previous
From: Dmitry Dolgov
Date:
Subject: Re: Index Skip Scan
Next
From: David Rowley
Date:
Subject: Re: Speeding up INSERTs and UPDATEs to partitioned tables