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 1wMcuW-000EBz-2i for pgsql-hackers@arkaria.postgresql.org; Tue, 12 May 2026 02:31:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wMcuV-002xBf-1o for pgsql-hackers@arkaria.postgresql.org; Tue, 12 May 2026 02:31:51 +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.96) (envelope-from ) id 1wMcuV-002xBX-0u for pgsql-hackers@lists.postgresql.org; Tue, 12 May 2026 02:31:51 +0000 Received: from mail-pf1-x42e.google.com ([2607:f8b0:4864:20::42e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wMcuS-000000009D9-3IBm for pgsql-hackers@postgresql.org; Tue, 12 May 2026 02:31:51 +0000 Received: by mail-pf1-x42e.google.com with SMTP id d2e1a72fcca58-835b78c3797so2081940b3a.2 for ; Mon, 11 May 2026 19:31:48 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1778553105; x=1779157905; darn=postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=J+aDAF1VzJz1QLBe9CNPTNhVaR5db5++SUQA5K4NFvc=; b=E+aneas7oYm7qcHONMxx+Ot7WIe9Wb2lnPm8HGth7Xsa2+S11QMCV96ATvC2+vlGXj R/M8hoaOczxwluzwH6YVYCRPwA9MnR2cYTFufgNSujmvVyXvMz8vPJWW3bAWq9Jsuz1p rgua0lCJNDVrRk4BK8uvOKEcAHPzAxkrQLd5KJf+1ST6K1CGDyz5VQfF76p3BBo2VLrO bstR6NCm2TdnN1eGtUxiT8JvrOlXpRgfO/M0JYEmkyyV/u3czH3/rKrFWvNKXhAqdYwo 4LjnKcsmTQtAdGPw5qyWOqO/xSEWYXCJnuNgATy5FEMeHnVtCAPj6Cr3oyQz8H0xTodG BOBg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1778553105; x=1779157905; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-gg:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=J+aDAF1VzJz1QLBe9CNPTNhVaR5db5++SUQA5K4NFvc=; b=Fn/hzIhy4DvWVE5qkqe87U1smeCmOZVVbZ1xdd1+CDIEeSWs1vDFW2/HcSYFiG+NFL F5N32jsiCfT/tgtTl3RDW/C5PYrIjkgBtoz6f3NKkDEAP9ljZtCBeLiXFlzMvw4VZAD+ nqA5xG+8CXBZqtAZZUSgJMeoFfbxmFslYtBVDuIFpKfPfr+XhoEbGwcaIsC3EU0I4BXB dzgVl46m7uCcuootyQlfyPKF5b+JkhVEROJkfe7vXzD+gUn7DB4bOanoY/bP/nqTMiU8 Ct+EAGicfQtaP6bXqmPstVd6EUc9SDbUk9gLlmb6bfyXKboxANoM4tmJsA3vtLgAbuJL fpKA== X-Forwarded-Encrypted: i=1; AFNElJ/oLLO2Y8SeNTyzuof7rqhIMylNVQffKH1lVRypKA1KjBhTufYXXYmK3dqIv3W8PKeznjNDEZkffsnISLrq@postgresql.org X-Gm-Message-State: AOJu0YyOFhOPjWlRWUigrtVuf/YWJGd3PXDgKSE2AGouVfw2cIpr+QLZ sUL74wDHZvF04ej9t5ykwd57sM6rveyF3TrW5hERNZJbnw3WgO0JeU3a X-Gm-Gg: Acq92OHWeXjRpkbmiSczxltN3sdbO/bC0NpQPlV1SPGAJsbtr3gfR22i+2X8oLEXy7U bAcw3rhKpV9M93lrepq6mvF3YKKAe7HMvojstPK08+1oJ4ZtOujzqkYiVsYfhOD2HKaShJqsu23 gNpr/Spx7rlN9O+6zgoIEna6ncQCAi0aBZWzxS2Sik2AaU2p6xchaXyku0t2JQd/zF24DEwl7zC m04jUflDTABOBW22d8m4jyuVtMYQvKy/l2ENPd5ZuCUR/3YOXxUSVhzhSKcms/D2kTpxCVPKbu4 2aukwOKRjIP4xB6yCMMauxYAdhOijc/bbEOkZQiil+VHfiDSXSSUNe4VHDZ5Ux2d6XiwKZfXdTV 0wRlSVklEPJH+fS5imGO0scwKl3AlnfywdiMlBgb1QlB0roVFMejTAQZ+Tv8VN/grsSvEkeZU7Z NRs8SzDt5LcdWyjDlDde6AzPbFcaVmND0= X-Received: by 2002:a05:6a00:4197:b0:839:9053:9a16 with SMTP id d2e1a72fcca58-83cf7561f11mr15829237b3a.47.1778553105427; Mon, 11 May 2026 19:31:45 -0700 (PDT) Received: from smtpclient.apple ([45.32.121.103]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-839682a103esm27475305b3a.51.2026.05.11.19.31.43 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Mon, 11 May 2026 19:31:44 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.400.21\)) Subject: Re: Fix REPACK with WITHOUT OVERLAPS replica identity indexes From: Chao Li In-Reply-To: Date: Tue, 12 May 2026 10:31:05 +0800 Cc: Kirill Reshke , PostgreSQL-development Content-Transfer-Encoding: quoted-printable Message-Id: <41CE1664-61E0-4857-A27A-924A6AD42B11@gmail.com> References: To: =?utf-8?Q?=C3=81lvaro_Herrera?= X-Mailer: Apple Mail (2.3864.400.21) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On May 12, 2026, at 00:21, =C3=81lvaro Herrera = wrote: >=20 > On 2026-May-11, Chao Li wrote: >=20 >>> On May 10, 2026, at 06:38, =C3=81lvaro Herrera = wrote: >=20 >>> I think it would be a good idea to make identity_key_equal() not = deform >>> all attributes, but instead only up to the last one it needs for the = key >>> comparisons. >>=20 >> That=E2=80=99s true. Please see v3. >=20 > Thanks. I did one further small change, namely to determine these = last > attnums just once per run rather than once per tuple. Pushed now. >=20 > Thanks for testing! >=20 > --=20 > =C3=81lvaro Herrera 48=C2=B001'N 7=C2=B057'E =E2=80=94 = https://www.EnterpriseDB.com/ Hi =C3=81lvaro, thank you so much for tuning the code and pushing. Best regards, -- Chao Li (Evan) HighGo Software Co., Ltd. https://www.highgo.com/