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 ) id 1ulTPh-001AnE-94 for pgsql-hackers@arkaria.postgresql.org; Mon, 11 Aug 2025 14:22:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ulTPf-001Mtf-OA for pgsql-hackers@arkaria.postgresql.org; Mon, 11 Aug 2025 14:22:12 +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.94.2) (envelope-from ) id 1ulTPe-001MtW-Mw for pgsql-hackers@lists.postgresql.org; Mon, 11 Aug 2025 14:22:11 +0000 Received: from mail-ej1-x629.google.com ([2a00:1450:4864:20::629]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1ulTPX-00021B-0d for pgsql-hackers@lists.postgresql.org; Mon, 11 Aug 2025 14:22:10 +0000 Received: by mail-ej1-x629.google.com with SMTP id a640c23a62f3a-af925cbd73aso846485266b.1 for ; Mon, 11 Aug 2025 07:22:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1754922122; x=1755526922; darn=lists.postgresql.org; h=message-id:date:mime-version:comments:references:in-reply-to :subject:cc:to:from:from:to:cc:subject:date:message-id:reply-to; bh=jUzl2crZwsgbldZH7Jwn6QFuOFjyrbO1LhN6lkz7pQ4=; b=nYsH3g2vWDL0KkawOOhpC1WYwY/cZtj7G5Hq3+CPi00dC3RO2knWs8Mw+HyGbl//VH nwPkPycuzad7QjIITFEBAqDvMsnLdTHYiKgFD/VsVE48jqFMqeTy6rfO9G53CIBS8xmL EvlKtA6aw8uVDt3Pz15PBsto8z/afWyhFOt+TvLXyJBgaUwVbtz6YAYukGOjgpcM3z+9 ejEXS9zgRcY7R9Kc4FBe3KZ063vXYOzdpdjmtzlWjHA6kJ3ZQpXk3PW/n+sJw3OxsSb3 Fn8i0ombx1K/strESsj/Q6zUl3hT2JJH54FEVYYxBQXwfz4oqnXlTiFGsO1/uYS2sDU4 WgNw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1754922122; x=1755526922; h=message-id:date:mime-version:comments:references:in-reply-to :subject:cc:to:from:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=jUzl2crZwsgbldZH7Jwn6QFuOFjyrbO1LhN6lkz7pQ4=; b=R3fXqZ0oT8aNeP0Zk+rE3sMcvpgDtDQs7Eww3i76/H5aAS/3/+ZTuy/4Sav+KmVkGx rfQ8xGH0A2s7Z4AxCQwarGgD8p+0W2MX78AUSFhvgGHK0/8glRKEFB/KStKKRcAb9xlF ahUcqlMQPgzsgq6z6eFiK258jpyqdRQVAacM31fc11zz8/9NcRLy69wGbpMtiN3l1Cso FnttLUzNY/9MlF6cXoK9y4mRX0MatVt9/wvgwd+0AlpxWIWm4SEGdx+5hbK97goSvI2Q SRlfhMiJMi1rs3PLafus/x/MQ9tGfgNAjq+C2BtwT3Da56p7ZWEn7S2DW8i3NoOfC7QP +Fjw== X-Forwarded-Encrypted: i=1; AJvYcCWC6sdsfdoFNbHdN86cnrmUsYjmpl1n2Yo/sP9VHX2+DMNV5Xrmq4Jl+mTUABXG0LZhnjMTZ21m1AQVgFxK@lists.postgresql.org X-Gm-Message-State: AOJu0YxvVQCoWmNIQGzvRVB2HZ/07gIEiLehT6jJdFFYxAkknr4GfPkz mJXl04CKlsFZ2Ux8JfW2c4kCO6Ha0m1acUuAg2WjIz1x7Zxhd+OqT1ngKh6WOZuxyL8= X-Gm-Gg: ASbGncucpdoZhSVuYYr6f/bdVpU2AEi2NtGCbsS9nNrERo1xRXGCn1SV/5lmfPlY0/p QtKcUxzwOePEPVuYWDlt+8GWNysO41xZGoGjY82v9gLwycZZz/yWbHOEW5seAYU/dKypiBoT8lz g66kkQMY5UqReLDlGyzJhLUmGxSWOm7f8JHJke3r6jx7h+EexQVanTfSkIxRcaxltncx1Dk9qeZ 22hGq+heJbHioT9RTk9owVY6wc7W3sZRazhRmQQk1tztKPD8QHqfTrhV8gk/YjLnGCweftDSNco 3xLSkFuuczzdVJ2my5SWWde3G6yx7YY8Y0SEJdH690bXQDoBc0CyFrpAq7JfDWiWr+9GTEiNY5X vByZiyFU4cs8nqu5kbdxB3AMRLV1GuDsHpV/2 X-Google-Smtp-Source: AGHT+IGOg9EldC8UgGLYh/yr/Y0Os0oeQUzpt/glF7u+PqvT8dy9L7lbuaffL9lWh8QTDxBt0TVgZw== X-Received: by 2002:a17:907:3c84:b0:ad5:d597:561e with SMTP id a640c23a62f3a-af9c659f0c9mr1240022666b.56.1754922121837; Mon, 11 Aug 2025 07:22:01 -0700 (PDT) Received: from localhost (109-81-168-144.rct.o2.cz. [109.81.168.144]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-af91a1e6cecsm2037527566b.70.2025.08.11.07.22.00 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 11 Aug 2025 07:22:01 -0700 (PDT) From: Antonin Houska To: Mihail Nikalayeu cc: Fujii Masao , Alvaro Herrera , Robert Treat , Pg Hackers Subject: Re: Adding REPACK [concurrently] In-reply-to: References: <202507311650.3a44mqyi3xnw@alvherre.pgsql> Comments: In-reply-to Mihail Nikalayeu message dated "Sat, 09 Aug 2025 14:55:00 +0200." X-Mailer: MH-E 8.6+git; nmh 1.8; GNU Emacs 28.3 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=-=-=" Date: Mon, 11 Aug 2025 16:22:00 +0200 Message-ID: <41104.1754922120@localhost> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-=-= Content-Type: text/plain Mihail Nikalayeu wrote: > One more thing - I think build_new_indexes and > index_concurrently_create_copy are very close in semantics, so it > might be a good idea to refactor them a bit. You're right. I think I even used the latter for reference when writing the first. 0002 in the attached series tries to fix that. build_new_indexes() (in 0004) is simpler now. -- Antonin Houska Web: https://www.cybertec-postgresql.com --=-=-= Content-Type: text/x-diff Content-Disposition: attachment; filename=v18-0001-Add-REPACK-command.patch