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 1wQoIW-001tNi-2E for pgsql-hackers@arkaria.postgresql.org; Sat, 23 May 2026 15:29:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wQoIT-00FoLC-0Q for pgsql-hackers@arkaria.postgresql.org; Sat, 23 May 2026 15:29:54 +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 1wQoIS-00FoL2-2U for pgsql-hackers@lists.postgresql.org; Sat, 23 May 2026 15:29:53 +0000 Received: from mail-lf1-x132.google.com ([2a00:1450:4864:20::132]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wQoIR-000000013sO-2Aee for pgsql-hackers@lists.postgresql.org; Sat, 23 May 2026 15:29:53 +0000 Received: by mail-lf1-x132.google.com with SMTP id 2adb3069b0e04-5a8738c178dso7392789e87.1 for ; Sat, 23 May 2026 08:29:51 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1779550189; cv=none; d=google.com; s=arc-20240605; b=Iskkos4JRQ5ei6Whgpy8t95Kwa9AZ4vFjdMwQhMLRc12olrYgT2zCGvOcNax7V8B1Z C7cD2Uv3PV/6xyBYbtXp+PLxIGMDp0KvNPD95WVBbI6GXQcDgIe72Ep5XlgOZp+6g3Yf KhBl8MlUUbJfpeCwKXeM8k5dP7+btN0iGZrnhDqGIWNEK3OYPB9liZOKjj9kith9RXPB ilqXwqHGn5CHmevnTJA0rVdvLoY0K2JB0yRb94ECzGzfzNmRu8MNcttwDYHT7dbS1aLl yGQ4BfrPPAveWq4Y96iS9FnpIKx7Jp0qavAg/U+cjfeFaqXFNGN5LVb6u6//m1LJ1ojz 049A== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=jtay1fhgIs37Ol6rKtaSbV7s9pmCF37sT7yI+kR1mJ8=; fh=Rg0aYggBnX5ebx0DhQrwJqXK2eiwVegSu5kGd0mgTDQ=; b=e23EtGP4wVkzLE4QTBvzVIc78g3wZgm+jzUtpV6RE/48iobVH/CiogqHem0NKD1Tk0 bTBunclCLmt+DXWYdxv8569P3Y4EX0FNQ7/VPJDVtRmhypqH79JMzsyvATZHCQBxpqMB J4/BDeZdWkHILfItfkQcR+g4YINmduALsxYyR/A6VPpDoUqv0BQwY6MiTVXQqU0QIOEc JYksUSaMvPDJ/uq/VSC3FaZSwZRqcgoePrmSc1K0hxTtweCikeqjbW5eX3qwO7YXkaCD DNnv4HL8BOa98O+6OQek/VwooHrbcoW/WN7fCXyX6eXz7U1hDBf+BSQyn6lRI7DrTcHR VwHQ==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1779550189; x=1780154989; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=jtay1fhgIs37Ol6rKtaSbV7s9pmCF37sT7yI+kR1mJ8=; b=PizjevMYzAKaHNakZTVw54+D5NhDvD+nSXFzqTdJ9pTXaxG78FdSguE9i/qCwzGUAE 8q9oEIs+m27cUm4Whm7gnVRd+v8GhMgrAyUIWgpzo77HxUQW8azl8Jw/AS3G5QA+wwcf Esd9V4oCoEvCIPDN5CzL387fWP96JX73bwqBU+U3U+/0NCjtI+wpyQqGB6vSkUqPlZ7C sEmKui4lMHUb578VS1G/6mHgkNWg1izlMbAA7+wpcllzrwMu4hwOiI/WiiJmaNYTVIiC sqevFk1vkWM+8NavoJiNi/n1GAi8GbXF0osFFE41Ncpq2v1pdmFUWch/GbgHjau/ci1v Eorg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1779550189; x=1780154989; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=jtay1fhgIs37Ol6rKtaSbV7s9pmCF37sT7yI+kR1mJ8=; b=U0j1aiJlaYRKCc88m1MryBvGwwn+gXMedpt9k60BqNP7kk86QvnkJyKkXs1xNvPfYF BfUH+Wa68qV6tSL/jXEn6m6h0/2eqA42SmFtAmeO71UfS7iAy9D0YCrQa4Do8k+qngAE xRAms7QHk4BotyO5HSKfYEwkP+u8WMa0x4G6cNM3M2iVClQXlcQfPj/dqxo221+XjDCJ P+KgsldLSiHSA41rs/kX+RpM3wslWnU92zdPBgf7pR5NT3Kiti38H2ciElrCQkpBh4x+ 6QA9X2wS+Nqs28s8BqGZ+BlOLujQm5kdLdEeD8+LvE7/8vNi8hbp8lNULIbgqSEHcjax nJcw== X-Forwarded-Encrypted: i=1; AFNElJ8F5voDKJdlFvv2RMFa/PmbtHBoI9X1hdCGx7XUhqFxjkHtTDFIGt7qTmKB0KLizN54Q/ur9vuDdHktAn3s@lists.postgresql.org X-Gm-Message-State: AOJu0YxpCmh+qVUt8+OqwWReatUDhyA0e+p2vo9f2SvLx+3v/FyLEN3A BC5+OJTv2unm3PxKwWT06DCxQCo56WHsWmHitYlF9L5y+P3qEjXlLx22WIHsZ/gO80v8GyFpwkp 6mPlCyv1A+DJBWaBH/RIazsrWgUfgLAI= X-Gm-Gg: Acq92OEixk/RNW2od2y+s/ULis52N5pYStkRaVeFVWlBfZzQ0UlysFS8dVx1byoPxb8 qonr2S9lRGgdg/B6uDUprlzMvJV2I4xpNl4UfCvClbVQbf80kGSWN2jHKuS4TedGX6JWNYSNBDb VtIiAyZ4xLYX1VVtlRIz1S07sNT3Qs0MD0pAwMfeqnYxBTsQujHplcSphnhNaruAXzlDhMq04rR vYAnNmhdcnWf03Th98vNY/AR93+qfuu14WZ2jYxj5bA0XUEZ9HjF8/lkedPjukHkyBoyUp5DkdJ U/ABdRdlJGasFRdN//ImvDv9UyRg+td78gM/dDPux6F13MqlRwoh+19UbKiDql/AYQXMjv1qNXq ASEh1KJ/O3g== X-Received: by 2002:a05:6512:24d0:b0:5a8:9d61:d89b with SMTP id 2adb3069b0e04-5aa323e1b8emr1537732e87.37.1779550188538; Sat, 23 May 2026 08:29:48 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Amit Kapila Date: Sat, 23 May 2026 08:29:35 -0700 X-Gm-Features: AVHnY4KRO66WrYHqOXflOzoLHfW2IyM94I19cWouaMUHHu08Po6yBqvDOh7n0sA Message-ID: Subject: Re: Adding REPACK [concurrently] To: Alvaro Herrera Cc: Antonin Houska , Mihail Nikalayeu , Andres Freund , Srinath Reddy Sadipiralla , Matthias van de Meent , Pg Hackers , Robert Treat Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, May 19, 2026 at 11:52=E2=80=AFAM Alvaro Herrera wrote: > > On 2026-May-14, Amit Kapila wrote: > > > The broader issue is that the entire logical decoding mechanism is > > designed to process cluster-wide transactions. This patch tries to > > bypass that foundational assumption, but only during the initial > > snapshot construction while processing running_xacts record. > > > > To be clear, I am not against the idea of db-specific snapshots to > > enable concurrent repacks. My concern is simply the time required to > > get the architecture right. In its current state, we need more time to > > carefully consider how this db-specific concept interacts with the > > rest of the logical decoding machinery, which is built for > > cluster-wide records. > > Hmm. So at this point I have to admit that the time I'll have before > beta 1 is going to be very scarce. You're probably right that it's > better to revert db-specific snapshots in pg19, and try again for 20. > Sounds reasonable. > The revert should be a simple patch. > I also think so. --=20 With Regards, Amit Kapila.