RE: [Proposal] Add accumulated statistics

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-13 00:47:11
Message-ID: 8E9126CB6CE2CD42962059AB0FBF7B0DC635D5@g01jpexmbkw23
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Nov 5, 2018 at 4:26 PM, Naoki Yotsunaga wrote:

>>2) it consumes system resources
>While the system is running, you are always sampling system information, do not you? Like Oracle ASH.

I don’t understand well how sampling is used.
In which scene do you use the sampling? Or is it both scenes? Or is it a different scene?

A) Perform sampling in order to obtain information on the entire DB while DB is in operation.

B) I know roughly the process to be late. When investigating the reason for delaying the processing, sampling is performed on the processing.

---------------------------
Naoki Yotsunaga

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2018-11-13 01:16:36 Re: [HACKERS] Decimal64 and Decimal128
Previous Message Thomas Munro 2018-11-13 00:43:24 Re: Copy data to DSA area