Content-Type: multipart/mixed; boundary="------------4q5Q2zK3iqcg8dYCL0r767Ua"
Message-ID: <beccfab0-8142-1526-c219-2e8352977629@postgrespro.ru>
Date: Mon, 10 Apr 2023 10:41:38 +0300
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.7.1
Subject: Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and
 more?)
Content-Language: en-US
To: Melanie Plageman <melanieplageman@gmail.com>
Cc: Justin Pryzby <pryzby@telsasoft.com>, Andres Freund <andres@anarazel.de>,
 Kyotaro Horiguchi <horikyota.ntt@gmail.com>, tgl@sss.pgh.pa.us,
 vignesh21@gmail.com, lukas@fittl.com, alvherre@alvh.no-ip.org,
 magnus@hagander.net, pgsql-hackers@postgresql.org, thomas.munro@gmail.com,
 m.sakrejda@gmail.com
References: <20230306.152425.316894602450485455.horikyota.ntt@gmail.com>
 <20230306.154843.178021884584228317.horikyota.ntt@gmail.com>
 <CAAKRu_ZRKp-zDCSVk9p8XE=ZKTn3WiJD6Mt=n=eSPQ7Kg-=HRw@mail.gmail.com>
 <20230306190919.ai6mxdq3sygyyths@awork3.anarazel.de>
 <20230306192409.daz5ivq4mbbr2ye7@liskov>
 <20230306193404.3btuacgc6um33mt2@awork3.anarazel.de>
 <CAAKRu_ZmAhCGzk2GkNeMHTu0Oh=rtNKU7Q+fkzLs-PZBp1sicg@mail.gmail.com>
 <20230307181844.hxnlfi3wa5lm7sm2@awork3.anarazel.de>
 <ZAnWU8WbXEDjrfUE@telsasoft.com>
 <20230309194301.mjdddcoswgr6xoxa@awork3.anarazel.de>
 <ZAuQuBQa7eKAITeA@telsasoft.com>
 <CAAKRu_YHKj73MjgTLZUraQ72VFm=CWg14Dp0BDbsM5YUgWG89Q@mail.gmail.com>
 <fcbe2851-f1fb-9863-54bc-a95dc7a0d946@postgrespro.ru>
 <CAAKRu_bk1LTUezVwTO+NLcXp9TTmLtdUnmFHskzniNo6ThqxvQ@mail.gmail.com>
 <d9913624-9cb1-d238-21f7-266f0a1eef82@postgrespro.ru>
 <CAAKRu_ZKYT=FMV2OME5J7Da1roD4cBOiRho3RCu1rNYN98hbtA@mail.gmail.com>
From: Pavel Luzanov <p.luzanov@postgrespro.ru>
In-Reply-To: 
 <CAAKRu_ZKYT=FMV2OME5J7Da1roD4cBOiRho3RCu1rNYN98hbtA@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/beccfab0-8142-1526-c219-2e8352977629%40postgrespro.ru>
Precedence: bulk

This is a multi-part message in MIME format.
--------------4q5Q2zK3iqcg8dYCL0r767Ua
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

On 05.04.2023 03:41, Melanie Plageman wrote:
> On Tue, Apr 4, 2023 at 4:35 PM Pavel Luzanov <p.luzanov@postgrespro.ru> wrote:
>
>> After a little thought... I'm not sure about the term 'bootstrap
>> process'. I can't find this term in the documentation.
> There are various mentions of "bootstrap" peppered throughout the docs
> but no concise summary of what it is. For example, initdb docs mention
> the "bootstrap backend" [1].
>
> Interestingly, 910cab820d0 added "Bootstrap superuser" in November. This
> doesn't really cover what bootstrapping is itself, but I wonder if that
> is useful? If so, you could propose a glossary entry for it?
> (preferably in a new thread)

I'm not sure if this is the reason for adding a new entry in the glossary.

>> Do I understand correctly that this is a postmaster? If so, then the
>> postmaster process is not shown in pg_stat_activity.
> No, bootstrap process is for initializing the template database. You
> will not be able to see pg_stat_activity when it is running.

Oh, it's clear to me now. Thank you for the explanation.

> You can query pg_stat_activity from single user mode, so it is relevant
> to pg_stat_activity also. I take your point that bootstrap mode isn't
> relevant for pg_stat_activity, but I am hesitant to add that distinction
> to the pg_stat_io docs since the reason you won't see it in
> pg_stat_activity is because it is ephemeral and before a user can access
> the database and not because stats are not tracked for it.
>
> Can you think of a way to convey this?

See my attempt attached.
I'm not sure about the wording. But I think we can avoid the term 
'bootstrap process'
by replacing it with "database cluster initialization", which should be 
clear to everyone.

-- 
Pavel Luzanov
Postgres Professional: https://postgrespro.com

--------------4q5Q2zK3iqcg8dYCL0r767Ua
Content-Type: text/x-patch; charset=UTF-8;
 name="v2-0001-PATCH-v2-Document-standalone-backend-type-in-pg_s.patch"
Content-Disposition: attachment;
 filename*0="v2-0001-PATCH-v2-Document-standalone-backend-type-in-pg_s.pa";
 filename*1="tch"
Content-Transfer-Encoding: base64

RnJvbSBmZjc2YjgxYTlkNTI1ODFmNmZkYWY5YzFmMzg4NWU4MjcyZDJhZTNjIE1vbiBTZXAg
MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBQYXZlbCBMdXphbm92IDxwLmx1emFub3ZAcG9zdGdy
ZXNwcm8ucnU+CkRhdGU6IE1vbiwgMTAgQXByIDIwMjMgMTA6MjU6NTIgKzAzMDAKU3ViamVj
dDogW1BBVENIIHYyXSBbUEFUQ0ggdjJdIERvY3VtZW50IHN0YW5kYWxvbmUgYmFja2VuZCB0
eXBlIGluCiBwZ19zdGF0X2FjdGl2aXR5CgpSZXBvcnRlZC1ieTogUGF2ZWwgTHV6YW5vdiA8
cC5sdXphbm92QHBvc3RncmVzcHJvLnJ1PgpEaXNjdXNzaW9uOiBodHRwczovL3d3dy5wb3N0
Z3Jlc3FsLm9yZy9tZXNzYWdlLWlkL2ZjYmUyODUxLWYxZmItOTg2My01NGJjLWE5NWRjN2Ew
ZDk0NiU0MHBvc3RncmVzcHJvLnJ1Ci0tLQogZG9jL3NyYy9zZ21sL21vbml0b3Jpbmcuc2dt
bCB8IDMgKysrCiAxIGZpbGUgY2hhbmdlZCwgMyBpbnNlcnRpb25zKCspCgpkaWZmIC0tZ2l0
IGEvZG9jL3NyYy9zZ21sL21vbml0b3Jpbmcuc2dtbCBiL2RvYy9zcmMvc2dtbC9tb25pdG9y
aW5nLnNnbWwKaW5kZXggM2YzM2ExYzU2Yy4uNDVlMjBlZmJmYiAxMDA2NDQKLS0tIGEvZG9j
L3NyYy9zZ21sL21vbml0b3Jpbmcuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvbW9uaXRvcmlu
Zy5zZ21sCkBAIC05OTEsNiArOTkxLDkgQEAgcG9zdGdyZXMgICAyNzA5MyAgMC4wICAwLjAg
IDMwMDk2ICAyNzUyID8gICAgICAgIFNzICAgMTE6MzQgICAwOjAwIHBvc3RncmVzOiBzZXIK
ICAgICAgICA8bGl0ZXJhbD5hcmNoaXZlcjwvbGl0ZXJhbD4sCiAgICAgICAgPGxpdGVyYWw+
c3RhcnR1cDwvbGl0ZXJhbD4sIDxsaXRlcmFsPndhbHJlY2VpdmVyPC9saXRlcmFsPiwKICAg
ICAgICA8bGl0ZXJhbD53YWxzZW5kZXI8L2xpdGVyYWw+IGFuZCA8bGl0ZXJhbD53YWx3cml0
ZXI8L2xpdGVyYWw+LgorICAgICAgIFRoZSBzcGVjaWFsIHR5cGUgPGxpdGVyYWw+c3RhbmRh
bG9uZSBiYWNrZW5kPC9saXRlcmFsPiBpcyB1c2VkCisgICAgICAgd2hlbiBpbml0aWFsaXpp
bmcgYSBkYXRhYmFzZSBjbHVzdGVyIGJ5IDx4cmVmIGxpbmtlbmQ9ImFwcC1pbml0ZGIiLz4K
KyAgICAgICBhbmQgd2hlbiBydW5uaW5nIGluIHRoZSA8eHJlZiBsaW5rZW5kPSJhcHAtcG9z
dGdyZXMtc2luZ2xlLXVzZXIiLz4uCiAgICAgICAgSW4gYWRkaXRpb24sIGJhY2tncm91bmQg
d29ya2VycyByZWdpc3RlcmVkIGJ5IGV4dGVuc2lvbnMgbWF5IGhhdmUKICAgICAgICBhZGRp
dGlvbmFsIHR5cGVzLgogICAgICAgPC9wYXJhPjwvZW50cnk+Ci0tIAoyLjM0LjEKCg==

--------------4q5Q2zK3iqcg8dYCL0r767Ua--