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 1kes49-0005wF-F1 for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Nov 2020 03:54:01 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kes47-0000zp-9A for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Nov 2020 03:53:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kes46-0000zi-Tr for pgsql-hackers@lists.postgresql.org; Tue, 17 Nov 2020 03:53:59 +0000 Received: from mail3-162.sinamail.sina.com.cn ([202.108.3.162]) by makus.postgresql.org with smtp (Exim 4.92) (envelope-from ) id 1kes3z-00011A-Rq for pgsql-hackers@postgresql.org; Tue, 17 Nov 2020 03:53:55 +0000 Received: from unknown (HELO lchch)([124.133.18.218]) by sina.cn with ESMTP id 5FB349410001BAD5; Tue, 17 Nov 2020 11:53:37 +0800 (CST) X-Sender: lchch1990@sina.cn X-Auth-ID: lchch1990@sina.cn X-SMAIL-MID: 64346849283460 Date: Tue, 17 Nov 2020 11:53:37 +0800 From: "lchch1990@sina.cn" To: "Fujii Masao" , "Masahiro Ikeda" Cc: "Amit Kapila" , 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>, <2020102114544806663477@sina.cn>, , <2020111311322320943423@sina.cn>, <3599412d5f3eee44e3658e81d3790f6a@oss.nttdata.com>, X-Priority: 3 X-Has-Attach: no X-Mailer: Foxmail 7.2.16.188[cn] Mime-Version: 1.0 Message-ID: <2020111711533714942211@sina.cn> Content-Type: multipart/alternative; boundary="----=_001_NextPart563485238482_=----" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. ------=_001_NextPart563485238482_=---- Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: base64 DQo+PiBUaGFua3MgZm9yIHlvdXIgY29tbWVudHMuDQo+Pg0KPj4gWW91J3JlIHVuZGVyc3RhbmRp bmcgaXMgYWxtb3N0IHRoZSBzYW1lIGFzIG1pbmUuDQo+PiBJdCBkZXNjcmliZXMgd2hlbiBub3Qg b25seSBiYWNrZW5kcyBidXQgYWxzbyBvdGhlciBiYWNrZ3JvdW5kcyBpbml0aWFsaXplIGEgbmV3 IHdhbCBwYWdlLA0KPj4gd2FsIGJ1ZmZlcidzIHNwYWNlIGlzIGFscmVhZHkgdXNlZCBhbmQgdGhl cmUgaXMgbm8gc3BhY2UuDQo+Pg0KPj4+ICdUb3RhbCBudW1iZXIgb2YgdGltZXMgV0FMIGRhdGEg d3JpdHRlbiB0byB0aGUgZGlzayBiZWNhdXNlIGEgYmFja2VuZA0KPj4+IHllbGxlZCBhIHdhbCBi dWZmZXIgZm9yIGFuIGFkdmFuY2VkIHdhbCBwYWdlJw0KPj4NCj4+IFRoYW5rcyBmb3IgeW91ciBz dWdnZXN0aW9uLg0KPj4gSSB3b25kZXJlZCB0aGF0IHVzZXJzIG1heSBjb25mdXNlIGFib3V0IGhv dyB0byB1c2UgIndhbF9idWZmZXJzX2Z1bGwiIGFuZCBob3cgdG8gdHVuZSBwYXJhbWV0ZXJzLg0K Pj4NCj4+IEkgdGhvdWdodCB0aGUgcmVhc29uIHdoaWNoIHdhbCBidWZmZXIgaGFzIG5vIHNwYWNl IGlzDQo+PiBpbXBvcnRhbnQgZm9yIHVzZXJzIHRvIHR1bmUgdGhlIHdhbF9idWZmZXJzIHBhcmFt ZXRlci4NCj4+DQo+PiBIb3cgYWJvdXQgdGhlIGZvbGxvd2luZyBjb21tZW50cz8NCj4+DQo+PiAn VG90YWwgbnVtYmVyIG9mIHRpbWVzIFdBTCBkYXRhIHdhcyB3cml0dGVuIHRvIHRoZSBkaXNrIGJl Y2F1c2UgV0FMIGJ1ZmZlcnMgZ290IGZ1bGwNCj4+ICAgd2hlbiB0byBpbml0aWFsaXplIGEgbmV3 IFdBTCBwYWdlJw0KPk9yIHdoYXQgYWJvdXQgdGhlIGZvbGxvd2luZz8NCj5Ub3RhbCBudW1iZXIg b2YgdGltZXMgV0FMIGRhdGEgd2FzIHdyaXR0ZW4gdG8gdGhlIGRpc2ssIHRvIGNsYWltIHRoZSBi dWZmZXIgcGFnZSB0byBpbnNlcnQgbmV3DQo+V0FMIGRhdGEgd2hlbiB0aGUgV0FMIGJ1ZmZlcnMg Z290IGZpbGxlZCB1cCB3aXRoIHVud3JpdHRlbiBXQUwgZGF0YS4NCkFzIG15IHVuZGVyc3RhbmQg d2UgY2FuIG5vdCBzYXkgJ2Z1bGwnIGJlY2F1c2UgZXZlcnkgd2FsIHBhZ2UgbWFwcGVkIGEgc3Bl Y2lhbCB3YWwgYnVmZmVyIHNsb3QuDQpXaGVuIGEgd2FsIHBhZ2UgbmVlZCB0byBiZSB3cml0ZSwg YnV0IHRoZSBidWZmZXIgc2xvdCB3YXMgb2NjdXBpZWQgYnkgb3RoZXIgd2FsIHBhZ2UuIEl0IG5l ZWQgdG8NCndhaXQgdGhlIHdhbCBidWZmZXIgc2xvdCByZWxlYXNlZC4gU28gaSB0aGluayB3ZSBz aG91bGQgc2F5IGl0ICdvY2N1cGllZCcgbm90ICdmdWxsJy4NCg0KTWF5YmU6DQpUb3RhbCBudW1i ZXIgb2YgdGltZXMgV0FMIGRhdGEgd2FzIHdyaXR0ZW4gdG8gdGhlIGRpc2ssIHRvIGNsYWltIHRo ZSBidWZmZXIgcGFnZSB0byBpbnNlcnQgbmV3DQpXQUwgZGF0YSB3aGVuIHRoZSBzcGVjaWFsIFdB TCBidWZmZXIgb2NjdXBpZWQgYnkgb3RoZXIgcGFnZS4NCg0KDQoNClJlZ2FyZHMsDQpIaWdoZ28g U29mdHdhcmUgKENhbmFkYS9DaGluYS9QYWtpc3RhbikgDQpVUkwgOiB3d3cuaGlnaGdvLmNhIA0K RU1BSUw6IG1haWx0bzptb3ZlYWQoZG90KWxpKGF0KWhpZ2hnbyhkb3QpY2ENCg0K ------=_001_NextPart563485238482_=---- Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable