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 1vvKBG-00Dp1z-39 for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Feb 2026 19:04:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vvKBF-008NQN-35 for pgsql-hackers@arkaria.postgresql.org; Wed, 25 Feb 2026 19:04:17 +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 1vvKBF-008NQF-25 for pgsql-hackers@lists.postgresql.org; Wed, 25 Feb 2026 19:04:17 +0000 Received: from mail-wm1-x332.google.com ([2a00:1450:4864:20::332]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vvKBC-00000001GW0-2GsT for pgsql-hackers@lists.postgresql.org; Wed, 25 Feb 2026 19:04:17 +0000 Received: by mail-wm1-x332.google.com with SMTP id 5b1f17b1804b1-48374014a77so786155e9.3 for ; Wed, 25 Feb 2026 11:04:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1772046254; x=1772651054; darn=lists.postgresql.org; h=message-id:date:content-id:mime-version:comments:references :in-reply-to:subject:cc:to:from:from:to:cc:subject:date:message-id :reply-to; bh=q0nlSWpiGJGLflVBV4oYHxSskyXmv8wqV6BQFlGQFBY=; b=eIoet6tNMH1n17/IzoJF9m2KLPApEKfVww/ycCW7cF6xcAbnjxeQ8VWwIGUGXGLyCR O25NFzcMw6duRbHOQafUSHMkl2dNBsU6Slzjin3QLhtp9Ez02M1dUXrDgFFtDKGdtJMu iCIXLlGqC+A7KslC2TvjlwD2xlxASKEeMjUampXGppAzExTjCCprajvYzLqrxPvv5YyG LnMqTiJFv/p1ZUfOIslWA/trY4FbqEpyKZnPVjp2yhTaLADq1IeD5r9e2j+Ztms5f5G2 Mcl/+TMfVTquDbaQq2oHJkvZmInRmHx675fkcL2o2kQXd1jxAMypFdV1K3dBg2A8c30w lKXw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772046254; x=1772651054; h=message-id:date:content-id: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=q0nlSWpiGJGLflVBV4oYHxSskyXmv8wqV6BQFlGQFBY=; b=l8g3LBYef8GNUs2DX4x4NuamJOsYW6h57hUFGt9btW3681wweg1Q+V1lzjBJQIyzmu 82CY9UCo1MA839Fp5q9gW8ff4uR2Wq8DB6RStYk6xZYHtWBH7zGZhZVW6ySJmxF7AEZH sigsySmgz6T6MmpE2lYkeY+2weQmyUw0eswSKAeM6ljgYJrfw5KZLlQQ0Ask5Cd7z8Q3 Ny0OwkbpvEZ4f8N3dqNE04uU/aQjC4xK9E+h4CokAkqxLUs2hlzc20almDNdqK22hilc CidSKWmKqm7uG1woxmqXum5pxq4r2in8VSctmRUULgOqCGTXu9HFXYoN8UeOedvHplb4 fukw== X-Forwarded-Encrypted: i=1; AJvYcCXeaoU1eFrCEeSs0hISMb8ciKmNzksL2RFjL7YPYYV8IU5aG+JQsx6at9GnQ7knw7Fy90XD7hT5ER9nAvjA@lists.postgresql.org X-Gm-Message-State: AOJu0YzBQizM9CZUAZZ5x/zv+kdhR7FHVlnj1RbIYmg0FVrb9RGGllDB ycHPv22NaXnhC5oHaQ7+ulfu9S5KXFLejpXsZhhmUeGMKLj9GiINMFMs5Xi/7GU0STM= X-Gm-Gg: ATEYQzy02XyEL6WWTKcdV7g2drXjk8Wpjq2RlXaOujIK+GKOLIKdsu/CcQpZoG7fnrM G2xoaJ9ZaScluBloka4mBXvbrEUtDjNhjsV6C9StLQaka+e3h16zoOT3G2xuWi5JYpt8U6jRdFO ngp9+ULlauh4GwS2zvIIVkSP7QDWv1tQUgopMQD9IFEieph91xcq045hJH5KVDYK+MsTu0WKWhx tS16/UnRTwjSSv8T1GBOpruloTm0euv8xHjP85z4X8B828WtLA5GulA1pD/4Ahh1nL2+1GhURGa 9enRx1rn986wU7fCZ46ROAc5oV1xQefwP/dFwIPrhDTIVda8eP1KJDP1GF6gBztvUKPBuIzbakV hSg6BWQQivZh6KskwWidVIEnWRY4MsiGLv+xiaeu0KEpk+6x4SkuPuxtyz63wOyreUslUHUrVEv FwKf2s7f4L5BdRTq211n3+6Gyx8AnXUi9CAAiF X-Received: by 2002:a05:600c:4f8a:b0:480:1d0b:2d32 with SMTP id 5b1f17b1804b1-483a95beb5bmr310997515e9.12.1772046253812; Wed, 25 Feb 2026 11:04:13 -0800 (PST) Received: from localhost (109-81-168-142.rct.o2.cz. [109.81.168.142]) by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-483bd7507adsm96812695e9.9.2026.02.25.11.04.13 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 25 Feb 2026 11:04:13 -0800 (PST) From: Antonin Houska To: Alvaro Herrera cc: Mihail Nikalayeu , Pg Hackers , Robert Treat Subject: Re: Adding REPACK [concurrently] In-reply-to: <202602251618.dpgvox64vziz@alvherre.pgsql> References: <202602251618.dpgvox64vziz@alvherre.pgsql> Comments: In-reply-to Alvaro Herrera message dated "Wed, 25 Feb 2026 17:25:54 +0100." X-Mailer: MH-E 8.6+git; nmh 1.8; GNU Emacs 28.3 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <97233.1772046253.1@localhost> Date: Wed, 25 Feb 2026 20:04:13 +0100 Message-ID: <97234.1772046253@localhost> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Alvaro Herrera wrote: > On 2026-Feb-25, Antonin Houska wrote: > > > > Hmm, so on the apply side when reading the file, we would first reach > > > each toast attribute value, which we know to insert directly to the > > > toast table (keeping track of each individually toast pointer as we do > > > so); then we reach the heap tuple itself, we [... somehow ...] interpret > > > these external indirect toast pointers and substitute the toast pointers > > > that we created. So we never have to construct the entire tuple, or > > > indeed do anything else with the toasted values other than insert them > > > into the toast table. > > > > Yes, that's what I mean. > > Makes sense. Would you be able to try and implement that? Yes, I'll try in the following days. -- Antonin Houska Web: https://www.cybertec-postgresql.com