MIME-Version: 1.0
References: <CACG=ezaWg7_nt-8ey4aKv2w9LcuLthHknwCawmBgEeTnJrJTcw@mail.gmail.com>
 <ff143b24-a093-40da-9833-d36b83726bdf@iki.fi> <CAGjGUAKO1GCzG5wBMt5RosWo0PatgFpYY=Gjgt77tN2brNe=Bg@mail.gmail.com>
 <CACG=ezYokoiumOFnqUfg_ffHD5s8T+6iHYfzKLfa=QQ-1pNrBg@mail.gmail.com>
 <CACG=ezY9xq73jcX_EjVqx5-f90nbQ9PyhFCTW2fwFCS2wmNiFw@mail.gmail.com>
 <CACG=eza+27CfLBobJJccRhXrA3He6c1irAnoyTtSC1-z9UXLrg@mail.gmail.com>
 <CAPpHfduczcop9s6gKUpLGgFUe2y4ERGMJx6SS6Kp+s-kQPwMjg@mail.gmail.com>
 <CACG=ezbye4g_ERNqE=gBcvQ0YypRaVENhNUu8xrs4PL12UdnUA@mail.gmail.com>
 <CACG=ezaMncd0-BcGHBgsSR2eqHfrz9WznHGLKX8biz6zu-azGw@mail.gmail.com>
 <5ecc35f5-1111-47fc-8a02-36d89490a50d@iki.fi> <CACG=ezb9XTvd3ZmS0y8gUunx_wBBdJO7ou+BfCOnnA5jE-11vg@mail.gmail.com>
 <CACG=ezYFNqGjsxF6Vb2CHF6JzKcjhAFauaFm9js0nu_3Ngcdkw@mail.gmail.com>
 <CAGjGUA+dcV7veaCV1H65vCNsbS++nT8=ho772gDvsXUW9H7eXQ@mail.gmail.com>
 <CACG=ezYThNkf8QsDA-aQfEFEkqn2L=_uUL83z0vJstPRasbZqg@mail.gmail.com>
 <24b3deb6-a732-4256-847a-560f4bf39d59@iki.fi> <CACG=ezYtCatcRODS-ZkwhcxuqBKCuhEsZGBruw=dGCLoepF+ZA@mail.gmail.com>
In-Reply-To: <CACG=ezYtCatcRODS-ZkwhcxuqBKCuhEsZGBruw=dGCLoepF+ZA@mail.gmail.com>
From: Maxim Orlov <orlovmg@gmail.com>
Date: Fri, 15 Nov 2024 11:41:46 +0300
Message-ID: <CACG=ezac431kXL+9jfUJSD6u15Ybmfzvq0Pf7nP51b3D_uc73g@mail.gmail.com>
Subject: Re: POC: make mxidoff 64 bits
To: Heikki Linnakangas <hlinnaka@iki.fi>
Cc: wenhui qiu <qiuwenhuifx@gmail.com>, Alexander Korotkov <aekorotkov@gmail.com>, 
	Postgres hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/mixed; boundary="0000000000004115440626ef8a3d"
Archived-At: <https://www.postgresql.org/message-id/CACG%3Dezac431kXL%2B9jfUJSD6u15Ybmfzvq0Pf7nP51b3D_uc73g%40mail.gmail.com>
Precedence: bulk

--0000000000004115440626ef8a3d
Content-Type: multipart/alternative; boundary="0000000000004115420626ef8a3b"

--0000000000004115420626ef8a3b
Content-Type: text/plain; charset="UTF-8"

Here is the test scripts.
The generate.sh script is used to generate data dir with multimple clusters
in it. This script will call multixids.py in order to generate data. If you
are not use system psql consider using LD_LIBRARY_PATH env to specify path
to the lib directory.
OLDBIN=/.../pgsql-new ./generate.sh

Then the test.sh is used to run various upgrades.
OLDBIN=/.../pgsql-old NEWBIN=/.../pgsql-new ./test.sh

I hope that helps!

-- 
Best regards,
Maxim Orlov.

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

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><div>Here is the test scripts. =
<br></div><div>The generate.sh script is used to generate data dir with mul=
timple clusters in it. This script will call multixids.py in order to gener=
ate data. If you are not use system psql consider using LD_LIBRARY_PATH env=
 to specify path to the lib directory.<br></div><div>OLDBIN=3D/.../pgsql-ne=
w ./generate.sh</div><br><div class=3D"gmail_quote">Then the test.sh is use=
d to run various upgrades.=C2=A0</div><div class=3D"gmail_quote">OLDBIN=3D/=
.../pgsql-old NEWBIN=3D/.../pgsql-new ./test.sh</div><div class=3D"gmail_qu=
ote"><br></div><div class=3D"gmail_quote">I hope that helps!<br></div><br><=
span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=
=3D"gmail_signature"><div dir=3D"ltr"><div>Best regards,<br></div><div>Maxi=
m Orlov.</div></div></div></div>

--0000000000004115420626ef8a3b--
--0000000000004115440626ef8a3d
Content-Type: text/x-python-script; charset="US-ASCII"; name="multixids.py"
Content-Disposition: attachment; filename="multixids.py"
Content-Transfer-Encoding: base64
Content-ID: <f_m3ihdva11>
X-Attachment-Id: f_m3ihdva11

IyEvdXNyL2Jpbi9lbnYgcHl0aG9uMwoKaW1wb3J0IHN5czsKaW1wb3J0IHRocmVhZGluZzsKaW1w
b3J0IHBzeWNvcGcyOwoKZGVmIHRlc3RfbXVsdGl4YWN0KHRibG5hbWU6IHN0cik6CiAgICB3aXRo
IHBzeWNvcGcyLmNvbm5lY3QoZGJuYW1lPSJwb3N0Z3JlcyIpIGFzIGNvbm46CiAgICAgICAgY3Vy
ID0gY29ubi5jdXJzb3IoKQogICAgICAgIGN1ci5leGVjdXRlKAogICAgICAgICAgICBmIiIiCiAg
ICAgICAgICAgIERST1AgVEFCTEUgSUYgRVhJU1RTIHt0YmxuYW1lfTsKICAgICAgICAgICAgQ1JF
QVRFIFRBQkxFIHt0YmxuYW1lfShpIGludCBwcmltYXJ5IGtleSwgbl91cGRhdGVkIGludCkgV0lU
SCAoYXV0b3ZhY3V1bV9lbmFibGVkPWZhbHNlKTsKICAgICAgICAgICAgSU5TRVJUIElOVE8ge3Ri
bG5hbWV9IHNlbGVjdCBnLCAwIGZyb20gZ2VuZXJhdGVfc2VyaWVzKDEsIDUwKSBnOwogICAgICAg
ICAgICAiIiIKICAgICAgICApCgogICAgIyBMb2NrIGVudHJpZXMgdXNpbmcgcGFyYWxsZWwgY29u
bmVjdGlvbnMgaW4gYSByb3VuZC1yb2JpbiBmYXNoaW9uLgogICAgbmNsaWVudHMgPSA1MAogICAg
dXBkYXRlX2V2ZXJ5ID0gOTcKICAgIGNvbm5lY3Rpb25zID0gW10KICAgIGZvciBfIGluIHJhbmdl
KG5jbGllbnRzKToKICAgICAgICAjIERvIG5vdCB0dXJuIG9uIGF1dG9jb21taXQuIFdlIHdhbnQg
dG8gaG9sZCB0aGUga2V5LXNoYXJlIGxvY2tzLgogICAgICAgIGNvbm4gPSBwc3ljb3BnMi5jb25u
ZWN0KGRibmFtZT0icG9zdGdyZXMiKQogICAgICAgIGNvbm5lY3Rpb25zLmFwcGVuZChjb25uKQoK
ICAgICMgT24gZWFjaCBpdGVyYXRpb24sIHdlIGNvbW1pdCB0aGUgcHJldmlvdXMgdHJhbnNhY3Rp
b24gb24gYSBjb25uZWN0aW9uLAogICAgIyBhbmQgaXNzdWUgYW5vdGhlciBzZWxlY3QuIEVhY2gg
U0VMRUNUIGdlbmVyYXRlcyBhIG5ldyBtdWx0aXhhY3QgdGhhdAogICAgIyBpbmNsdWRlcyB0aGUg
bmV3IFhJRCwgYW5kIHRoZSBYSURzIG9mIGFsbCB0aGUgb3RoZXIgcGFyYWxsZWwgdHJhbnNhY3Rp
b25zLgogICAgIyBUaGlzIGdlbmVyYXRlcyBlbm91Z2ggdHJhZmZpYyBvbiBib3RoIG11bHRpeGFj
dCBvZmZzZXRzIGFuZCBtZW1iZXJzIFNMUlVzCiAgICAjIHRvIGNyb3NzIHBhZ2UgYm91bmRhcmll
cy4KICAgIGZvciBpIGluIHJhbmdlKDIwMDAwKToKICAgICAgICBjb25uID0gY29ubmVjdGlvbnNb
aSAlIG5jbGllbnRzXQogICAgICAgIGNvbm4uY29tbWl0KCkKCiAgICAgICAgIyBQZXJmb3JtIHNv
bWUgbm9uLWtleSBVUERBVEVzIHRvbywgdG8gZXhlcmNpc2UgZGlmZmVyZW50IG11bHRpeGFjdAog
ICAgICAgICMgbWVtYmVyIHN0YXR1c2VzLgogICAgICAgIGlmIGkgJSB1cGRhdGVfZXZlcnkgPT0g
MDoKICAgICAgICAgICAgY29ubi5jdXJzb3IoKS5leGVjdXRlKGYidXBkYXRlIHt0YmxuYW1lfSBz
ZXQgbl91cGRhdGVkID0gbl91cGRhdGVkICsgMSB3aGVyZSBpID0ge2kgJSA1MH0iKQogICAgICAg
IGVsc2U6CiAgICAgICAgICAgIGNvbm4uY3Vyc29yKCkuZXhlY3V0ZShmInNlbGVjdCAqIGZyb20g
e3RibG5hbWV9IGZvciBrZXkgc2hhcmUiKQoKdGVzdF9tdWx0aXhhY3Qoc3lzLmFyZ3ZbMV0pCg==
--0000000000004115440626ef8a3d
Content-Type: application/x-sh; name="generate.sh"
Content-Disposition: attachment; filename="generate.sh"
Content-Transfer-Encoding: base64
Content-ID: <f_m3ihdv9k0>
X-Attachment-Id: f_m3ihdv9k0

IyEvYmluL3NoCiMKIyBHZW5lcmF0ZSB2YXJpdW9zIGNvbWJpbmF0aW9ucyBvZiBtZW1iZXJzL29m
ZnNldHMgc2VnbWVudHMuCiMKCmlmIFsgLXogIiRPTERCSU4iIF0KdGhlbgoJZWNobyAiU2V0IGVu
diBPTERCSU4gdG8gZ2VuZXJhdGUgY2x1c3RlcnMgZGF0YS4iCmZpCgpUUkc9YHB3ZGAvZGF0YQpl
Y2hvICJVc2Ugb3V0cHV0IGRpcjogJFRSRyIKCnJtIC1yZiAkVFJHCgojIHNpbXBsZSwgZGVmYXVs
dCB2YWx1ZXMKREFUQT0kVFJHL3NpbXBsZQokT0xEQklOL2Jpbi9pbml0ZGIgLS1uby1pbnN0cnVj
dGlvbnMgLUQgJERBVEEKJE9MREJJTi9iaW4vcGdfY3RsIC1EICREQVRBIC1sICREQVRBL2xvZ2Zp
bGUgc3RhcnQKCnB5dGhvbjMgbXVsdGl4aWRzLnB5IEZPTwpweXRob24zIG11bHRpeGlkcy5weSBC
QVIKcHl0aG9uMyBtdWx0aXhpZHMucHkgQkFaCnB5dGhvbjMgbXVsdGl4aWRzLnB5IFFVWAoKJE9M
REJJTi9iaW4vcGdfY3RsIC1EICREQVRBIHN0b3AKCiMgb2Zmc2V0IHdyYXAKREFUQT0kVFJHL29m
ZnNldC13cmFwCiRPTERCSU4vYmluL2luaXRkYiAtLW5vLWluc3RydWN0aW9ucyAtRCAkREFUQQok
T0xEQklOL2Jpbi9wZ19yZXNldHdhbCAtTyAweEZGRkFFMDA3IC1EICREQVRBCmRkIGlmPS9kZXYv
emVybyBvZj0kREFUQS9wZ19tdWx0aXhhY3QvbWVtYmVycy8xNDA3MSBicz04MTkyIGNvdW50PTMy
CiRPTERCSU4vYmluL3BnX2N0bCAtRCAkREFUQSAtbCAkREFUQS9sb2dmaWxlIHN0YXJ0IHx8IGV4
aXQgMQoKcHl0aG9uMyBtdWx0aXhpZHMucHkgRk9PCnB5dGhvbjMgbXVsdGl4aWRzLnB5IEJBUgpw
eXRob24zIG11bHRpeGlkcy5weSBCQVoKcHl0aG9uMyBtdWx0aXhpZHMucHkgUVVYCgokT0xEQklO
L2Jpbi9wZ19jdGwgLUQgJERBVEEgc3RvcAoKIyBtdWx0aSB3cmFwCkRBVEE9JFRSRy9tdWx0aS13
cmFwCiRPTERCSU4vYmluL2luaXRkYiAtLW5vLWluc3RydWN0aW9ucyAtRCAkREFUQQokT0xEQklO
L2Jpbi9wZ19yZXNldHdhbCAtbSAweEZGRkVGOTIxLDB4RkZGRUY5MjAgLUQgJERBVEEKZGQgaWY9
L2Rldi96ZXJvIG9mPSREQVRBL3BnX211bHRpeGFjdC9vZmZzZXRzL0ZGRkUgYnM9ODE5MiBjb3Vu
dD0zMgokT0xEQklOL2Jpbi9wZ19jdGwgLUQgJERBVEEgLWwgJERBVEEvbG9nZmlsZSBzdGFydCB8
fCBleGl0IDEKCnB5dGhvbjMgbXVsdGl4aWRzLnB5IEZPTwpweXRob24zIG11bHRpeGlkcy5weSBC
QVIKcHl0aG9uMyBtdWx0aXhpZHMucHkgQkFaCnB5dGhvbjMgbXVsdGl4aWRzLnB5IFFVWApweXRo
b24zIG11bHRpeGlkcy5weSBYVVEKCiRPTERCSU4vYmluL3BnX2N0bCAtRCAkREFUQSBzdG9wCgoj
IG9mZnNldCBhbmQgbXVsdGkgd3JhcApEQVRBPSRUUkcvb2Zmc2V0LW11bHRpLXdyYXAKJE9MREJJ
Ti9iaW4vaW5pdGRiIC0tbm8taW5zdHJ1Y3Rpb25zIC1EICREQVRBCiRPTERCSU4vYmluL3BnX3Jl
c2V0d2FsIC1tIDB4RkZGRUY5MjEsMHhGRkZFRjkyMCAtTyAweEZGRkFFMDA3IC1EICREQVRBCmRk
IGlmPS9kZXYvemVybyBvZj0kREFUQS9wZ19tdWx0aXhhY3QvbWVtYmVycy8xNDA3MSBicz04MTky
IGNvdW50PTMyCmRkIGlmPS9kZXYvemVybyBvZj0kREFUQS9wZ19tdWx0aXhhY3Qvb2Zmc2V0cy9G
RkZFIGJzPTgxOTIgY291bnQ9MzIKJE9MREJJTi9iaW4vcGdfY3RsIC1EICREQVRBIC1sICREQVRB
L2xvZ2ZpbGUgc3RhcnQgfHwgZXhpdCAxCgojIGZpeHVwIGRiClNRTD0idXBkYXRlIHBnX2RhdGFi
YXNlIHNldApkYXRtaW5teGlkPSc0Mjk0OTAwMDAxJwp3aGVyZSBkYXRuYW1lPSd0ZW1wbGF0ZTAn
IgokT0xEQklOL2Jpbi9wc3FsIC1jIiRTUUwiIHBvc3RncmVzCiRPTERCSU4vYmluL3ZhY3V1bWRi
IC1hIC1GIC0tZGlzYWJsZS1wYWdlLXNraXBwaW5nIAoKcHl0aG9uMyBtdWx0aXhpZHMucHkgRk9P
CnB5dGhvbjMgbXVsdGl4aWRzLnB5IEJBUgpweXRob24zIG11bHRpeGlkcy5weSBCQVoKcHl0aG9u
MyBtdWx0aXhpZHMucHkgUVVYCgokT0xEQklOL2Jpbi9wZ19jdGwgLUQgJERBVEEgc3RvcAo=
--0000000000004115440626ef8a3d
Content-Type: application/x-sh; name="test.sh"
Content-Disposition: attachment; filename="test.sh"
Content-Transfer-Encoding: base64
Content-ID: <f_m3ihdva72>
X-Attachment-Id: f_m3ihdva72

IyEvYmluL3NoCgppZiBbIC16ICIkT0xEQklOIiBdCnRoZW4KCWVjaG8gIlNldCBlbnYgT0xEQklO
LiIKZmkKCmlmIFsgLXogIiRORVdCSU4iIF0KdGhlbgoJZWNobyAiU2V0IGVudiBORVdCSU4uIgpm
aQoKVFJHPWBwd2RgL2RhdGEKZWNobyAiVXNlIG91dHB1dCBkaXI6ICRUUkciCgpkb191cGdyYWRl
KCkKewoJT0xEX0ZPTz0ib2xkLWZvby50bXAiCglPTERfQkFSPSJvbGQtYmFyLnRtcCIKCU9MRF9C
QVo9Im9sZC1iYXoudG1wIgoJTkVXX0ZPTz0ibmV3LWZvby50bXAiCglORVdfQkFSPSJuZXctYmFy
LnRtcCIKCU5FV19CQVo9Im5ldy1iYXoudG1wIgoJJE9MREJJTi9iaW4vcGdfY3RsIC1EICREQVRB
IC1sICREQVRBL2xvZ2ZpbGUgc3RhcnQKCSRPTERCSU4vYmluL3BzcWwgLWMgIlNFTEVDVCAqIEZS
T00gRk9PIiBwb3N0Z3JlcyA+ICRPTERfRk9PCgkkT0xEQklOL2Jpbi9wc3FsIC1jICJTRUxFQ1Qg
KiBGUk9NIEJBUiIgcG9zdGdyZXMgPiAkT0xEX0JBUgoJJE9MREJJTi9iaW4vcHNxbCAtYyAiU0VM
RUNUICogRlJPTSBCQVoiIHBvc3RncmVzID4gJE9MRF9CQVoKCSRPTERCSU4vYmluL3BnX2N0bCAt
RCAkREFUQSBzdG9wCgoJJE5FV0JJTi9iaW4vaW5pdGRiIC0tbm8taW5zdHJ1Y3Rpb25zIC1EICRO
RVdEQVRBCgkkTkVXQklOL2Jpbi9wZ191cGdyYWRlCQkJCVwKCQktZCAkREFUQSAtRCAkTkVXREFU
QQkJCVwKCQktYiAkT0xEQklOL2JpbiAtQiAkTkVXQklOL2JpbglcCgkJLS1jb3B5CgkkTkVXQklO
L2Jpbi9wZ19jdGwgLUQgJE5FV0RBVEEgLWwgJE5FV0RBVEEvbG9nZmlsZSBzdGFydCB8fCBleGl0
IDEKCSRORVdCSU4vYmluL3BzcWwgLWMgIlNFTEVDVCAqIEZST00gRk9PIiBwb3N0Z3JlcyA+ICRO
RVdfRk9PIHx8IGV4aXQgMQoJJE5FV0JJTi9iaW4vcHNxbCAtYyAiU0VMRUNUICogRlJPTSBCQVIi
IHBvc3RncmVzID4gJE5FV19CQVIgfHwgZXhpdCAxCgkkTkVXQklOL2Jpbi9wc3FsIC1jICJTRUxF
Q1QgKiBGUk9NIEJBWiIgcG9zdGdyZXMgPiAkTkVXX0JBWiB8fCBleGl0IDEKCSRORVdCSU4vYmlu
L3BnX2N0bCAtRCAkTkVXREFUQSBzdG9wCgoJaWYgISBkaWZmIC0tc3VwcHJlc3MtY29tbW9uLWxp
bmVzICRPTERfRk9PICRORVdfRk9PCgl0aGVuCgkJZWNobyAiPj4+IEZBSUwgLSBGT08gPDw8IgoJ
CWV4aXQgMQoJZmkKCglpZiAhIGRpZmYgLS1zdXBwcmVzcy1jb21tb24tbGluZXMgJE9MRF9CQVIg
JE5FV19CQVIKCXRoZW4KCQllY2hvICI+Pj4gRkFJTCAtIEJBUiA8PDwiCgkJZXhpdCAxCglmaQoK
CWlmICEgZGlmZiAtLXN1cHByZXNzLWNvbW1vbi1saW5lcyAkT0xEX0JBWiAkTkVXX0JBWgoJdGhl
bgoJCWVjaG8gIj4+PiBGQUlMIC0gQkFaIDw8PCIKCQlleGl0IDEKCWZpCglybSAkT0xEX0ZPTyAk
T0xEX0JBUiAkT0xEX0JBWiAkTkVXX0ZPTyAkTkVXX0JBUiAkTkVXX0JBWgp9CgojIHNpbXBsZQpE
QVRBPSRUUkcvc2ltcGxlCk5FV0RBVEE9JFRSRy9zaW1wbGUtbmV3CnJtIC1mIC1SICRORVdEQVRB
CmRvX3VwZ3JhZGUKCiMgb2Zmc2V0IHdyYXAKREFUQT0kVFJHL29mZnNldC13cmFwCk5FV0RBVEE9
JFRSRy9vZmZzZXQtd3JhcC1uZXcKcm0gLWYgLVIgJE5FV0RBVEEKZG9fdXBncmFkZQoKIyBtdWx0
aSB3cmFwCkRBVEE9JFRSRy9tdWx0aS13cmFwCk5FV0RBVEE9JFRSRy9tdWx0aS13cmFwLW5ldwpy
bSAtZiAtUiAkTkVXREFUQQpkb191cGdyYWRlCgojIG9mZnNldCBhbmQgbXVsdGkgd3JhcApEQVRB
PSRUUkcvb2Zmc2V0LW11bHRpLXdyYXAKTkVXREFUQT0kVFJHL29mZnNldC1tdWx0aS13cmFwLW5l
dwpybSAtZiAtUiAkTkVXREFUQQpkb191cGdyYWRlCgplY2hvICI+Pj4gU1VDQ0VTUyA8PDwiCg==
--0000000000004115440626ef8a3d--