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.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1uRqNG-00HDOR-SI
	for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Jun 2025 10:50:34 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1uRqND-000hX4-L9
	for pgsql-hackers@arkaria.postgresql.org; Wed, 18 Jun 2025 10:50:32 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <mihailnikalayeu@gmail.com>)
	id 1uRqND-000hWw-B2
	for pgsql-hackers@lists.postgresql.org; Wed, 18 Jun 2025 10:50:31 +0000
Received: from mail-vk1-xa2f.google.com ([2607:f8b0:4864:20::a2f])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <mihailnikalayeu@gmail.com>)
	id 1uRqNB-002kXf-1k
	for pgsql-hackers@postgresql.org;
	Wed, 18 Jun 2025 10:50:31 +0000
Received: by mail-vk1-xa2f.google.com with SMTP id
 71dfb90a1353d-52d9a275c27so4531037e0c.0
        for <pgsql-hackers@postgresql.org>;
 Wed, 18 Jun 2025 03:50:29 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1750243828; x=1750848628;
 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=qEnxplZsm+PHfhx1NA1iNWzdvtqT5YPkm5l0N5KxiUM=;
        b=O+LFhDlIMUNoeZNr04WmsLdv20qaxvSSAnQUBBWI4iJj33Iv3FQ+oLZoXxT33bk9/W
         sVg4X9ljGecvLas6XXmSveImYZ3fzajkI0YGg/MsU7zEw3Ci40cIUERfL0JIGWvz6a7w
         fxOUY5oSeS5gUZIMiX4NpKOdiAZ12dn8wO667PdJhTfcRpbEW0I+ch1WEcKV+YSqh7Yx
         lHOndiZam3svQ1r9cKblG9mHCND7f5FIAzyLUKGLRdOcsYpUZlCaWT9/j9at6wfTBCXt
         8Zz/CU5GHr2lmAZPNjL5OIs3nJ7knB23RdUf4tw9iWR/IG6T3iWgjrxsMMEoXtzVa1+G
         mwpA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1750243828; x=1750848628;
        h=content-transfer-encoding:cc:to:subject:message-id:date:from
         :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc
         :subject:date:message-id:reply-to;
        bh=qEnxplZsm+PHfhx1NA1iNWzdvtqT5YPkm5l0N5KxiUM=;
        b=Jrgh0+S4hLPZv8BybAngHc90EYWciTLENvsJzi7EQbscm4hqIDiZTEskPZVoywz8t/
         Aidr9ANe6dEkC2WSDk2A+DWwJ8wJoDKt7JFadmqXoUMwcDRq1pOw5CuH3+m30v7mX+0s
         skjmWjPtup0F1/v2Kp1qx0p28+N61HC3bLVidxvpSfqPdLzL8KvLrWQEwjeVmLkkCOzu
         l2vDWxORqSJNWb9oMpcXwISjmb+nBPj1sWiPNTbkGNWhMCuigvlr+ilKZObXHmQMEZG5
         9YAL3GXdh04ye1JNuE/V4igYPYBqWYT/PKlW/iuqALUPrlKl6susSLZtjzKAiNg/Mjmm
         /dtA==
X-Forwarded-Encrypted: i=1;
 AJvYcCUBdK5aTZjRokIYVtJ8Em7VQNayL9c3G9Iv4kP8nc7bSTDGXBTVdos1NrQDcVAhRMPh5DXAEPertrR1Eoyt@postgresql.org
X-Gm-Message-State: AOJu0YzwWwLJl0DfnXaS/EZ6RswRzJr4tPVViuDvsdd9mqxQmy9boS/0
	xDoC5d1soj6V/pHdAFsc/0T19ukhHAXBwzXDDWFCNvoEZ9wo3N3YvJR8JiVJFh024MRFCUjEMxG
	Zy1uegXhS5RQaxXnnrEOIC7gJMUO5qwM=
X-Gm-Gg: ASbGnctu0bmyaUHs1vvB7FKdg4iRD0I7F/fx576QWffuuKqx/XlzixTvAEDHWN2GJ0g
	hl7RL6A9lSLZlk3LQdSUx77cRtU/zQil0k5pHLHdGoUvRUGV0EsDeiMIvmo4sIAyJR6UD34BaOA
	iBE3u9XjPbCWrUF8M0zrp2yS386xvEd93RE9x8G/NWZJQY2VQeknEHiJxNDdEfI+HTMF6xu/8nk
	8I7U4k5RjGH0Goq
X-Google-Smtp-Source: 
 AGHT+IGhsxFH2YatGMClD9TfMMW72ly7CWip5yUBLq9yUqeGInYE0HhXPLrZYbKqa5fZzTAbj0IAww7ePLTOQDCa5NE=
X-Received: by 2002:a05:6122:8c27:b0:52f:4776:f6a7 with SMTP id
 71dfb90a1353d-53149042961mr11015786e0c.0.1750243827907; Wed, 18 Jun 2025
 03:50:27 -0700 (PDT)
MIME-Version: 1.0
References: 
 <CADzfLwW9QczZW-E=McxcjUv0e5VMDctQNETbgao0K-SimVhFPA@mail.gmail.com>
 <202505181556.3n6oiowvntyr@alvherre.pgsql>
 <CADzfLwXKtriMnfCNVGNH2ahwXaByjo-QOMWiDTU-9WZqh+zQ5g@mail.gmail.com>
 <CADzfLwW5bDWSxjHK7mqX8Lewki3+5FBydBC+nVcxg4xMGKscyw@mail.gmail.com>
 <CAMAof6-4xaV3QE2ErYJaJhu6qjFn99sWyo_HQeBhHikZM3GexA@mail.gmail.com>
 <CADzfLwXocKhpW3eFP1oScz+m+1XJ3bpi9QmVpoqC9RX9oyX=UA@mail.gmail.com>
 <CAMAof695VA+mbVRhWCTus=E0WnsMAQyqXxfOTohbcb7VUHSP4g@mail.gmail.com>
 <CAMAof69JSL8MYWG2qRScs3RQDpfcyZT_wFwW4SoAvftW+K_p1g@mail.gmail.com>
In-Reply-To: 
 <CAMAof69JSL8MYWG2qRScs3RQDpfcyZT_wFwW4SoAvftW+K_p1g@mail.gmail.com>
From: Mihail Nikalayeu <mihailnikalayeu@gmail.com>
Date: Wed, 18 Jun 2025 12:49:51 +0200
X-Gm-Features: AX0GCFtMxbH5aDiJ7Ikh8iLNBaj1NbJVkCUJPB0Gdk7cCL7MsaveorJSGkS1iQE
Message-ID: 
 <CADzfLwVMtwjHh8KY9kP=_vcYPqHs=JDzuexO4RFQ2fM8VoqovA@mail.gmail.com>
Subject: Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements
To: Sergey Sargsyan <sergey.sargsyan.2001@gmail.com>
Cc: =?UTF-8?Q?=C3=81lvaro_Herrera?= <alvherre@kurilemu.de>,
	Andres Freund <andres@anarazel.de>, Michael Paquier <michael@paquier.xyz>,
	PostgreSQL Hackers <pgsql-hackers@postgresql.org>,
 Andrey Borodin <amborodin86@gmail.com>,
	Melanie Plageman <melanieplageman@gmail.com>,
	Matthias van de Meent <boekewurm+postgres@gmail.com>
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/CADzfLwVMtwjHh8KY9kP%3D_vcYPqHs%3DJDzuexO4RFQ2fM8VoqovA%40mail.gmail.com>
Precedence: bulk

Hello, Sergey!

> In patch v20-0006-Add-STIR-access-method-and-flags-related-to-auxi.patch,=
 within the "StirMarkAsSkipInserts" function, a critical section appears to=
 be left unclosed. This resulted in an assertion failure during ANALYZE of =
a table containing a leftover STIR index.
Thanks, good catch. I'll add it to batch fix with the other things.

Best regards,
Mikhail.