public inbox for [email protected]
help / color / mirror / Atom feedFrom: Heikki Linnakangas <[email protected]>
To: Alexander Lakhin <[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: Mon, 15 Dec 2025 16:31:13 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <CACG=ezaWg7_nt-8ey4aKv2w9LcuLthHknwCawmBgEeTnJrJTcw@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>
<CAExHW5ucnoyjd6p7UVVhQTeV7hc8-vX81ti8f7sU0COqfUWzQg@mail.gmail.com>
<[email protected]>
<CAExHW5s_uNeD_xYjdbSR8khMXwWJQOY9Qg=j4T+5KOfGz5-RsQ@mail.gmail.com>
<[email protected]>
<[email protected]>
On 15/12/2025 10:00, Alexander Lakhin wrote:
> Hello Heikki,
>
> 09.12.2025 14:00, Heikki Linnakangas wrote:
>> Committed with that and some other minor cleanups. Thanks everyone!
>> This patch has been brewing for a while :-).
>
> I've spotted a couple of failures of new test 007_multixact_conversion at
> buildfarm:
> ...
>
> Thus, it looks like these animals can hit 180 seconds timeout with some
> external factors (concurrent load?) that make them run 2-3 times slower...
Hmm, so it's hitting the timeout while running the multixid generation
workload part of the test. The workload keeps 20 parallel connections
open, using them in a round-robin fashion, and apparently the timeout
spans the whole duration of each connection rather than the individual
queries run on them.
On my laptop with jit_above_cost=0 and jit_optimize_above_cost=1000,
like on those buildfarm animals, the multixid generation workload runs
in under 10 s. I suppose it could be 20x slower on a slow, busy system.
So the straightforward fix is to bump up the timeout.
I'm tempted to force "jit=off" here, as the multixid generation is not
really the thing that's being tested here. It's just used to generate
multixids in the cluster before the upgrade. Then again, the point of
forcing JIT in these buildfarm members is to test JITting as part of
everything else that wasn't originally written as a JIT test.
- 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], [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