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 1uzX5d-004bYg-IG for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Sep 2025 09:07:37 +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 1uzX5b-005XMk-Ug for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Sep 2025 09:07:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uzX5b-005XMZ-KB for pgsql-hackers@lists.postgresql.org; Fri, 19 Sep 2025 09:07:35 +0000 Received: from mail-ed1-x531.google.com ([2a00:1450:4864:20::531]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uzX5X-001fci-32 for pgsql-hackers@lists.postgresql.org; Fri, 19 Sep 2025 09:07:35 +0000 Received: by mail-ed1-x531.google.com with SMTP id 4fb4d7f45d1cf-62fc89cd630so534569a12.2 for ; Fri, 19 Sep 2025 02:07:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1758272848; x=1758877648; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=SVpA9G8Hme+hXFS9LxEXRC0267FUzcZZmfPt0w5KJT0=; b=fubXQVZGpcrKEk8lKOVz/btoamHBmefIZmnn1T6dkbeLMiSjUDf3sEaxjl0AUOsAqc ICTYXQeDER0Hr3u8coYf+auLJ1eUQtKSng0d7BU8B7jxFWLgEEXSoCEkio0YHEfo0JMM hLsCyDmcWlcgr+ti88eSt3EaDzcx324WjaEEzwzEfRd0XFF+wttt2/Rkr8vamG9TAt73 Bnc5Cn84cYOsv9WzmfFmupoIw/xTeepQmNlrca6KTkuub50ALU09iFAz3nMdjhClcdzd 7+9nOU1ACeFPxMkXzMOln5rAF+5Ae4XzDYwgIoyfnx+XXQQx7P/M265RAwO9RbFDa0vR FenA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1758272848; x=1758877648; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=SVpA9G8Hme+hXFS9LxEXRC0267FUzcZZmfPt0w5KJT0=; b=pH8at1YctF41AGN27KpYomoR6T8QN6XUq3bdGsHQx788FhKUsKVO29bnkYrVyNiDDn Z/xvu5IGRhhG9pbzmtc997Tu0sXipjrigZiaacYxi1yEQ4g5/T2vu9BVX0HPraA98Sv4 ovIjzxSbbt9W0cM+1WCbLWwAOhJz/eD+1Wsk3C8+vIq17Ep4R6oVhQwrgECtHr/37mRg 80IHupq9CIktAk/vY4y9A7bDsQ2+nE1/BLDV3FtTJRfDetGmu+f94mgS7Pi334WYHl1O c917403afQBEBb1D6euKlkIN5PZHrBeYr7KYRnV2W4hEXXB6YOnEhyAMhqguKpZwQ3jw gfNg== X-Forwarded-Encrypted: i=1; AJvYcCWrpDHkgCW0mMaA73piLK5xB06y/ZqtIBNKa9aYsU8MLrPh385G0kIrpPJrVI8RnsjDvZ36ESpZb762jdY1@lists.postgresql.org X-Gm-Message-State: AOJu0YyL+S0HSSdSesecortDbV2j+lyWl7Z6QnGzoNyX1ZHlzF7bkMkz IG78ExD4vTIDBf4RGdraLxG6mclu32CdyLCZ/9Epj/NWkLBeX2IJRmDlIqE5pl7xn86er/8oDKa iey8BTJB21wwIUEBdvXFlHIzHXkq24e0= X-Gm-Gg: ASbGncvJxHnbsd3HX5kT3ywC9fyKz5wGFUBRQqFgod73vgyEXiQT7nZSregt9CajznQ KYiHnBKbtov9FdsdqDgIaiBlIpDre17A9ngalTP9VqE0PTqzbT9JC1Hpd6/upt7i3vrCIc8+PSo ie8EfL6SR6kulQjwPZ9g9Z/rLyc2pzTspM7XSt89y+H3160PZnv68yRDQRq++SYUEd+hPJTUbI2 MesBQ== X-Google-Smtp-Source: AGHT+IFIvcCwnWtdl5wdzpi1hl4EVF5vzssRvVhToQBQHC2ehlgcb7K6EYqMuWWYju6CxB7v2mhBtUr5ry2eayQ4sdY= X-Received: by 2002:a05:6402:23d4:b0:62f:52b0:ddec with SMTP id 4fb4d7f45d1cf-62fc092bb4amr2101066a12.14.1758272847559; Fri, 19 Sep 2025 02:07:27 -0700 (PDT) MIME-Version: 1.0 References: <4535f3aa-3220-4760-b1f5-2bc91f248e03@iki.fi> <2bc58592-9d74-4af0-bdd1-1a88e8683f7c@iki.fi> <36531c0e-292c-409d-bbc7-a252cf6e910a@iki.fi> In-Reply-To: From: wenhui qiu Date: Fri, 19 Sep 2025 17:07:15 +0800 X-Gm-Features: AS18NWBBYe8LmdLAGR_2XdERFyhPJc_sJ5t93dHDYadI9uHV9kaXBTMEihzkFnM Message-ID: Subject: Re: POC: make mxidoff 64 bits To: Maxim Orlov Cc: Alexander Korotkov , Ashutosh Bapat , Heikki Linnakangas , Postgres hackers Content-Type: multipart/alternative; boundary="0000000000007f3e57063f23ccf8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007f3e57063f23ccf8 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Maxim Thank you for your feedback.I remember this path the primary challenges are in the upgrade section, where we're still debating how to address a few edge cases. Right now, this thread is missing input from core code contributors. Thanks On Fri, Sep 19, 2025 at 12:37=E2=80=AFAM Maxim Orlov wr= ote: > > On Tue, 16 Sept 2025 at 15:12, wenhui qiu wrote: > >> >> Agree +1 , but I have a question: I remember the XID64 patch got split >> into a few threads. How are these threads related? The original one was >> seen as too big a change, so it was broken up after people raised >> concerns. >> > Yeah, you're absolutely correct. This thread is a part of the overall > work on the transition to XID64 in Postgres. As far as I remember, no > one explicitly raised concerns, but it's clear to me that it won't be > committed as one big patch set. > > Here is a WIP patch @ 8191e0c16a for the discussed above issue. > I also had to merge several patches from the previous set, since the > consensus is to use the PRI* format for outputting 64-bit values, and a > separate patch that only changed the format with cast and %llu lost > it's meaning. > > If this option suits everyone, the next step is to add a part related > to the pg_upgrade. > > -- > Best regards, > Maxim Orlov. > --0000000000007f3e57063f23ccf8 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Maxim=C2=A0
=C2=A0 =C2=A0 =C2=A0Thank you for y= our feedback.I remember this path the prim= ary challenges are in the upgrade section, where we're still debating h= ow to address a few edge cases. Right now, this thread is missing input fro= m core code contributors.


Thank= s

On Fri, Sep 19, 2025 at 12:37=E2= =80=AFAM Maxim Orlov <orlovmg@gmail= .com> wrote:

On Tue, 16 Sept 20= 25 at 15:12, wenhui qiu <qiuwenhuifx@gmail.com> wrote:
=
<= div class=3D"gmail_quote">

Agree=C2=A0+1 , but I have a question: I= remember the XID64 patch got split into a few threads. How are these threa= ds related? The original one was seen as too big a change, so it was broken= up after people raised concerns.=C2=A0=C2=A0
=
Yeah, you're absolutely correct. This th= read is a part of the overall
work on the transition to XID64 in Postgre= s. As far as I remember, no
one explicitly raised concerns, but it's= clear to me that it won't be
committed as one big patch set.
Here is a WIP patch @ 8191e0c16a for the discussed above issue.
I also = had to merge several patches from the previous set, since the
consensus = is to use the PRI* format for outputting 64-bit values, and a
separate p= atch that only changed the format with cast and %llu lost
it's meani= ng.

If this option suits everyone, the next step is to add a part re= lated
to the pg_upgrade.
=C2=A0
--
Best regards,
Maxim Orlov.
--0000000000007f3e57063f23ccf8--