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 1waT2B-001p5X-1G for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Jun 2026 06:48:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1waT2A-00FHMc-0d for pgsql-hackers@arkaria.postgresql.org; Fri, 19 Jun 2026 06:48:58 +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.96) (envelope-from ) id 1waT29-00FHMS-2l for pgsql-hackers@lists.postgresql.org; Fri, 19 Jun 2026 06:48:57 +0000 Received: from mail-wm1-x32b.google.com ([2a00:1450:4864:20::32b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1waT28-000000016MI-1QM3 for pgsql-hackers@lists.postgresql.org; Fri, 19 Jun 2026 06:48:56 +0000 Received: by mail-wm1-x32b.google.com with SMTP id 5b1f17b1804b1-490b613a17bso13337215e9.3 for ; Thu, 18 Jun 2026 23:48:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1781851733; x=1782456533; 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=tM7GIYJIescwJret0czzk3Yf9zfcVh2pknTip2stwKM=; b=lfIaDkBqaH07EeLdi0vdSTOKbJwAEAa2sfbyPan5+ApGdvj6soy99kQTyoTheUkSP2 aPn2z4M9C1og2XCSkQDvS2hlSOEsDftGRSwCx8SVLkA9GpfUT0bk8IiO1mkMyOnYpjMK SyHTBNSW3wfgC1WvMFpb15fkfYIh2uQqkmEGDQEDNFuilzWMgg+OkGPE9ZmSp/Z+i0tL icW2YX6kDHm3ee7kWBC2owS3gEx5/+IP+Y7WzhT4fHBEmTcGw0UheWsKkPfUXeYuTkmb s9T9iHVaHPukQf8qgHTstJv9P1glCRHT7esTHnVmJJhBo4lFywg2GIlVEA39LaBs3cp7 xGag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1781851733; x=1782456533; h=message-id:date:mime-version:comments:references:in-reply-to :subject:cc:to:from:x-gm-gg:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=tM7GIYJIescwJret0czzk3Yf9zfcVh2pknTip2stwKM=; b=DozAAIjsiGsAywEi8O50buWumtZ5PdQ+bJtbmIAzL42dwKvbYZiCewT4+d/WmVTkA1 CT8DLJq90EaqFIICwgq0e7aPSTli58ljb4esdfSnFPRU+KmWh/6jcpbOW4aoY2hgEjDA i/lRJboW+l/pxHxLUXP9DD0J6X5fCP9/iYmLKAh/u3QrUinAffKgyahIS6lKWuDYp1MK S5fKfD3ZrQmZNedrVcTS8whD8FG9OpfOOZ/qkijmhKnuouIGCag3waRhI28Pm3krxk89 ZFFxuCOTArynVxQx6HOvFYx0eh1+ZRmlAZiwBVzt6msFyln7w0rnBW+/K/PqDJMRYJF1 kXuw== X-Forwarded-Encrypted: i=1; AFNElJ/va/heANM8M5sYs3+b9F1esfZNmSBcnG7Px8Sja7P71rcgEIOq1yc3jAhXf6YguezWoHZjdbKzf6fdhgld@lists.postgresql.org X-Gm-Message-State: AOJu0YzNd8Z0aloTco1zDo1Tix2BPJOuqBkQgR3RBR2+FZDHBZr9IK0n XzzeqWzI2dQacJZu+cv2jnaLmHBX7Q4QrwKUe7t8UrnprBUsJFPJJbXOcRSwm7gCUU8= X-Gm-Gg: AfdE7clWR3Y8qocynhaOQofVCunYUBSg6ql8DEkiYq5egfF2OuTJCb4hDdjgRZa7tpy JW4RL70E7ibEotZSodLd1nQwCD07WI0zq3TtBAy6ObgIglAtNSUAOMh7Y2wjHKsZ3soTCGOuAcd ppB/+t4/m93xGcmjMCPN4ws95qLOyjq09W2kc6IIBLWqvQoxu4sCdJ7MWl0RzMLmsklAMiP2tz0 apRlpHNf+Dm9GfwxYAarw4SmiINL5rN+iLPI7/aWuWFX5q3Gaf6h7/I9xVNE70c5vIPBZfmjvaG gxsa4mZmFXgIKts2GgRpCIu1xuCquZGMyFohtXuxX4GHvIJ3KH9yK+JihXS9NQiaz6ZjOiclRZ4 1wDmyDT4hiVtQFPq4Yy+dTJ89tsWSSAz6s3GYVSpDMjWsG8w9kwddL2kAESzzufGnxty+KE9m5v yD5I56o6gPojuVFSHwNp/DInxDChix5S593QdB X-Received: by 2002:a05:600c:6389:b0:492:1e36:8c72 with SMTP id 5b1f17b1804b1-4923f6a2ab1mr43603685e9.37.1781851732845; Thu, 18 Jun 2026 23:48:52 -0700 (PDT) Received: from localhost (109-81-168-148.rct.o2.cz. [109.81.168.148]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-4650b76e7c9sm5405977f8f.21.2026.06.18.23.48.51 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 18 Jun 2026 23:48:52 -0700 (PDT) From: Antonin Houska To: Alvaro Herrera cc: Andres Freund , Noah Misch , vignesh C , Srinath Reddy Sadipiralla , Amit Kapila , Mihail Nikalayeu , Matthias van de Meent , Pg Hackers , Robert Treat Subject: Re: Adding REPACK [concurrently] In-reply-to: <202604062121.ijkompbo4ezj@alvherre.pgsql> References: <202604062121.ijkompbo4ezj@alvherre.pgsql> Comments: In-reply-to Alvaro Herrera message dated "Mon, 06 Apr 2026 23:59:59 +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: Fri, 19 Jun 2026 08:48:51 +0200 Message-ID: <5998.1781851731@localhost> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-=-= Content-Type: text/plain This is a diff to remove a comment that was only valid in earlier versions of the patch - I failed to notice that so far. Another comment in copy_table_data() explains why rd_toastoid is not set in the CONCURRENTLY mode: * This would not work with CONCURRENTLY because we may need to delete * TOASTed tuples from the new heap. With this hack, we'd delete them * from the old heap. */ NewHeap->rd_toastoid = OldHeap->rd_rel->reltoastrelid; -- Antonin Houska Web: https://www.cybertec-postgresql.com --=-=-= Content-Type: text/x-diff Content-Disposition: attachment; filename=repack_comment.diff diff --git a/src/backend/commands/repack.c b/src/backend/commands/repack.c index 4d177c868bb..195d85c323b 100644 --- a/src/backend/commands/repack.c +++ b/src/backend/commands/repack.c @@ -1453,8 +1453,6 @@ copy_table_data(Relation NewHeap, Relation OldHeap, Relation OldIndex, /* * Reset rd_toastoid just to be tidy --- it shouldn't be looked at again. - * In the CONCURRENTLY case, we need to set it again before applying the - * concurrent changes. */ NewHeap->rd_toastoid = InvalidOid; --=-=-=--