public inbox for [email protected]
help / color / mirror / Atom feedFrom: Heikki Linnakangas <[email protected]>
To: Ashutosh Bapat <[email protected]>
To: Maxim Orlov <[email protected]>
Cc: Alvaro Herrera <[email protected]>
Cc: Alexander Korotkov <[email protected]>
Cc: wenhui qiu <[email protected]>
Cc: Postgres hackers <[email protected]>
Subject: Re: POC: make mxidoff 64 bits
Date: Wed, 3 Dec 2025 21:12:40 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAExHW5s5YN3rEi1JOEaa-7FPdkAYJv_jG67SO28n-On6FW6KAQ@mail.gmail.com>
References: <CACG=ezaWg7_nt-8ey4aKv2w9LcuLthHknwCawmBgEeTnJrJTcw@mail.gmail.com>
<CAGjGUA+BfcWyccNN4=tHsW_E-koRxbg8h8ut6hjvPsHMgmek6w@mail.gmail.com>
<CACG=ezYbYO_KHWdeDedbDcY0tOS0JfaqBxG3=bG5+DdsDK4MpQ@mail.gmail.com>
<CACG=ezYpZRPwoRCz_h3Qerd3XJNdpTHCpwGbZphNdy26tA4_qQ@mail.gmail.com>
<[email protected]>
<[email protected]>
<CACG=ezYUJSvnuxntkURNWo_1vZ+AtmcQfqd_h6WgDzGaudfw+Q@mail.gmail.com>
<[email protected]>
<[email protected]>
<CAExHW5tUEkiQrvm9hgccjKUNkWBnJ5_HDUrAwiHBTxu+Vuj29Q@mail.gmail.com>
<[email protected]>
<CAExHW5t3kzJiVqmoqCLyGmfkTjD4Rwa27kXH-S_XvHWLkM2fzw@mail.gmail.com>
<CAExHW5sg=0f9Tn8hoVM5t7OB3+4kgcRzxZw_Zw2AZ6dZGCTqPg@mail.gmail.com>
<CACG=ezZ1LbA1G+4mQFuDCUbSHdPR3AEzG+frBm_TCQh8-wC8Ng@mail.gmail.com>
<CAExHW5s5YN3rEi1JOEaa-7FPdkAYJv_jG67SO28n-On6FW6KAQ@mail.gmail.com>
On 01/12/2025 14:35, Ashutosh Bapat wrote:
> On Mon, Dec 1, 2025 at 2:23 PM Maxim Orlov <[email protected]> wrote:
>> On Fri, 28 Nov 2025 at 16:17, Ashutosh Bapat <[email protected]> wrote:
>>> An UPDATE waits for FOR SHARE query to finish, and vice versa. In my
>>> experiments I didn't see an UPDATE creating a multi-xact. Why do we
>>> have UPDATEs in the load created by the test? Am I missing something?
>>
>> As far as I remember, this was done on purpose to create different
>> multixact members statuses randomly.
>
> In that case, better to include that in the comments.
I think that was indeed the purpose, but the test should use FOR KEY
SHARE rather than FOR SHARE. Otherwise the UPDATEs don't generate multixids.
- Heikki
view thread (79+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: POC: make mxidoff 64 bits
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox