MIME-Version: 1.0
References: <CACG=ezaWg7_nt-8ey4aKv2w9LcuLthHknwCawmBgEeTnJrJTcw@mail.gmail.com>
 <CACG=ezYbYO_KHWdeDedbDcY0tOS0JfaqBxG3=bG5+DdsDK4MpQ@mail.gmail.com>
 <CACG=ezYpZRPwoRCz_h3Qerd3XJNdpTHCpwGbZphNdy26tA4_qQ@mail.gmail.com>
 <36531c0e-292c-409d-bbc7-a252cf6e910a@iki.fi> <54aa8f65-f0e4-4464-b543-e0399c1cab1e@iki.fi>
 <CACG=ezYUJSvnuxntkURNWo_1vZ+AtmcQfqd_h6WgDzGaudfw+Q@mail.gmail.com>
 <4a9dda70-0af7-41a4-9636-b168f2fc48ef@iki.fi> <46cc45e9-fddd-44bc-bcb3-96889aafd921@iki.fi>
 <CAExHW5tUEkiQrvm9hgccjKUNkWBnJ5_HDUrAwiHBTxu+Vuj29Q@mail.gmail.com>
 <6c298bc4-7029-4c1d-bf16-3e094842ce32@iki.fi> <CAExHW5t3kzJiVqmoqCLyGmfkTjD4Rwa27kXH-S_XvHWLkM2fzw@mail.gmail.com>
 <CAExHW5ucnoyjd6p7UVVhQTeV7hc8-vX81ti8f7sU0COqfUWzQg@mail.gmail.com>
 <2c62322e-a0e3-49cd-b369-370718a8efd8@iki.fi> <CAExHW5s_uNeD_xYjdbSR8khMXwWJQOY9Qg=j4T+5KOfGz5-RsQ@mail.gmail.com>
 <3624730d-6dae-42bf-9458-76c4c965fb27@iki.fi> <b7faf07c-7d2c-4f35-8c43-392e057153ef@gmail.com>
 <cbbbb5ae-0219-4c67-a52b-fa03119f6701@iki.fi> <6dc0880b-15fb-42cf-abfc-62d9d80dd287@iki.fi>
In-Reply-To: <6dc0880b-15fb-42cf-abfc-62d9d80dd287@iki.fi>
From: Maxim Orlov <orlovmg@gmail.com>
Date: Fri, 20 Feb 2026 11:47:12 +0300
Message-ID: <CACG=ezbwy1zargXDNPeYXxZwRW3jXu_aD=rcG-7dc4fw7Y9Ojw@mail.gmail.com>
Subject: Re: POC: make mxidoff 64 bits
To: Heikki Linnakangas <hlinnaka@iki.fi>
Cc: Alexander Lakhin <exclusion@gmail.com>, Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>, 
	Alvaro Herrera <alvherre@alvh.no-ip.org>, Alexander Korotkov <aekorotkov@gmail.com>, 
	wenhui qiu <qiuwenhuifx@gmail.com>, 
	Postgres hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/mixed; boundary="000000000000598cd2064b3d788c"
Archived-At: <https://www.postgresql.org/message-id/CACG%3Dezbwy1zargXDNPeYXxZwRW3jXu_aD%3DrcG-7dc4fw7Y9Ojw%40mail.gmail.com>
Precedence: bulk

--000000000000598cd2064b3d788c
Content-Type: multipart/alternative; boundary="000000000000598cd1064b3d788a"

--000000000000598cd1064b3d788a
Content-Type: text/plain; charset="UTF-8"

Just one more minor thing. While working on making CLOG 64-bit, I
noticed that read error messages from SLRU pages were reported only in
32-bit format, with the upper half simply truncated. Here's a small
patch to fix this problem. I used the "%u:%u" format because it is
already used by Postgres for outputting 64-bit transactions.


-- 
Best regards,
Maxim Orlov.

--000000000000598cd1064b3d788a
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><div dir=3D"ltr">Just one more =
minor thing. While working on making CLOG 64-bit, I<br>noticed that read er=
ror messages from SLRU pages were reported only in<br>32-bit format, with t=
he upper half simply truncated. Here&#39;s a small<br>patch to fix this pro=
blem. I used the &quot;%u:%u&quot; format because it is<br>already used by =
Postgres for outputting 64-bit transactions.</div><br><div><br clear=3D"all=
"></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"lt=
r" class=3D"gmail_signature"><div dir=3D"ltr"><div>Best regards,<br></div><=
div>Maxim Orlov.</div></div></div></div>

--000000000000598cd1064b3d788a--
--000000000000598cd2064b3d788c
Content-Type: application/octet-stream; 
	name="v1-0001-Make-SlruReportIOError-accept-64-bit-values.patch"
Content-Disposition: attachment; 
	filename="v1-0001-Make-SlruReportIOError-accept-64-bit-values.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mlun0rno0>
X-Attachment-Id: f_mlun0rno0

RnJvbSAwMjExMmM2ZmFhNjZlZjQ4NGVkOGVmYzUzNzRmN2E4N2VkMjc3MTFiIE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBNYXhpbSBPcmxvdiA8b3Jsb3ZtZ0BnbWFpbC5jb20+CkRhdGU6
IEZyaSwgMjAgRmViIDIwMjYgMTE6MjI6MTggKzAzMDAKU3ViamVjdDogW1BBVENIIHYxXSBNYWtl
IFNscnVSZXBvcnRJT0Vycm9yIGFjY2VwdCA2NC1iaXQgdmFsdWVzCgpFeHBhbmRpbmcgU0xSVSBz
ZWdtZW50IHZhbHVlcyB0byA2NCBiaXRzIHJlcXVpcmVzIGFuIGV4dGVuZGVkIGZvcm1hdApmb3Ig
YW4gZXJyb3Igb3V0cHV0IGluIFNscnVSZXBvcnRJT0Vycm9yLiBQcmV2aW91c2x5LCB0aGUgdmFs
dWVzIHdlcmUKaW1wbGljaXRseSBjb252ZXJ0ZWQgdG8gMzIgYml0cyB3aXRob3V0IHByZXNlcnZp
bmcgdGhlIGVwb2NoLgotLS0KIHNyYy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL3NscnUuYyB8IDMz
ICsrKysrKysrKysrKysrKysrKysrLS0tLS0tLS0tLS0KIHNyYy9pbmNsdWRlL2FjY2Vzcy9zbHJ1
LmggICAgICAgICB8ICAyICstCiAyIGZpbGVzIGNoYW5nZWQsIDIzIGluc2VydGlvbnMoKyksIDEy
IGRlbGV0aW9ucygtKQoKZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL3Ns
cnUuYyBiL3NyYy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL3NscnUuYwppbmRleCA1NDljN2UzZTY0
Yi4uYWI0MDE4Mzg0ZjkgMTAwNjQ0Ci0tLSBhL3NyYy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL3Ns
cnUuYworKysgYi9zcmMvYmFja2VuZC9hY2Nlc3MvdHJhbnNhbS9zbHJ1LmMKQEAgLTE4MSw3ICsx
ODEsNyBAQCBzdGF0aWMgdm9pZCBTbHJ1SW50ZXJuYWxXcml0ZVBhZ2UoU2xydUN0bCBjdGwsIGlu
dCBzbG90bm8sIFNscnVXcml0ZUFsbCBmZGF0YSk7CiBzdGF0aWMgYm9vbCBTbHJ1UGh5c2ljYWxS
ZWFkUGFnZShTbHJ1Q3RsIGN0bCwgaW50NjQgcGFnZW5vLCBpbnQgc2xvdG5vKTsKIHN0YXRpYyBi
b29sIFNscnVQaHlzaWNhbFdyaXRlUGFnZShTbHJ1Q3RsIGN0bCwgaW50NjQgcGFnZW5vLCBpbnQg
c2xvdG5vLAogCQkJCQkJCQkgIFNscnVXcml0ZUFsbCBmZGF0YSk7Ci1zdGF0aWMgdm9pZCBTbHJ1
UmVwb3J0SU9FcnJvcihTbHJ1Q3RsIGN0bCwgaW50NjQgcGFnZW5vLCBUcmFuc2FjdGlvbklkIHhp
ZCk7CitzdGF0aWMgdm9pZCBTbHJ1UmVwb3J0SU9FcnJvcihTbHJ1Q3RsIGN0bCwgaW50NjQgcGFn
ZW5vLCB1aW50NjQgdmFsdWUpOwogc3RhdGljIGludAlTbHJ1U2VsZWN0TFJVUGFnZShTbHJ1Q3Rs
IGN0bCwgaW50NjQgcGFnZW5vKTsKIAogc3RhdGljIGJvb2wgU2xydVNjYW5EaXJDYkRlbGV0ZUN1
dG9mZihTbHJ1Q3RsIGN0bCwgY2hhciAqZmlsZW5hbWUsCkBAIC01MjUsNyArNTI1LDcgQEAgU2lt
cGxlTHJ1V2FpdElPKFNscnVDdGwgY3RsLCBpbnQgc2xvdG5vKQogICovCiBpbnQKIFNpbXBsZUxy
dVJlYWRQYWdlKFNscnVDdGwgY3RsLCBpbnQ2NCBwYWdlbm8sIGJvb2wgd3JpdGVfb2ssCi0JCQkJ
ICBUcmFuc2FjdGlvbklkIHhpZCkKKwkJCQkgIHVpbnQ2NCB4aWQpCiB7CiAJU2xydVNoYXJlZAlz
aGFyZWQgPSBjdGwtPnNoYXJlZDsKIAlMV0xvY2sJICAgKmJhbmtsb2NrID0gU2ltcGxlTHJ1R2V0
QmFua0xvY2soY3RsLCBwYWdlbm8pOwpAQCAtMTA3MCwxMiArMTA3MCwxNSBAQCBTbHJ1UGh5c2lj
YWxXcml0ZVBhZ2UoU2xydUN0bCBjdGwsIGludDY0IHBhZ2VubywgaW50IHNsb3RubywgU2xydVdy
aXRlQWxsIGZkYXRhKQogICogU2xydVBoeXNpY2FsV3JpdGVQYWdlLiAgQ2FsbCB0aGlzIGFmdGVy
IGNsZWFuaW5nIHVwIHNoYXJlZC1tZW1vcnkgc3RhdGUuCiAgKi8KIHN0YXRpYyB2b2lkCi1TbHJ1
UmVwb3J0SU9FcnJvcihTbHJ1Q3RsIGN0bCwgaW50NjQgcGFnZW5vLCBUcmFuc2FjdGlvbklkIHhp
ZCkKK1NscnVSZXBvcnRJT0Vycm9yKFNscnVDdGwgY3RsLCBpbnQ2NCBwYWdlbm8sIHVpbnQ2NCB2
YWx1ZSkKIHsKIAlpbnQ2NAkJc2Vnbm8gPSBwYWdlbm8gLyBTTFJVX1BBR0VTX1BFUl9TRUdNRU5U
OwogCWludAkJCXJwYWdlbm8gPSBwYWdlbm8gJSBTTFJVX1BBR0VTX1BFUl9TRUdNRU5UOwogCWlu
dAkJCW9mZnNldCA9IHJwYWdlbm8gKiBCTENLU1o7CiAJY2hhcgkJcGF0aFtNQVhQR1BBVEhdOwor
CUZ1bGxUcmFuc2FjdGlvbklkCWZ4aWQgPSBGdWxsVHJhbnNhY3Rpb25JZEZyb21VNjQodmFsdWUp
OworCVRyYW5zYWN0aW9uSWQJCXhpZCA9IFhpZEZyb21GdWxsVHJhbnNhY3Rpb25JZChmeGlkKTsK
Kwl1aW50MzIJCQkJZXBvY2ggPSBFcG9jaEZyb21GdWxsVHJhbnNhY3Rpb25JZChmeGlkKTsKIAog
CVNscnVGaWxlTmFtZShjdGwsIHBhdGgsIHNlZ25vKTsKIAllcnJubyA9IHNscnVfZXJybm87CkBA
IC0xMDg0LDEzICsxMDg3LDE1IEBAIFNscnVSZXBvcnRJT0Vycm9yKFNscnVDdGwgY3RsLCBpbnQ2
NCBwYWdlbm8sIFRyYW5zYWN0aW9uSWQgeGlkKQogCQljYXNlIFNMUlVfT1BFTl9GQUlMRUQ6CiAJ
CQllcmVwb3J0KEVSUk9SLAogCQkJCQkoZXJyY29kZV9mb3JfZmlsZV9hY2Nlc3MoKSwKLQkJCQkJ
IGVycm1zZygiY291bGQgbm90IGFjY2VzcyBzdGF0dXMgb2YgdHJhbnNhY3Rpb24gJXUiLCB4aWQp
LAorCQkJCQkgZXJybXNnKCJjb3VsZCBub3QgYWNjZXNzIHN0YXR1cyBvZiB0cmFuc2FjdGlvbiAl
dToldSIsCisJCQkJCQkJZXBvY2gsIHhpZCksCiAJCQkJCSBlcnJkZXRhaWwoIkNvdWxkIG5vdCBv
cGVuIGZpbGUgXCIlc1wiOiAlbS4iLCBwYXRoKSkpOwogCQkJYnJlYWs7CiAJCWNhc2UgU0xSVV9T
RUVLX0ZBSUxFRDoKIAkJCWVyZXBvcnQoRVJST1IsCiAJCQkJCShlcnJjb2RlX2Zvcl9maWxlX2Fj
Y2VzcygpLAotCQkJCQkgZXJybXNnKCJjb3VsZCBub3QgYWNjZXNzIHN0YXR1cyBvZiB0cmFuc2Fj
dGlvbiAldSIsIHhpZCksCisJCQkJCSBlcnJtc2coImNvdWxkIG5vdCBhY2Nlc3Mgc3RhdHVzIG9m
IHRyYW5zYWN0aW9uICV1OiV1IiwKKwkJCQkJCQllcG9jaCwgeGlkKSwKIAkJCQkJIGVycmRldGFp
bCgiQ291bGQgbm90IHNlZWsgaW4gZmlsZSBcIiVzXCIgdG8gb2Zmc2V0ICVkOiAlbS4iLAogCQkJ
CQkJCSAgIHBhdGgsIG9mZnNldCkpKTsKIAkJCWJyZWFrOwpAQCAtMTA5OCwzOCArMTEwMyw0NCBA
QCBTbHJ1UmVwb3J0SU9FcnJvcihTbHJ1Q3RsIGN0bCwgaW50NjQgcGFnZW5vLCBUcmFuc2FjdGlv
bklkIHhpZCkKIAkJCWlmIChlcnJubykKIAkJCQllcmVwb3J0KEVSUk9SLAogCQkJCQkJKGVycmNv
ZGVfZm9yX2ZpbGVfYWNjZXNzKCksCi0JCQkJCQkgZXJybXNnKCJjb3VsZCBub3QgYWNjZXNzIHN0
YXR1cyBvZiB0cmFuc2FjdGlvbiAldSIsIHhpZCksCisJCQkJCQkgZXJybXNnKCJjb3VsZCBub3Qg
YWNjZXNzIHN0YXR1cyBvZiB0cmFuc2FjdGlvbiAldToldSIsCisJCQkJCQkJCWVwb2NoLCB4aWQp
LAogCQkJCQkJIGVycmRldGFpbCgiQ291bGQgbm90IHJlYWQgZnJvbSBmaWxlIFwiJXNcIiBhdCBv
ZmZzZXQgJWQ6ICVtLiIsCiAJCQkJCQkJCSAgIHBhdGgsIG9mZnNldCkpKTsKIAkJCWVsc2UKIAkJ
CQllcmVwb3J0KEVSUk9SLAotCQkJCQkJKGVycm1zZygiY291bGQgbm90IGFjY2VzcyBzdGF0dXMg
b2YgdHJhbnNhY3Rpb24gJXUiLCB4aWQpLAorCQkJCQkJKGVycm1zZygiY291bGQgbm90IGFjY2Vz
cyBzdGF0dXMgb2YgdHJhbnNhY3Rpb24gJXU6JXUiLAorCQkJCQkJCQllcG9jaCwgeGlkKSwKIAkJ
CQkJCSBlcnJkZXRhaWwoIkNvdWxkIG5vdCByZWFkIGZyb20gZmlsZSBcIiVzXCIgYXQgb2Zmc2V0
ICVkOiByZWFkIHRvbyBmZXcgYnl0ZXMuIiwgcGF0aCwgb2Zmc2V0KSkpOwogCQkJYnJlYWs7CiAJ
CWNhc2UgU0xSVV9XUklURV9GQUlMRUQ6CiAJCQlpZiAoZXJybm8pCiAJCQkJZXJlcG9ydChFUlJP
UiwKIAkJCQkJCShlcnJjb2RlX2Zvcl9maWxlX2FjY2VzcygpLAotCQkJCQkJIGVycm1zZygiY291
bGQgbm90IGFjY2VzcyBzdGF0dXMgb2YgdHJhbnNhY3Rpb24gJXUiLCB4aWQpLAorCQkJCQkJIGVy
cm1zZygiY291bGQgbm90IGFjY2VzcyBzdGF0dXMgb2YgdHJhbnNhY3Rpb24gJXU6JXUiLAorCQkJ
CQkJCQllcG9jaCwgeGlkKSwKIAkJCQkJCSBlcnJkZXRhaWwoIkNvdWxkIG5vdCB3cml0ZSB0byBm
aWxlIFwiJXNcIiBhdCBvZmZzZXQgJWQ6ICVtLiIsCiAJCQkJCQkJCSAgIHBhdGgsIG9mZnNldCkp
KTsKIAkJCWVsc2UKIAkJCQllcmVwb3J0KEVSUk9SLAotCQkJCQkJKGVycm1zZygiY291bGQgbm90
IGFjY2VzcyBzdGF0dXMgb2YgdHJhbnNhY3Rpb24gJXUiLCB4aWQpLAorCQkJCQkJKGVycm1zZygi
Y291bGQgbm90IGFjY2VzcyBzdGF0dXMgb2YgdHJhbnNhY3Rpb24gJXU6JXUiLAorCQkJCQkJCQll
cG9jaCwgeGlkKSwKIAkJCQkJCSBlcnJkZXRhaWwoIkNvdWxkIG5vdCB3cml0ZSB0byBmaWxlIFwi
JXNcIiBhdCBvZmZzZXQgJWQ6IHdyb3RlIHRvbyBmZXcgYnl0ZXMuIiwKIAkJCQkJCQkJICAgcGF0
aCwgb2Zmc2V0KSkpOwogCQkJYnJlYWs7CiAJCWNhc2UgU0xSVV9GU1lOQ19GQUlMRUQ6CiAJCQll
cmVwb3J0KGRhdGFfc3luY19lbGV2ZWwoRVJST1IpLAogCQkJCQkoZXJyY29kZV9mb3JfZmlsZV9h
Y2Nlc3MoKSwKLQkJCQkJIGVycm1zZygiY291bGQgbm90IGFjY2VzcyBzdGF0dXMgb2YgdHJhbnNh
Y3Rpb24gJXUiLCB4aWQpLAorCQkJCQkgZXJybXNnKCJjb3VsZCBub3QgYWNjZXNzIHN0YXR1cyBv
ZiB0cmFuc2FjdGlvbiAldToldSIsCisJCQkJCQkJZXBvY2gsIHhpZCksCiAJCQkJCSBlcnJkZXRh
aWwoIkNvdWxkIG5vdCBmc3luYyBmaWxlIFwiJXNcIjogJW0uIiwKIAkJCQkJCQkgICBwYXRoKSkp
OwogCQkJYnJlYWs7CiAJCWNhc2UgU0xSVV9DTE9TRV9GQUlMRUQ6CiAJCQllcmVwb3J0KEVSUk9S
LAogCQkJCQkoZXJyY29kZV9mb3JfZmlsZV9hY2Nlc3MoKSwKLQkJCQkJIGVycm1zZygiY291bGQg
bm90IGFjY2VzcyBzdGF0dXMgb2YgdHJhbnNhY3Rpb24gJXUiLCB4aWQpLAorCQkJCQkgZXJybXNn
KCJjb3VsZCBub3QgYWNjZXNzIHN0YXR1cyBvZiB0cmFuc2FjdGlvbiAldToldSIsCisJCQkJCQkJ
ZXBvY2gsIHhpZCksCiAJCQkJCSBlcnJkZXRhaWwoIkNvdWxkIG5vdCBjbG9zZSBmaWxlIFwiJXNc
IjogJW0uIiwKIAkJCQkJCQkgICBwYXRoKSkpOwogCQkJYnJlYWs7CmRpZmYgLS1naXQgYS9zcmMv
aW5jbHVkZS9hY2Nlc3Mvc2xydS5oIGIvc3JjL2luY2x1ZGUvYWNjZXNzL3NscnUuaAppbmRleCA0
Y2I4ZjQ3OGZjZS4uZWM1YzE5NGU3YWMgMTAwNjQ0Ci0tLSBhL3NyYy9pbmNsdWRlL2FjY2Vzcy9z
bHJ1LmgKKysrIGIvc3JjL2luY2x1ZGUvYWNjZXNzL3NscnUuaApAQCAtMTc0LDcgKzE3NCw3IEBA
IGV4dGVybiB2b2lkIFNpbXBsZUxydUluaXQoU2xydUN0bCBjdGwsIGNvbnN0IGNoYXIgKm5hbWUs
IGludCBuc2xvdHMsIGludCBubHNucywKIGV4dGVybiBpbnQJU2ltcGxlTHJ1WmVyb1BhZ2UoU2xy
dUN0bCBjdGwsIGludDY0IHBhZ2Vubyk7CiBleHRlcm4gdm9pZCBTaW1wbGVMcnVaZXJvQW5kV3Jp
dGVQYWdlKFNscnVDdGwgY3RsLCBpbnQ2NCBwYWdlbm8pOwogZXh0ZXJuIGludAlTaW1wbGVMcnVS
ZWFkUGFnZShTbHJ1Q3RsIGN0bCwgaW50NjQgcGFnZW5vLCBib29sIHdyaXRlX29rLAotCQkJCQkJ
CSAgVHJhbnNhY3Rpb25JZCB4aWQpOworCQkJCQkJCSAgdWludDY0IHhpZCk7CiBleHRlcm4gaW50
CVNpbXBsZUxydVJlYWRQYWdlX1JlYWRPbmx5KFNscnVDdGwgY3RsLCBpbnQ2NCBwYWdlbm8sCiAJ
CQkJCQkJCQkgICBUcmFuc2FjdGlvbklkIHhpZCk7CiBleHRlcm4gdm9pZCBTaW1wbGVMcnVXcml0
ZVBhZ2UoU2xydUN0bCBjdGwsIGludCBzbG90bm8pOwotLSAKMi40My4wCgo=
--000000000000598cd2064b3d788c--