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.98.2) (envelope-from ) id 1xENXT-000000014ZD-1oo7 for pgsql-hackers@arkaria.postgresql.org; Wed, 07 Oct 2026 09:02:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.98.2) (envelope-from ) id 1xENXS-00000005alf-1qmq for pgsql-hackers@arkaria.postgresql.org; Wed, 07 Oct 2026 09:02:14 +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.98.2) (envelope-from ) id 1xENXR-00000005alT-3XUx for pgsql-hackers@lists.postgresql.org; Wed, 07 Oct 2026 09:02:14 +0000 Received: from fout-b6-smtp.messagingengine.com ([202.12.124.149]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1xENXP-00000000rQm-05OP for pgsql-hackers@lists.postgresql.org; Wed, 07 Oct 2026 09:02:13 +0000 Received: from phl-compute-02.internal (phl-compute-02.internal [10.202.2.42]) by mailfout.stl.internal (Postfix) with ESMTP id 26ACC1D000F5 for ; Wed, 7 Oct 2026 05:02:09 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-02.internal (MEProxy); Wed, 07 Oct 2026 05:02:09 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm3; t=1791363728; x= 1791450128; bh=mkYSW/BxHjc1VC6hRCmzAlzsF78e3iW9P2UZpItBrc4=; b=7 OqKlrNcHhL1EbeASG0SKEYRFbi3ssPZDHNdnYHJnKb8JvI1Yxp78NYzYE54sOeRA ohnV2kCn7k04oC/JA/14vSDy63BexWNYxCtXrBMMx7lcj0fB6UC7WS8XwEn8UtQa izlv2M4Y9x7WPsI3E6OUgrXqlWJqHlGNVNjklBgiYI0zrjub2Vph2H33VxuA4DMi u8kKa9sEj5d7XgmxyXXgnf/FFgNr91c0s2TiX2zwVbKm0Eq4eBkuxm+uCOxY6g/n jcqJGZxFYWCUuYxITK732nUUooKk7HrL1hwcELowjKtTDSfPPK4e/lD3pgRF1G6K mahXiFW7V4/+5jTvIgxxg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1791363728; x=1791450128; bh=m kYSW/BxHjc1VC6hRCmzAlzsF78e3iW9P2UZpItBrc4=; b=GKaqCUGVWQ9PEPbd/ eEXXKGcL3Kj5yQEnERyey4+dmQWhopjrQ8x+qeJ3PSrCPoclv7rJByS+6bOe+dC5 HPyDZq6GGIOjJprO7zn4fNyxlv3DGGpYgPUmglDDgMoN+TL0M4HvNvxqeMY8TgwC oL3HnrcpZTtidYSMHUV8ONIzdfn0Cpm8xVgIHei0E6I6m8mTZzUJSoVP9VtABrHF 3ZvPvQ3wLfb9pEszOwufOweFC/6ClibwCR7MT4on5DwX/Tv8TJdJXqgd99R/i3xU O0VomME9rgeXSBo9fBBWYQqxkb383Yox3stYwLSOrj/DFovN+62RR2efOmj0GGB7 gBtMA== X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-06; repo=github.com/dkim2wg/interop; date=2026-10-04; sw=lmtpprox; action=sign d=kurilemu.de a=rsa-sha256; DKIM2-Signature: i=1; m=1; t=1791363728; d=kurilemu.de; mf=PGFsdmhlcnJlQGt1cmlsZW11LmRlPg==; rt=PHBnc3FsLWhhY2tlcnNAbGlzdHMucG9zdGdyZXNxbC5vcmc+; s=fm3:rsa-sha256:wjn2kxsywPDMNFyi37SOpkTYxTcWT0jls5EGGRcCtspya+b uuvdAkNsbc3pcI1N4UHA6DyP9JQaFXgPUg90nkt/qzgn//hZlavOgGf6muasPzC7 ZuZAXdKkrSTUEaYoUsyuvAtwWOmkgre4xaWWFVUZB2mm9N9yTE5tD/r9IrEhPf3i //7926sG192lXSlChoz+dUogRelxtUV5GIKTXnROh2pkADEZx4hAg1vbLsnWRO3A XAKchrME03s3sRSkKCEiubdNwc7Hj7wJz7nf2ZwLaRV1fiSYle756D12NXGyoBht tY0Wh72KFNzfN+AOauHyyb5XZ1BkPWiTpPmqj6A==; X-DKIM2-Info: draft=ietf-dkim-dkim2-spec-06; repo=github.com/dkim2wg/interop; date=2026-10-04; sw=lmtpprox; action=mi-m=1; hc=12; hn=cc,content-disposition,content-transfer-encoding, content-type,date,feedback-id,from,in-reply-to,message-id, mime-version,subject,to; Message-Instance: m=1; h=sha256:KwwyMeAHP4HC8XtOhr0bmY7x6+486Z6/lHzPvFtnH9k=:daZpBhjOrPM+xUkmg2h5eCIut385mDiyFD8NKcLxM8E=; X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTF8bkuzKldMLddQyWKSb2A1e8LvMyPaJCu93jB8TZkjAoylakjNjW3KsdWd/nfSFi jJBtP5f7V+thiYs7Myvo6NjxGrh3QE5gd6Q/lee+8S76eCpCjIQLRhfuuqvwoYDZaziVkT eSBv7n8vZEBR4sDKjeUjomaO7xqwA3ogFMxftgSlBI1FvY2EM8Z208LsFd9ntONTvOLJX6 LWJd8aBACPi+m2zNH3/weMVmdPFzlCzs+fIaAAIfTWTuPtMZDBUvtOjvS7HLXBqz8X3ybL fQuNdUpM7TB1KKk/jYZz1opRHcO5Q/6oxiXhplPwA+VVedkIhT94/MCiv+Y79JVAvoflNt 3URaWnDQSacMeezxHdMzF8zwlmCZEAXSBWmRyhPzfH1umIQy1H/dG+vbMHKW1knci3jR1h 8exVwJjP0CUsozWOTZRB825sVkvJlk/cUrqdUyFGBmWzg6J4O6SUT+Qpq82/TVkfNReChg YMMjRQWZKgC1DLRH3vJIz6pvP/sSux4mkj1JGw0Ma1tnehoR+Xy/7Jt4V+gM8YGY+tQ6oV tlS0dWQTaC7+2lN3befGvgcFvlNOdRnckJiDnly01NNzkz3gU3EGa1tmQ2VkAkco1gkM6q WN6xgTsmSULCRmrVvUhBTL60v7uWq9ymWA8zcxKHiNHO9t5ADl3NngyDab+w X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 7 Oct 2026 05:02:07 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1791363725; bh=daZpBhjOrPM+xUkmg2h5eCIut385mDiyFD8NKcLxM8E=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=GMIjCgG5/asKVuCYhs1pxtxeswpOB2So1w5ynaQFVcI/68pjZZNUyWucNEfI92HPr uy82ifnKFz6QaUNsOowjVyDDT6XVrtvqR+P9q7AI3cqpXiiA+zqZHpjzt6OhMsuvah MRoT15iLcmTGMayWcUfRebDz/X2xt1PEDvsN+TAJL2aGzgJFenq/qWZy46TUuS8M0x HBYIt42CXQl0QtkOeP2sOh5OvJaYnQNWQcWnMjhR4ly7S6NrFGDhjWIsrJt0fSy1El fbANdWiHUIChQCp/I1JttriJYlsbku6DyVcvRWA8yw0LTxID4HSVrUukWiFruaMWGf XgfIUo9rx4f9w== Received: by ida.kurilemu.internal (Postfix, from userid 1000) id 3065EB00044; Wed, 07 Oct 2026 11:02:05 +0200 (CEST) Date: Wed, 7 Oct 2026 11:02:05 +0200 From: Alvaro Herrera To: shihao zhong Cc: Antonin Houska , Fujii Masao , Radim Marek , PostgreSQL Hackers Subject: Re: REPACK (CONCURRENTLY) might keep dropped-column data Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2026-Oct-06, shihao zhong wrote: > v2 clears the columns only when replaying an INSERT. restore_tuple() > and prepare_concurrent_update() stay as they are. Hm, I just committed v1 with some trivial changes. I don't understand what does v2 achieve. Are you trying to save having to scan the attribute array for tuples in DELETE? -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/