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 1rGIst-00EbyR-87
	for pgsql-hackers@arkaria.postgresql.org; Thu, 21 Dec 2023 13:14:43 +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 1rGIsr-008vJC-7v
	for pgsql-hackers@arkaria.postgresql.org; Thu, 21 Dec 2023 13:14:41 +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 <michail.nikolaev@gmail.com>)
	id 1rGIsq-008vJ4-UZ
	for pgsql-hackers@lists.postgresql.org; Thu, 21 Dec 2023 13:14:40 +0000
Received: from mail-ed1-x531.google.com ([2a00:1450:4864:20::531])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <michail.nikolaev@gmail.com>)
	id 1rGIsk-00DAyv-FE
	for pgsql-hackers@postgresql.org; Thu, 21 Dec 2023 13:14:40 +0000
Received: by mail-ed1-x531.google.com with SMTP id 4fb4d7f45d1cf-55435a07fd6so397535a12.2
        for <pgsql-hackers@postgresql.org>; Thu, 21 Dec 2023 05:14:34 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1703164472; x=1703769272; darn=postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=BN2nEwOmwbcDq29zu9btSUjjEkZkwfspu7eMCWkPfMM=;
        b=HDtIwDQKw4NaZXMFAcR1CXIa04cWlH1XxS2s8zC5dwgHeUpscDzLTa8AphmsSCDepW
         Yf514/b/pESbB0XDyTMt33J1lq/GWQ+vVcu/j8/xt/dQGZFYDo6GK8jp6xDEGTDjBB2n
         s517nsm1rhV1O2YRbj+ZxQKPB4MpT8yk+VRmlv6GlnsaD3ZfOEEy8IbRFpge4OxO7KWC
         IGB/b8q4naXmTtBRs/lAmY3ww2IZArTbNwLfTtKMDL3hBezpEovn0QCh0DnMg3LIy3Ll
         au1TRB1kk+Mee2S+8u8RzgQ52hdf5olsUv0dX6NMGzJEFIOlSZgCvvoGSgSxPjNteFRO
         btXQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1703164472; x=1703769272;
        h=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=BN2nEwOmwbcDq29zu9btSUjjEkZkwfspu7eMCWkPfMM=;
        b=q4lC8WbhOGNYw0V81KMwBeda0QVs2wilVGPD25HP2U0w3veo2yD44TUT+IuPYn19rv
         VSrVBW+AUbfxiQ5hf6Tv04KS5LPUTziMnGry2Cn+Bvcw1wjUuJjurWefOOmzSuMHKIlQ
         EC7FEpPZDQQbEHoJkUVDYuefqV55rsTUegJ23Kq0kOsYUoTEQvsmfeiHoU8AmRlmKnzZ
         phzgI1iaBIiirJkQS3inoSh3eWrkO2q0OHTdV+uhe+KO2e0ScpnhClzmrpDaZXYQdUcE
         6q3In2W8GBsLIRIG+VdoeW9UB+6WrG+bjV3XrhJU6WarYwCSiWGZh3ZWiU7+fQBTCoWS
         /KMg==
X-Gm-Message-State: AOJu0YzK8pYXHboAKJf1s05bWVypwgsE0UHODXhljApZPuuQLoYOA/tK
	JpnRUO6TOyzF8Lj0zenEy/kgMWXddzLFGFvKA/Y=
X-Google-Smtp-Source: AGHT+IFOnZkBc7jHPGKJAayEVryYU2jlxZGCNNus5XCaj+OUfpCCU17IcErHYCkErLqL6VeT8sxnAFm/5M7V81d2/DM=
X-Received: by 2002:a50:f61d:0:b0:554:33c2:4107 with SMTP id
 c29-20020a50f61d000000b0055433c24107mr307669edn.71.1703164472331; Thu, 21 Dec
 2023 05:14:32 -0800 (PST)
MIME-Version: 1.0
References: <CANtu0oiLc-+7h9zfzOVy2cv2UuYk_5MUReVLnVbOay6OgD_KGg@mail.gmail.com>
 <CAEze2WgW6pj48xJhG_YLUE1QS+n9Yv0AZQwaWeb-r+X=HAxU_g@mail.gmail.com>
 <CANtu0oizNtPUrPB0Mh+2vyjdijTX=LZvO5_dZN3+NqvE-CFPtw@mail.gmail.com>
 <CAEze2Wi3BFLkFBcZ+Brfbr-mGBCcWXcWuHucnCnw5ZOQotc6Eg@mail.gmail.com>
 <CANtu0ojRX=osoiXL9JJG6g6qOowXVbVYX+mDsN+2jmFVe=eG7w@mail.gmail.com>
 <CAEze2Wg03Ps_StwEhgCdSn7VXY9ZUM=zCrf-m1dRZpTWv6wD_A@mail.gmail.com>
 <CANtu0oj66JjAq8xyRSeO=MuRHYS2XsYbhHRRESHtOcLJs=3+Sw@mail.gmail.com> <CANtu0ogT2Qn7-q_jK6+DqBQvFoTt69eQJDKxJARXV9pdWjd0Gg@mail.gmail.com>
In-Reply-To: <CANtu0ogT2Qn7-q_jK6+DqBQvFoTt69eQJDKxJARXV9pdWjd0Gg@mail.gmail.com>
From: Michail Nikolaev <michail.nikolaev@gmail.com>
Date: Thu, 21 Dec 2023 14:14:19 +0100
Message-ID: <CANtu0ogXgNkEuxbDRwznAZpxEXRmj3NzOen3y-RGHDwig0YBRw@mail.gmail.com>
Subject: Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements
To: Matthias van de Meent <boekewurm+postgres@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Alvaro Herrera <alvherre@2ndquadrant.com>
Content-Type: text/plain; charset="UTF-8"
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/CANtu0ogXgNkEuxbDRwznAZpxEXRmj3NzOen3y-RGHDwig0YBRw%40mail.gmail.com>
Precedence: bulk

Hello.

Realized my last idea is invalid (because tuples are frozen by using
dynamically calculated horizon) - so, don't waste your time on it :)

Need to think a little bit more here.

Thanks,
Mikhail.