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.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1vQTA2-008G6H-1D
	for pgsql-hackers@arkaria.postgresql.org;
	Tue, 02 Dec 2025 16:23:30 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1vQTA0-008u5C-2B
	for pgsql-hackers@arkaria.postgresql.org;
	Tue, 02 Dec 2025 16:23:28 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <mihailnikalayeu@gmail.com>)
	id 1vQTA0-008u4r-16
	for pgsql-hackers@lists.postgresql.org;
	Tue, 02 Dec 2025 16:23:28 +0000
Received: from mail-lf1-x133.google.com ([2a00:1450:4864:20::133])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <mihailnikalayeu@gmail.com>)
	id 1vQT9y-002mAv-19
	for pgsql-hackers@lists.postgresql.org;
	Tue, 02 Dec 2025 16:23:27 +0000
Received: by mail-lf1-x133.google.com with SMTP id
 2adb3069b0e04-595825c8eb3so5411843e87.0
        for <pgsql-hackers@lists.postgresql.org>;
 Tue, 02 Dec 2025 08:23:27 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1764692605; x=1765297405;
 darn=lists.postgresql.org;
        h=content-transfer-encoding:cc:to:subject:message-id:date:from
         :in-reply-to:references:mime-version:from:to:cc:subject:date
         :message-id:reply-to;
        bh=QKM+n8vlyXV2SwYe0L6Yx24DkISSjGFV4gHOpWJwgwg=;
        b=ZM/9relcT1r9jOM+23MkpSnO41KFF6XxCnq2tBXPjFsP4wXCXX/esujxaqzkvFJqpH
         ovuW79KO6Qix/GqFPz0qQ6vA7TwTOb4meFBfzyE+VR7/dawqBg99RqM6ax2e5J5QmJvN
         DqtHFvIOdUdRMINwmjjBeuG7sb/CY8mnU4ykTuOqKJoskPJH1PzZ3xI14kaLmpAUAasC
         iYorDwTjukw57KsVOm2qsAvYNuAZ6RMXMS01/IvddwTZJRhlPlaTv4GOFuYoIJ+1EGAQ
         ZuZJcSVQjqNOclR0MayWbpdBYSQjGvLF+l7HryxxqRG6FeNAahOaRbwaSvTyN82etTzz
         V+Cw==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1764692605; x=1765297405;
        h=content-transfer-encoding:cc:to:subject:message-id:date:from
         :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from
         :to:cc:subject:date:message-id:reply-to;
        bh=QKM+n8vlyXV2SwYe0L6Yx24DkISSjGFV4gHOpWJwgwg=;
        b=VQkC3oO+5C1/8cWshKtortFaL6Pdr876nUaXJKBq30M/oW34szrCRdSdV55IWqyVnO
         OjyxBvX2G4/XhlkLl9knL6vLcTVb78QOQUBN9npNQ3wVlhfRv2RJLQdPZsC0kFWsKSjs
         QQkhTxAVK02GIrqCc1v3rbBMZYaX8m569Y+LuWGxWQ1tTzRVNVbGGxbUftRs1JW3lj4C
         hD4S+As5AHH9y70wUIrH2cH93uk1n0jodFw/oqvfY9cW3/hLBA89C9xa7pRnH088srEC
         Ns54pcUp+9dZwBt/U2BvTnQzzWZPazQa1m+J3V/yDy2rYqTlFrD3MV6N7ieKcG6PlwdE
         gowQ==
X-Forwarded-Encrypted: i=1;
 AJvYcCUVAl5yctjpqUuaCnM5U+oyRqBkwKqSIZ7PwloQ9w5S5i5Gwd1zSqZbJAyx6343FuI1Zz67BwkiFiW1lqry@lists.postgresql.org
X-Gm-Message-State: AOJu0YxR9iYw3Am5x3tihW5mEdrDBxGWNYzYgGl9TaqX5d86n0wltlA7
	UfZv0XHcxunE21hJrANauHvcWavAT4Px2y5axZTwr/CS0tQZtVFaTLHLHuBZmFK02zmGPyqnJDW
	9Il7xudqTlQ5GIUHDyhhptcKv44RhQ4o=
X-Gm-Gg: ASbGncvlMdLhE8zN6eAhsvXm5B1jdNpYz3Ta1YRn1ijmeemFZFQ6rZZPdVpLT0bkHiL
	uxtQSeeT2z4GhRrmX80zlHzm75y7yIldu/tu6eefksLkXuI8aw7EBxt0msH5BJG5XIhKrJ/Kxhe
	oAYRt1JmTcRg8eBhq9WSJChkvY43XlQYBEZyeUg8D25yUQkQsPSVHJ48IF7MeWiLEG0FfUgG4HZ
	3i+JD2PEnezOKRQGR4uYkAFRN/Lho6fX0qjDa8T5cvclQRCE1vcLHZ5Krs7dg5AWbyBSVt6gokC
	0VU+H2GG7U0heElL/JtY+zUXCUeGKQ==
X-Google-Smtp-Source: 
 AGHT+IE/9/aHuQvR+z9DCQcyjmVzIWMdChzrwtRmbjUNWTxDHcTYfjnCWUx/8JRRpUe4jQQqN96JeyuiT8mwnb6I+iM=
X-Received: by 2002:a05:6512:220f:b0:592:f2fc:51f0 with SMTP id
 2adb3069b0e04-596b5277bd2mr9930921e87.30.1764692605376; Tue, 02 Dec 2025
 08:23:25 -0800 (PST)
MIME-Version: 1.0
References: <202507262156.sb455angijk6@alvherre.pgsql>
 <202510301734.pj4uds3mqxx4@alvherre.pgsql>
 <CADzfLwWdc1KBZ2qNV1x7gmZtHdmAYOoq0A2Rw72O2-wEou=FRg@mail.gmail.com>
 <11472.1762156600@localhost>
 <CADzfLwVtct0_GbtKt8hksR6rX2ozEtKSS4b=YmEOPghHkEE6XQ@mail.gmail.com>
 <21728.1764692097@localhost>
In-Reply-To: <21728.1764692097@localhost>
From: Mihail Nikalayeu <mihailnikalayeu@gmail.com>
Date: Tue, 2 Dec 2025 17:22:47 +0100
X-Gm-Features: AWmQ_bktekR4XkLkq3OYsvRAHTY5PyKwGVBETRNky2AV1s22GY9IbYxoXocAsas
Message-ID: 
 <CADzfLwUEcsn2AyJXNbzy6QaSYeMtpe=-g97ZbH33PmFKLmt+BQ@mail.gmail.com>
Subject: Re: Adding REPACK [concurrently]
To: Antonin Houska <ah@cybertec.at>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>,
	Pg Hackers <pgsql-hackers@lists.postgresql.org>,
 Robert Treat <rob@xzilla.net>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/CADzfLwUEcsn2AyJXNbzy6QaSYeMtpe%3D-g97ZbH33PmFKLmt%2BBQ%40mail.gmail.com>
Precedence: bulk

Hi!

On Tue, Dec 2, 2025 at 5:14=E2=80=AFPM Antonin Houska <ah@cybertec.at> wrot=
e:
> Not sure, cluster.sql already seems to do the same.
I think in the case of CONCURRENTLY it may behave a little bit
different, but not sure.

> I miss the point. The current coding is such that this part
I mean call it periodically in both loops: scan loop and insertion loop.

Best greetings,
Mikhail.