Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sdQX6-00FR4L-1M for pgsql-hackers@arkaria.postgresql.org; Mon, 12 Aug 2024 08:36:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sdQX4-00EAm2-OA for pgsql-hackers@arkaria.postgresql.org; Mon, 12 Aug 2024 08:36:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with utf8esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sdQX3-00EAlu-Sq for pgsql-hackers@lists.postgresql.org; Mon, 12 Aug 2024 08:36:02 +0000 Received: from out203-205-221-235.mail.qq.com ([203.205.221.235]) by makus.postgresql.org with utf8esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sdQWy-004Jzg-In for pgsql-hackers@lists.postgresql.org; Mon, 12 Aug 2024 08:36:00 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=qq.com; s=s201512; t=1723451746; bh=zw/BmbnklGmJQ+cypthZ8/vEBU4AdhZNZ1arfqrKwSE=; h=From:To:Cc:Subject:Date; b=S3nV+jgUatYZ8UnRME/RvR1mf5yJAP1UHuA998XrohGjFyRIL1GvfJid5+ms3ugKt CDGv5345DVtAAMq+mi0bLlufhbMs2ptqLe8qYNs4A2vBHDm1x5G28geTp01ehVIY18 RJgVlhLnmEFir5qTJEtyTWzHw4/hsu8NXLi9dx4U= X-QQ-FEAT: oHWrrGTW1dC2rQ4SYB6o3zego2AKJXPB X-QQ-SSF: 00000000000000F0000000000000 X-QQ-XMRINFO: MSVp+SPm3vtS1Vd6Y4Mggwc= X-QQ-XMAILINFO: OE1h366RMh4bDckTDQbvzhrv9j1CIKbNCYxn2dNzxF4fBqagbZwfJBgnPkiXf5 Qd7OAS0Iij46X4FK+5/H+elkAp3GyWkAXeykdN8DaiUG2USng9nF5jYDxO4aQokGInxYe+ofozpll PGbFSly6c6zElQSQ7xwiDb+2KF9+0XW5uPKvh7NU1LOprLHbxq3fDihIHEPvOigeQpw/2NiGoDG+M dBPN23qnB4iEnWqEkKDDJkvbh5lIONIl8o/+rRdxxa83P7PPQ7un/MjzW/3tvKSRtWul5WG/9xk1N 3RDlMt2k/lUT1hlt06opwbvbc/TxO5vt5caAIs0QFWIVDnE9wF5//zeDHbEiSXkXd+5dhqC1RId0T TISVC30BOpR8trK17Ea3DNBiCaAoWtuPC/WAAdxLaB8F9u1u1rKTIbdRJR8yaQo1SSY6WEnUyrL/n rNGKKZqehpZIE1L+yqU02itB99MhYuzVUo7jE5qNzFHBclgXGHpo6m6s2PiTtKBuKOEIbvMs1iudw Cj/qfzTx+uv4Pa09xOgn/MsboGndvMW5QxBTIWMprDyXu+bd6Pvt8mLDbArcm9I0THtBRFCYP+2NS MkiD8/mJwlCF2qQd+vxX3LepTVKXzCn6UPrYd/Hk/w+P1oUqvs1ERnw0J4cS3rmdsrLIdIBE8FSRx GYzHaBZ0V/EgcycZIoxDGkd40wn7YoHR5T8JHk4U2N7niu+d0nADCTuznHBL7uYQNBbBUwra/MGUo iKoNxtTobMpxnPOM7mJ13fweVQMKhtbWK8BcjwlLeUnJW6PvqWKNEFu60cXrTJyTeCF8gR6DbGi+W KsHpLmUZ1BCwLjz+yUVMUb2yZa1CmeViXO1jKUCBx6kVc2pxDYfSJOpN8qRK6my+TlSGW2e10QaEV diWuUNPsAYTJd0swq/qJKA4vIiSfvPrEE2WVbyv8rWh9QxwYElUtoBQpntU72L6 X-HAS-ATTACH: no X-QQ-BUSINESS-ORIGIN: 2 X-Originating-IP: 59.42.90.247 X-QQ-STYLE: X-QQ-mid: webmail434t1723451666t6491414 From: "=?ISO-8859-1?B?Y2NhNTUwNw==?=" To: "=?ISO-8859-1?B?QmVydHJhbmQgRHJvdXZvdA==?=" Cc: "=?ISO-8859-1?B?TWljaGFlbCBQYXF1aWVy?=" , "=?ISO-8859-1?B?cGdzcWwtaGFja2Vycw==?=" Subject: Re: Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_66B9C911_120E8330_363A6BD1" Content-Transfer-Encoding: 8Bit Date: Mon, 12 Aug 2024 16:34:25 +0800 X-Priority: 3 Message-ID: X-QQ-MIME: TCMime 1.0 by Tencent X-Mailer: QQMail 2.x X-QQ-Mailer: QQMail 2.x List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. ------=_NextPart_66B9C911_120E8330_363A6BD1 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: base64 SGksDQoNCg0KNCwgNSA9PT0NCg0KDQomZ3Q7IGlmIChTbmFwQnVpbGRDdXJyZW50U3RhdGUo YnVpbGRlcikgPCBTTkFQQlVJTERfQlVJTERJTkdfU05BUFNIT1QgfHwNCiZndDsmbmJzcDsg Jm5ic3A7ICZuYnNwOyhTbmFwQnVpbGRDdXJyZW50U3RhdGUoYnVpbGRlcikgPT0gU05BUEJV SUxEX0JVSUxESU5HX1NOQVBTSE9UICZhbXA7JmFtcDsgaW5mbyAhPSBYTE9HX0hFQVBfSU5Q TEFDRSkgfHwNCiZndDsmbmJzcDsgJm5ic3A7ICZuYnNwO2N0eC0mZ3Q7ZmFzdF9mb3J3YXJk KQ0KJmd0OyZuYnNwOyAmbmJzcDsgJm5ic3A7cmV0dXJuOw0KDQoNCg0KSSB0aGluayBkdXJp bmcgZmFzdCBmb3J3YXJkLCB3ZSBhbHNvIG5lZWQgaGFuZGxlIHRoZSB4bG9nIHRoYXQgbWFy a3MgYSB0cmFuc2FjdGlvbg0KYXMmbmJzcDtjYXRhbG9nIG1vZGlmeWluZywgb3IgdGhlIHNu YXBzaG90IG1pZ2h0IGxvc2Ugc29tZSB0cmFuc2FjdGlvbnM/DQoNCg0KJmd0OyBUaGF0IHdh eSB3ZSdkIHN0aWxsIHJlbHkgb24gd2hhdCdzIGJlaW5nIGRvbmUgaW4gdGhlIFhMT0dfSEVB UF9JTlBMQUNFIGNhc2UNCg0KDQorCQlpZiAoU25hcEJ1aWxkQ3VycmVudFN0YXRlKGJ1aWxk ZXIpICZndDs9IFNOQVBCVUlMRF9CVUlMRElOR19TTkFQU0hPVCkNCisJCXsNCisJCQkvKiBD dXJyZW50bHkgb25seSBYTE9HX0hFQVBfSU5QTEFDRSBtZWFucyBhIGNhdGFsb2cgbW9kaWZ5 aW5nICovDQorCQkJaWYgKGluZm8gPT0gWExPR19IRUFQX0lOUExBQ0UgJmFtcDsmYW1wOyBU cmFuc2FjdGlvbklkSXNWYWxpZCh4aWQpKQ0KKwkJCQlSZW9yZGVyQnVmZmVyWGlkU2V0Q2F0 YWxvZ0NoYW5nZXMoY3R4LSZndDtyZW9yZGVyLCB4aWQsIGJ1Zi0mZ3Q7b3JpZ3B0cik7DQor CQl9DQoNCg0KDQpXZSBvbmx5IGNhbGwmbmJzcDtSZW9yZGVyQnVmZmVyWGlkU2V0Q2F0YWxv Z0NoYW5nZXMoKSBmb3IgdGhlIHhsb2cgdGhhdCBtYXJrcyBhIHRyYW5zYWN0aW9uIGFzJm5i c3A7Y2F0YWxvZw0KbW9kaWZ5aW5nLCBhbmQgd2UgZG9uJ3QgY2FyZSBhYm91dCB0aGUgb3Ro ZXIgc3RlcHMgYmVpbmcgZG9uZSBpbiB0aGUgeGxvZywgc28gSSB0aGluayB0aGUgY3VycmVu dA0KYXBwcm9hY2ggaXMgb2suDQoNCg0KLS0NClJlZ2FyZHMsDQpDaGFuZ0FvIENoZW4= ------=_NextPart_66B9C911_120E8330_363A6BD1 Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: base64 PG1ldGEgaHR0cC1lcXVpdj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0ZXh0L2h0bWw7IGNo YXJzZXQ9R0IxODAzMCI+PGRpdj5IaSw8L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PjQsIDUg PT09PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj48ZGl2PiZndDsgaWYgKFNuYXBCdWlsZEN1 cnJlbnRTdGF0ZShidWlsZGVyKSAmbHQ7IFNOQVBCVUlMRF9CVUlMRElOR19TTkFQU0hPVCB8 fDwvZGl2PjxkaXY+Jmd0OyZuYnNwOyAmbmJzcDsgJm5ic3A7KFNuYXBCdWlsZEN1cnJlbnRT dGF0ZShidWlsZGVyKSA9PSBTTkFQQlVJTERfQlVJTERJTkdfU05BUFNIT1QgJmFtcDsmYW1w OyBpbmZvICE9IFhMT0dfSEVBUF9JTlBMQUNFKSB8fDwvZGl2PjxkaXY+Jmd0OyZuYnNwOyAm bmJzcDsgJm5ic3A7Y3R4LSZndDtmYXN0X2ZvcndhcmQpPC9kaXY+PGRpdj4mZ3Q7Jm5ic3A7 ICZuYnNwOyAmbmJzcDtyZXR1cm47PC9kaXY+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj5J IHRoaW5rIGR1cmluZyBmYXN0IGZvcndhcmQsIHdlIGFsc28gbmVlZCBoYW5kbGUgdGhlIHhs b2cgdGhhdCBtYXJrcyBhIHRyYW5zYWN0aW9uPC9kaXY+PGRpdj5hcyZuYnNwO2NhdGFsb2cg bW9kaWZ5aW5nLCBvciB0aGUgc25hcHNob3QgbWlnaHQgbG9zZSBzb21lIHRyYW5zYWN0aW9u cz88L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PiZndDsgVGhhdCB3YXkgd2UnZCBzdGlsbCBy ZWx5IG9uIHdoYXQncyBiZWluZyBkb25lIGluIHRoZSBYTE9HX0hFQVBfSU5QTEFDRSBjYXNl PC9kaXY+PGRpdj48YnI+PC9kaXY+PGRpdj48ZGl2Pis8c3BhbiBzdHlsZT0id2hpdGUtc3Bh Y2U6cHJlIj4JCTwvc3Bhbj5pZiAoU25hcEJ1aWxkQ3VycmVudFN0YXRlKGJ1aWxkZXIpICZn dDs9IFNOQVBCVUlMRF9CVUlMRElOR19TTkFQU0hPVCk8L2Rpdj48ZGl2Pis8c3BhbiBzdHls ZT0id2hpdGUtc3BhY2U6cHJlIj4JCTwvc3Bhbj57PC9kaXY+PGRpdj4rPHNwYW4gc3R5bGU9 IndoaXRlLXNwYWNlOnByZSI+CQkJPC9zcGFuPi8qIEN1cnJlbnRseSBvbmx5IFhMT0dfSEVB UF9JTlBMQUNFIG1lYW5zIGEgY2F0YWxvZyBtb2RpZnlpbmcgKi88L2Rpdj48ZGl2Pis8c3Bh biBzdHlsZT0id2hpdGUtc3BhY2U6cHJlIj4JCQk8L3NwYW4+aWYgKGluZm8gPT0gWExPR19I RUFQX0lOUExBQ0UgJmFtcDsmYW1wOyBUcmFuc2FjdGlvbklkSXNWYWxpZCh4aWQpKTwvZGl2 PjxkaXY+KzxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmUiPgkJCQk8L3NwYW4+UmVvcmRl ckJ1ZmZlclhpZFNldENhdGFsb2dDaGFuZ2VzKGN0eC0mZ3Q7cmVvcmRlciwgeGlkLCBidWYt Jmd0O29yaWdwdHIpOzwvZGl2PjxkaXY+KzxzcGFuIHN0eWxlPSJ3aGl0ZS1zcGFjZTpwcmUi PgkJPC9zcGFuPn08L2Rpdj48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PldlIG9ubHkgY2Fs bCZuYnNwO1Jlb3JkZXJCdWZmZXJYaWRTZXRDYXRhbG9nQ2hhbmdlcygpIGZvciB0aGUgeGxv ZyB0aGF0IG1hcmtzIGEgdHJhbnNhY3Rpb24gYXMmbmJzcDtjYXRhbG9nPC9kaXY+PGRpdj5t b2RpZnlpbmcsIGFuZCB3ZSBkb24ndCBjYXJlIGFib3V0IHRoZSBvdGhlciBzdGVwcyBiZWlu ZyBkb25lIGluIHRoZSB4bG9nLCBzbyBJIHRoaW5rIHRoZSBjdXJyZW50PC9kaXY+PGRpdj5h cHByb2FjaCBpcyBvay48L2Rpdj48ZGl2Pjxicj48L2Rpdj48ZGl2PjxkaXY+LS08L2Rpdj48 ZGl2PlJlZ2FyZHMsPC9kaXY+PGRpdj5DaGFuZ0FvIENoZW48L2Rpdj48L2Rpdj48ZGl2Pjxk aXY+PC9kaXY+PC9kaXY+ ------=_NextPart_66B9C911_120E8330_363A6BD1--