Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kV8AM-0006Sn-2A for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Oct 2020 07:04:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kV8AJ-0007yE-5S for pgsql-hackers@arkaria.postgresql.org; Wed, 21 Oct 2020 07:04:07 +0000 Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kV8AI-0007wN-Tj for pgsql-hackers@lists.postgresql.org; Wed, 21 Oct 2020 07:04:06 +0000 Received: from r3-20.sinamail.sina.com.cn ([202.108.3.20]) by magus.postgresql.org with smtp (Exim 4.92) (envelope-from ) id 1kV83j-0003bi-Vh for pgsql-hackers@postgresql.org; Wed, 21 Oct 2020 06:57:28 +0000 Received: from unknown (HELO lchch)([124.133.18.218]) by sina.cn with ESMTP id 5F8FDB380000DB51; Wed, 21 Oct 2020 14:54:48 +0800 (CST) X-Sender: lchch1990@sina.cn X-Auth-ID: lchch1990@sina.cn X-SMAIL-MID: 75039115073452 Date: Wed, 21 Oct 2020 14:54:48 +0800 From: "lchch1990@sina.cn" To: "Masahiro Ikeda" , "Amit Kapila" Cc: pgsql-hackers Subject: Re: Add statistics to pg_stat_wal view for wal related parameter tuning References: <35ef960128b90bfae3b3fdf60a3a860f@oss.nttdata.com>, , <06bc2d405b086a72fb14657de9befae8@oss.nttdata.com> X-Priority: 3 X-Has-Attach: no X-Mailer: Foxmail 7.2.16.188[cn] Mime-Version: 1.0 Message-ID: <2020102114544806663477@sina.cn> Content-Type: multipart/alternative; boundary="----=_001_NextPart334804863718_=----" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. ------=_001_NextPart334804863718_=---- Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: base64 DQpJIHRoaW5rIGl0J3MgcmVhbGx5IGEgbW9yZSBjb252ZW5pZW50IHdheSB0byBjb2xsZWN0IHdh bCB1c2FnZSBpbmZvcm1hdGlvbiwNCndpdGggaXQgd2UgY2FuIHF1ZXJ5IHdoZW4gSSB3YW50LiBT ZXZlcmFsIHBvaW50cyBvbiBteSBzaWRlOg0KDQoxLiBJdCB3aWxsIGJlIG5pY2UgSWYgeW91IHBy b3ZpZGUgYSBjaGFuY2UgdG8gcmVzZXQgdGhlIGluZm9ybWF0aW9uIGluIFdhbFN0YXRzLA0Kc28g dGhhdCB3ZSBjYW4gcmVzZXQgaXQgd2l0aG91dCByZXN0YXJ0IHRoZSBkYXRhYmFzZS4NCg0KMi4g SSB0aGluayAnd2FsX3dyaXRlX2JhY2tlbmQnIGlzIG1lYW4gd2FsIHdyaXRlIHRpbWVzIGhhcHBl biBpbg0KYmFja2VuZHMuIFRoZSBkZXNjcmliZSBpbiBkb2N1bWVudCBpcyBub3Qgc28gY2xlYXIs IHN1Z2dlc3QgcmV3cml0ZSBpdC4NCg0KMy4gSSBkbyBub3QgdGhpbmsgaXQncyBhIGNvcnJlY3Qg ZGVzY3JpYmUgaW4gZG9jdW1lbnQgZm9yICd3YWxfYnVmZmVyc19mdWxsJy4NCg0KNC4gUXVpdGUg c3RyYW5nZSB0byBjb2xsZWN0IHR3aWNlIGluIFhMb2dJbnNlcnRSZWNvcmQoKSBmb3IgeGxfdG90 X2xlbiwNCm1fd2FsX3JlY29yZHMsIG1fd2FsX2ZwaS4NCg0KNS4gSSBub3RpY2Ugc29tZSBjb2Rl IGluIGlzc3VlX3hsb2dfZnN5bmMoKSBmdW5jdGlvbiB0byBjb2xsZWN0IHN5bmMgaW5mbywNCmEg c3RhbmRieSBtYXkgY2FsbCB0aGUgaXNzdWVfeGxvZ19mc3luYygpIHRvbywgd2hpY2ggZG8gbm90 IHdhbnQgdG8NCnRvIGNvbGxlY3QgdGhpcyBpbmZvLiBJIHRoaW5rIHRoaXMgbmVlZCBzb21lIGNo YW5nZSBhdm9pZCBydW4gYnkgc3RhbmRieQ0Kc2lkZS4gDQoNCg0KDQpSZWdhcmRzLA0KSGlnaGdv IFNvZnR3YXJlIChDYW5hZGEvQ2hpbmEvUGFraXN0YW4pIA0KVVJMIDogd3d3LmhpZ2hnby5jYSAN CkVNQUlMOiBtYWlsdG86bW92ZWFkKGRvdClsaShhdCloaWdoZ28oZG90KWNhDQo= ------=_001_NextPart334804863718_=---- Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable