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 1wA5LH-00237R-17 for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Apr 2026 12:15:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wA5LE-00H37B-2V for pgsql-hackers@arkaria.postgresql.org; Tue, 07 Apr 2026 12:15:37 +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 1wA5LE-00H372-1Z for pgsql-hackers@lists.postgresql.org; Tue, 07 Apr 2026 12:15:36 +0000 Received: from mail-lj1-x235.google.com ([2a00:1450:4864:20::235]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wA5LC-000000015mZ-2nCC for pgsql-hackers@lists.postgresql.org; Tue, 07 Apr 2026 12:15:36 +0000 Received: by mail-lj1-x235.google.com with SMTP id 38308e7fff4ca-38ddd8d3b7fso24545591fa.3 for ; Tue, 07 Apr 2026 05:15:34 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1775564129; cv=none; d=google.com; s=arc-20240605; b=OCd8gNImEQpThp6DEZYzzWPMzfdVBhF17pRGRw5MdhpJTcqVY/hPW45K9CKg47SYOg /UNboNni71s7uUgHg9j9DcKfqCXDeb68ZK1+lndrDhxYuuyPpHdHJZNZ+duINdzE5t4P d3AAHj9/5VxV3squWavx/doTh9cvUl13qyCy7tR0gxTg/kPYwtwL4bK4NbZ5BIFai0Mb RS1z09jUUH1NlI9zZbfg561j2nSqBgglpyTB6irW8vEMZVlQxTaGXmOrKq7CAtyekcAW 1LXGVUnM6fgIYoWBy7OendnSvXKEH5+iRezNRoqDptupJH3Y1ruYHPd5qXal6FBgGAUy zuEA== 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=UYlOQ0A9tVlSH94mMPX2n1WLHHRCM86O4PxEYncoYCY=; fh=1JItCcGPhZ/OtVxPBqHQU6mLN7aPm933olzIhE039yY=; b=V58DwV3OLP2vzBBMYvq7DhzG2hAQRWRXCbHbU6atjfdN8od2J1VBvHwvqzV9QiqV0L DVnNkHRMD/LyRlhONS272Q7me/Kt1hLs9eLab8aWkHQ+QboOK0X7Xg2jd5MO4HzuCA5I wVkgYyQwUbSZI/4m/Dxn6k7w0ODIcjcS9B9vJ+9EJIj3b86GC128qgkYGcLQlXLFWj+V M+zGcXNNhpxqsfayVgcxE3cMT5SVb2gmNEOjyeDdFZl/PreFLLZ/5dM8kP10ntN3kuK5 It7eYKnMSidcGnQU4DkaxmBvc0T/6BXWO0hMoav5iS+T+CgbgXKXnKJvZxzJIUNADR4g N1cg==; 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=1775564129; x=1776168929; 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=UYlOQ0A9tVlSH94mMPX2n1WLHHRCM86O4PxEYncoYCY=; b=ioBeWQPgl0FVqI2mFEIxZ5lPyKpmYGogBytxeJCHFfRfg6YcddxvUq2YgqzSYskFYG W6Ds4ggLF2IUMizeaucf23Nt7+nDvox72+rhkH36zuj/vEQL7MrVlm37mEcR7FFC1qPl zGFioYCkeu0m2+Z1UhRiztrY6RF9bDbhSDe5fYnfKhNqifFuhAlkdArARHCDbEulO/KN HDItvfjgkA1M3+7X41tQM2bWmJO71pNMWd/VUrfYtyhfVrZLUHS507V5Dz2gKWGTThxd eSOtCIINAji78SMWPEOs6Pcy7L3qD3hxk6sWPTUI2pia8KfIX6ltyga6m0gmRqJo7nMB Hcsw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775564129; x=1776168929; 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=UYlOQ0A9tVlSH94mMPX2n1WLHHRCM86O4PxEYncoYCY=; b=tYJpn7oSnYe8Kx4CoyoZDWFmycdxTL3GSyYsDnCVcoggBJh2C+WKAOTtWol3pil9/y O1YB8yobA9Tgq2JwSu3O0Pdzy2ioat69V9N11Fmm7BuOSrsjpoWXo+pw6DUVC1XYa3dd qxVHVkM75EI8uO+vM3jax9SplKGPSWYY8dwaSIIIFoOKMibGroMuOfM/tMvp3bxnKhYY rT+E35zA00A4P8759k0Rmn5V/ne3vgSYxlOppp6ZfhkM3rYoVShuQwgjuMunwi/7Dn2a 727csnl/JHay66lzIWsznh/XMwjigP3Zs3yb0KdzumxEMvqjuxT3kafS2secacywC9/M oYIA== X-Forwarded-Encrypted: i=1; AJvYcCXGAZxwnxctAKyzMH8V2xR6kp7sOnnswHFxmlgrq1NUmZXnQS6dWXWxBvmxS7eOtXnzD7KF0bA+zu/t3ooC@lists.postgresql.org X-Gm-Message-State: AOJu0Yy/VMP3UHHAZd2kv7gZ6v2Js46FixSsdjcRLVqBlQPGXNV9yY29 zvDYmiM9L9lSaEeVMTVUeCGnbH80oGlJQ/YWN41d5JW1st3q8lTs+aC85Juy6UFzSLm+PvdDfC0 TMvfC1KyayHKj33HjtHvradkZUxipPEU= X-Gm-Gg: AeBDies9guRH/2g86x1YVHSVMDFkbPmlG30IBIX9AeC0y/ymyV3Yl1EG0cpMjb8vS7b mHwBObbyBK6+aFtC6h8LAZK/6SlxImSPO+6BXv4/Yo+LYfZ1sOwWXW0+822qF/TWBm0cfIpg+nL EQOlp/3/UVznqWvqCJ/BEMoY2/GcaYesZMmIMiOJglM4Ewo98lNfws2aaqXbCemMlUdwtqENUla 9zRIjHJDPygFZ0EkkHZ8Aw/r6+USFT/hIRLsEt3onMMmgjOF3aYSThAMfBMw0/Zbs4IKFgbgRfP F1o1/DQUdbmWio9WxGnLQhhOg4UH/mVQ+TZXqgy+7A== X-Received: by 2002:a05:651c:418a:b0:38e:1714:b674 with SMTP id 38308e7fff4ca-38e1714be1fmr7772391fa.33.1775564128871; Tue, 07 Apr 2026 05:15:28 -0700 (PDT) MIME-Version: 1.0 References: <202604062213.cgo352cdsgsm@alvherre.pgsql> In-Reply-To: <202604062213.cgo352cdsgsm@alvherre.pgsql> From: Amit Kapila Date: Tue, 7 Apr 2026 17:45:16 +0530 X-Gm-Features: AQROBzANa0bmBv5ewYKcJh3eh81ToFYFOl_9MPsrbPKwql3o0zhYjLjczbrbd4o Message-ID: Subject: Re: Adding REPACK [concurrently] To: Alvaro Herrera Cc: Mihail Nikalayeu , Antonin Houska , 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, Apr 7, 2026 at 3:52=E2=80=AFAM Alvaro Herrera wrote: > > Anyway, here's the three missing parts. I have not yet edited the > deadlock-checker one to protect autovacuum from processing tables under > repack. > I have a question based on 0001's commit message: "This patch adds a new option to logical replication output plugin, to declare that it does not use shared catalogs (i.e. catalogs that can be changed by transactions running in other databases in the cluster).". In which cases, currently plugin needs to access multi-database transactions or transactions that need to access shared catalogs and on what basis a plugin can decide that the changes it requires won't need any such access. --=20 With Regards, Amit Kapila.