public inbox for [email protected]
help / color / mirror / Atom feedFrom: Mihail Nikalayeu <[email protected]>
To: Antonin Houska <[email protected]>
Cc: Alvaro Herrera <[email protected]>
Cc: Pg Hackers <[email protected]>
Cc: Robert Treat <[email protected]>
Subject: Re: Adding REPACK [concurrently]
Date: Thu, 15 Jan 2026 20:05:02 +0300
Message-ID: <CADzfLwWQRAqi1EQrKFiTgXJsdz_3ZFAWkto97hsYb-bMcpwuwg@mail.gmail.com> (raw)
In-Reply-To: <35686.1768495019@localhost>
References: <[email protected]>
<11247.1767609087@localhost>
<11558.1767609632@localhost>
<141054.1767891540@localhost>
<CADzfLwU-OmxW3t3AoQo9=K7uq4G1yZ-txcetzW3jbcVxV_pJew@mail.gmail.com>
<137668.1768235610@localhost>
<CADzfLwUJSHKGxYw+vMUZ_Hr2YeuxO2Q5w13HKgUUN1725tjY5Q@mail.gmail.com>
<CADzfLwU78as45To9a=-Qkr5jEg3tMxc5rUtdKy2MTv4r_SDGng@mail.gmail.com>
<35686.1768495019@localhost>
Hello!
Antonin Houska <[email protected]>:
As the test runs pgbench with --client=30 and the default value of
max_worker_processes is 8, I'm not sure this is a leak. I've increased this
parameter I couldn't see the error anymore.
Hm, as far as I remember only single repack may be executed in test
(because of locking on test itself and also REPACK).
At least still feel suspicious.
I agree that this is due to the missing MVCC safety feature. I commented
that
check in the script for now.
I don't think so. In case of non-MVCC safety we should see 0 or correct
sum. But script failed with 490588...
But should see 500500 (if I correctly calculated sum of numbers from 1 to
1000)...
Besides that, I saw some deadlocks. I think this was due to the fact that
multiple rows are updated per transaction, and that the keys are random, so
it
can happen that two transactions try to update the same rows in different
order. I increased the number of rows in the test table to 10000 and don't
see
the deadlocks anymore.
I think better to use min/max in updates to be sure (update lower id first).
This is tricky. I could reproduce the problem on my FreeBSD box a few times,
never on Linux (no idea if the OS makes the difference since HW is also
quite
different, but CI also seemed to fail more often on FreeBSD.)
You may try to play with no_hot parameter in test - maybe it will provide
some clue.
Best regards,
Mikhail.
view thread (31+ 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]
Subject: Re: Adding REPACK [concurrently]
In-Reply-To: <CADzfLwWQRAqi1EQrKFiTgXJsdz_3ZFAWkto97hsYb-bMcpwuwg@mail.gmail.com>
* 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