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 ) id 1vOhEL-001kRU-2o for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Nov 2025 19:00:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vOhEK-0081sN-1g for pgsql-hackers@arkaria.postgresql.org; Thu, 27 Nov 2025 19:00:36 +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 ) id 1vOhEK-0081sF-0f for pgsql-hackers@lists.postgresql.org; Thu, 27 Nov 2025 19:00:36 +0000 Received: from mail-lj1-x22e.google.com ([2a00:1450:4864:20::22e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vOhEI-001n7v-0U for pgsql-hackers@postgresql.org; Thu, 27 Nov 2025 19:00:35 +0000 Received: by mail-lj1-x22e.google.com with SMTP id 38308e7fff4ca-37b97e59520so7869131fa.2 for ; Thu, 27 Nov 2025 11:00:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1764270033; x=1764874833; darn=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=/VTAPeTbM4Gz540qUTDzHqCAv6uKawoa2nTEHJUdhsI=; b=Z1zCGRPGkQ4fAxLZz9db5Cn2dhkxdliucO/8a/f5UVbzYEiKDIHrWNt4V18Kzh8MlG YsfoHMQEL5MATX4ONmBN990TtFKd2a24DXzGwUOT63rOvGW/MDsKsg+IxB3XNrAsaQWa ngEyp+BxFJ3aM424M3OpqJBNjQq5YKR7+pkkdx49UO/lfxoNMywUlpQOaVdHiV+gXGeU z7BDDS6k+Hr92V2Lz6Q0iv45Fb+eZNec2wqMUIqDdtvGSxd2Fe2nc5m9qgXzkc6EqKk/ nWFU3xviVhC7hdBelYK5NigjOpX6V62ocSUSZq4PVnZM/O0Va4DtszeJVyLPFH8zZIJT 91nA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1764270033; x=1764874833; 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=/VTAPeTbM4Gz540qUTDzHqCAv6uKawoa2nTEHJUdhsI=; b=A5mcOa0uMroczD6DdnmsknWHfruw4B9n9VH78e0ffEaqSaN0O0wfmYjmlLD3yaYi4G k2mxKolBadhHUhJjn7KO3iZ25GzUncTCH7qUKeuxEAhkEVVPUBFUlNUp+A7xq7BW06r4 TdCBLbDK1kAirlvHRZ/+0zyCioHc1C2Ne06Pg4gbIMsrfnRBdvZAF35b55Bo2H3PLIHc qD4R2x34A2xFdxXw6kE1D/Qt2hztFQgNiD5tNktGwp7mNPxahZ8Zl89SPol5Qxf7Axlx NSRcDi+8X32US9Ho7ENPvSXa83PeaW8Bml9aeJXx3UD3Ngn7kHMht0rGQNPfS80Zi+GT v2dw== X-Forwarded-Encrypted: i=1; AJvYcCUFuQ5kTkhRXNnTfYPrZMtkHfep91umMRpR+iFZVvtxX/mXVb/U4TGl5Nj1XOWbRe1ZGPT5GqrjpU9SJ+7/@postgresql.org X-Gm-Message-State: AOJu0YwvBfgdmX4QrTfKweyXTi+8U1EWtMuDpl5ruMINRFzervFT2Fs4 +ibaIMtidBvFmEooearnYj71phcBl3Dak4XLM6m/ZofmQKDNav7qWwZv11W/6iA2sKx4HccOmR9 HaiOtqqgOsLlAhp1bUNmUmqyBarQszDE= X-Gm-Gg: ASbGncv4niom1dNNbq9/Kr56AchJOKa09T/OrVZfzo6DPKLT9ie+nb51PARuvXvFcnY ggTTKyrEPMQgIzhGGY618wzYLXemHofH6/lZCUNuQYt4oNacO3mZeOrtM4orzw0LWl58mXPzx3u 55CEF8h1q946vXYy/m8FgEuY0QlHl7sa0BfYCAzWDAsscT+F5RaG8QXVpmEVUV23BVN6Rf1LP00 rjYGH61DDaTJhmoW/ebFnmKyOr4su8KtuxfPhG+WSaK1iswPYs2hp0pe9LzimUVedOcTw== X-Google-Smtp-Source: AGHT+IEwI/sGEk+SrQx/bpnCyH60gJ7bMaahoWz8jDV7PihbIw3GwffExAwR+cJmrkDd8Y4R9ux52C2eVBb7BpYkwVE= X-Received: by 2002:a05:6512:12c7:b0:594:4e5f:a224 with SMTP id 2adb3069b0e04-596a3edd620mr8917996e87.39.1764270032996; Thu, 27 Nov 2025 11:00:32 -0800 (PST) MIME-Version: 1.0 References: <202505181556.3n6oiowvntyr@alvherre.pgsql> In-Reply-To: From: Mihail Nikalayeu Date: Thu, 27 Nov 2025 19:59:55 +0100 X-Gm-Features: AWmQ_bm3d4YJjD8U4LYxXPVNQzSLhSBVauImDpFjTniQ9gEGAF-ZjOELu8jiH5U Message-ID: Subject: Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements To: Matthias van de Meent Cc: Sergey Sargsyan , =?UTF-8?Q?=C3=81lvaro_Herrera?= , Andres Freund , Michael Paquier , PostgreSQL Hackers , Andrey Borodin , Melanie Plageman Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello, Mathias! On Thu, Nov 27, 2025 at 7:41=E2=80=AFPM Matthias van de Meent wrote: > I'm not sure a complete and common approach is that easy between CIC > and REPACK CONCURRENTLY. Yes, you're right, but I hope something like [0] may work. [0]: https://www.postgresql.org/message-id/CADzfLwXN4NXv8C%2B8GzbMJvRaBkJMs= 838c92CM-6Js-%3DWpi5aRQ%40mail.gmail.com