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 1kTL07-0000Cn-Ss for pgsql-hackers@arkaria.postgresql.org; Fri, 16 Oct 2020 08:22:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kTL05-0004n6-2d for pgsql-hackers@arkaria.postgresql.org; Fri, 16 Oct 2020 08:22:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kTL04-0004mz-Nw for pgsql-hackers@lists.postgresql.org; Fri, 16 Oct 2020 08:22:08 +0000 Received: from sender4-op-o13.zoho.com ([136.143.188.13]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kTL00-000551-CN for pgsql-hackers@postgresql.org; Fri, 16 Oct 2020 08:22:08 +0000 ARC-Seal: i=1; a=rsa-sha256; t=1602836513; cv=none; d=zohomail.com; s=zohoarc; b=IX/e+bgbSdwAxB4uoFoHI1LCJE6RRiocwI227KEwPL3U/ERP5ev+cibExzsgklTTM1h+68AFlpphQxFtO96Oz9fKERB4DtSCnioUdF3dPxN2jNv1DNxnhuc3GAzOn++qXBYVYZ9m0Y+/8+aZQuok+XdDW2danFLw6RImZEgtcdU= ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=zohomail.com; s=zohoarc; t=1602836513; h=Content-Type:Cc:Date:From:MIME-Version:Message-ID:References:Subject:To; bh=Io6SJ5poFngKzgpgK+ALwjKTWrobkJuWL9wEle3Pb/Y=; b=AyH5PCOR6ZCDRJOxFwgikzNoLleo6qGoKlfZNaLZnqZhEsdQQ8Pyk9ddhZ7KoOqGUYTii9tKwhDsWT26SP9AoFmgBicHxjo+7vaSOYc1YHz7UlOFEFckY5qAE0/9FsoM+itfw1nNlEKDMFQguoJ5ZFfklWXiqXc6AHu8wFwKzuM= ARC-Authentication-Results: i=1; mx.zohomail.com; dkim=pass header.i=highgo.ca; spf=pass smtp.mailfrom=movead.li@highgo.ca; dmarc=pass header.from= header.from= DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; t=1602836513; s=zoho; d=highgo.ca; i=movead.li@highgo.ca; h=Date:From:To:Cc:Subject:References:Mime-Version:Message-ID:Content-Type; bh=Io6SJ5poFngKzgpgK+ALwjKTWrobkJuWL9wEle3Pb/Y=; b=gCslPwq/GPfPzO8G802kInbvDxw0Gr3qq446O7m/9ktFx3tU4RZzLucO5oidJN64 2yiOb2a/TRV7OCoM1Xtgt+rfV09HsxK2EuwcLspiztu3HhOMvWaYdB4eH9z8jK8anwu d3tkuSHwwTNw6ggfndMnwhxV7VH6JzveItK39KWs= Received: from lchch (124.133.18.218 [124.133.18.218]) by mx.zohomail.com with SMTPS id 1602836510353627.9753311254996; Fri, 16 Oct 2020 01:21:50 -0700 (PDT) Date: Fri, 16 Oct 2020 16:21:47 +0800 From: "movead.li@highgo.ca" To: Horiguchi Cc: andres , michael , pgsql-hackers , ahsan.hadi Subject: Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump. References: <20201014204613.lxts3w6lc4lsv7zh@alap3.anarazel.de>, <20201015.114443.2231235644531652368.horikyota.ntt@gmail.com>, <2020101512560020200319@highgo.ca>, <20201015.173210.1595235318844221199.horikyota.ntt@gmail.com> X-Priority: 3 X-GUID: F848F46B-1EE1-467D-AAEF-0846DFD5AD1C X-Has-Attach: yes X-Mailer: Foxmail 7.2.16.188[cn] Mime-Version: 1.0 Message-ID: <2020101616214467451338@highgo.ca> Content-Type: multipart/mixed; boundary="----=_001_NextPart485402434310_=----" X-Zoho-Virus-Status: 1 X-ZohoMailClient: External List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. ------=_001_NextPart485402434310_=---- Content-Type: multipart/alternative; boundary="----=_002_NextPart611358342521_=----" ------=_002_NextPart611358342521_=---- Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: base64 VGhhbmtzIGZvciBhbGwgdGhlIHN1Z2dlc3Rpb24sIGFuZCBuZXcgcGF0Y2ggYXR0YWNoZWQuDQoN Cj5BbmRyZXMgc3VnZ2VzdGVkIHRoYXQgd2UgZG9uJ3QgbmVlZCB0aGF0IGRlc2NyaXB0aW9uIHdp dGggcGVyLXJlY29yZA0KPmJhc2lzLiBEbyB5b3UgaGF2ZSBhIHJlYXNvbiB0byBkbyB0aGF0PyAg KEZvciBjbGFyaXR5LCBJJ20gbm90DQo+c3VnZ2VzdGluZyB0aGF0IHlvdSBzaG91bGQgcmV2aW5n IGl0LikNCkkgdGhpbmsgQW5kcmVzIGlzIHNheWluZyBpZiB3ZSBqdXN0IGxvZyBpdCBpbiB4bG9n X2Rlc2MoKSB0aGVuIHdlIGNhbiBub3QgZ2V0DQp0aGUgcmVzdWx0IGZvciAnLS1zdGF0cz1yZWNv cmQnIGNhc2UuIEFuZCB0aGUgcGF0Y2ggc29sdmUgdGhlIHByb2JsZW0uDQoNCj4rIFhMQnl0ZVRv U2VnKHJlY29yZC0+RW5kUmVjUHRyIC0gMSwgZW5kU2VnTm8sIHJlY29yZC0+c2VnY3h0LndzX3Nl Z3NpemUpOw0KPldlIHVzZSBYTEJ5dGVUb1ByZXZTZWcgaW5zdGVhZCBmb3IgdGhpcyBwdXJwb3Nl Lg0KVGhhbmtzIGFuZCBmb2xsb3cgdGhlIHN1Z2dlc3Rpb24uDQoNCj5Zb3UgZm9yZ290IHRvIGFk ZCBhIGNvcnJlY3Rpb24gZm9yIHNob3J0IGhlYWRlcnMuDQpJbmZhY3QsIHdlIG5lZWQgdG8gY29u c2lkZXIgdGhpcyBtYXR0ZXIgd2hlbiB0aGUgcmVtYWluIHNpemUgb2YgYSB3YWwNCnNlZ21lbnQg Y2FuIG5vdCBhZmZvcmQgYSBYTG9nUmVjb3JkIHN0cnVjdCBmb3IgWExPR19TV0lUQ0guIA0KSXQn cyBtZWFuIHRoYXQgaWYgcmVjb3JkLT5SZWFkUmVjUHRyIGlzIG9uIEEgd2FsIHNlZ21lbnQsIHRo ZW4NCnJlY29yZC0+RW5kUmVjUHRyIGlzIG9uIChBKzIpIHdhbCBzZWdtZW50LiBTbyB3ZSBuZWVk IHRvIG1pbnVzDQp0aGUgbG9uZ3BhZ2VoZWFkIHNpemUgb24gKEErMSkgd2FsIHNlZ21lbnQuDQpJ biBteSB0aG91Z2h0IHdlIG5lZWQgbm90IHRvIGNhcmUgdGhlIHNob3J0IGhlYWRlciwgaWYgbXkg dW5kZXJzdGFuZA0KaXMgd3Jvbmc/DQoNCj4rIGlmKFJNX1hMT0dfSUQgPT0gcm1pZCAmJiBYTE9H X1NXSVRDSCA9PSBpbmZvKQ0KPiANCj5XZSBuZWVkIGEgY29tbWVudCBmb3IgdGhlIHNwZWNpYWwg Y29kZSBwYXRoLg0KPldlIGRvbid0IGZvbGxvdyB0aGlzIGtpbmQgb2YgY29udmVuc2lvbi4gUmF0 aGVyIHVzZSAidmFyaWFibGUgPQ0KPmNvbnN0YW50Ii4NCj4rIHsNCj4rIGp1bmtfbGVuID0geGxv Z19zd2l0Y2hfanVua19sZW4ocmVjb3JkKTsNCj4rIHN0YXRzLT5jb3VudF94bG9nX3N3aXRjaCsr Ow0KPisgc3RhdHMtPmp1bmtfc2l6ZSArPSBqdW5rX2xlbjsNCj4gDQo+anVua19sZW4gaXMgdXNl ZCBvbmx5IHRoZSBsYXN0IGxpbmUgYWJvdmUuICBXZSBkb24ndCBuZWVkIHRoYXQNCj50ZW1wb3Jh cnkgdmFyaWFibGUuDQo+IA0KPisgKiBJZiB0aGUgd2FsIHN3aXRjaCByZWNvcmQgc3ByZWFkIG9u IHR3byBzZWdtZW50cywgd2Ugc2hvdWxkIGV4dHJhIG1pbnVzIHRoZQ0KPlRoaXMgY29tbWVudCBp cyBzdGlja2luZyBvdXQgb2YgODAtY29sdW1uIGJvcmRlci4gIEhvd2V2ZXIsIEknbSBub3QNCj5z dXJlIGlmIHdlIGhhdmUgcmVhY2hlZCBhIGNvbmNsdXN0aW9uIGFib3V0IHRoZSB0YXJnZXQgY29u c29sZS13aWR0aC4NCj4rIGluZm8gPSAocmogPDwgNCkgJiB+WExSX0lORk9fTUFTSzsNCj4rIHN3 aXRjaF9qdW5rX2lkID0gIlhMT0cvU1dJVENIX0pVTksiOw0KPisgaWYoIFhMT0dfU1dJVENIID09 IGluZm8gJiYgc3RhdHMtPmNvdW50X3hsb2dfc3dpdGNoID4gMCkNCj4gDQo+VGhpcyBsaW5lIG9y ZGVyIGlzIHN0cmFuZ2UuIEF0IGxlYXN0IHN3aXRjaF9qdW5rX2lkIGlzIHVzZWQgb25seSBpbg0K PnRoZSBpZi10aGVuIGJsb2NrLg0KVGhhbmtzIGFuZCBmb2xsb3cgdGhlIHN1Z2dlc3Rpb25zLg0K DQogDQo+SSdtIG5vdCBjb25maW5kZW50IG9uIHdoaWNoIGlzIGJldHRlciwgYnV0IEkgZmVlbCB0 aGF0IHRoaXMgaXMgbm90IGENCj53b3JrIGZvciBkaXNwbGF5IHNpZGUsIGJ1dCBmb3IgdGhlIHJl Y29yZGVyIHNpZGUgbGlrZSBhdHRhY2hlZC4NClRoZSBwYXRjaCByZWFsbHkgc2VlbXMgbW9yZSBj bGVhcmx5LCBidXQgdGhlIG5ldyAnT1RIRVJTJyBtYXkgY29uZnVzZQ0KdGhlIHVzZXJzIGFuZCB3 ZSBoYXJkIHRvIGhhbmRsZSBpdCB3aXRoICctLXJtZ3I9Uk1HUicgb3B0aW9uLiBTbyBJIGhhdmUN Cm5vdCB1c2UgdGhpcyBkZXNpZ24gaW4gdGhpcyBwYXRjaCwgbGV0J3Mgc2VlIG90aGVyJ3Mgb3Bp bmlvbi4NCg0KPlNvcnJ5IGZvciB0aGUgY29uZnVzaW9uLCBidXQgaXQgd291bGQgYmUgYSBzZXBh cmF0ZSB0b3BpYyBldmVuIGlmIHdlDQo+YXJlIGdvaW5nIHRvIGZpeCB0aGF0Li4NClNvcnJ5LCBJ IHJlbW92ZSB0aGUgY29kZSwgbWFrZSBzZW5zZSB3ZSBzaG91bGQgZGlzY3VzcyBpdCBpbiBhDQpz ZXBhcmF0ZSB0b3BpYy4NCg0KDQoNClJlZ2FyZHMsDQpIaWdoZ28gU29mdHdhcmUgKENhbmFkYS9D aGluYS9QYWtpc3RhbikgDQpVUkwgOiB3d3cuaGlnaGdvLmNhIA0KRU1BSUw6IG1haWx0bzptb3Zl YWQoZG90KWxpKGF0KWhpZ2hnbyhkb3QpY2ENCg== ------=_002_NextPart611358342521_=---- Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable