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 1w5iC7-003Xzu-0A for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Mar 2026 10:44:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w5iC5-002F1K-1n for pgsql-hackers@arkaria.postgresql.org; Thu, 26 Mar 2026 10:44:05 +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 1w5iC5-002F1C-0t for pgsql-hackers@lists.postgresql.org; Thu, 26 Mar 2026 10:44:05 +0000 Received: from mail-lj1-x236.google.com ([2a00:1450:4864:20::236]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w5iC3-000000017s2-2lVH for pgsql-hackers@lists.postgresql.org; Thu, 26 Mar 2026 10:44:04 +0000 Received: by mail-lj1-x236.google.com with SMTP id 38308e7fff4ca-38c26612508so6135151fa.3 for ; Thu, 26 Mar 2026 03:44:03 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774521842; cv=none; d=google.com; s=arc-20240605; b=AIxWhoSJCuzBK35EvIE6QvrCciB60eHrieSUxp5hg/vZRyjydoyAQ9hihGN8fRw1AT 0f+0rqzMzCNYJwhwz9WdR7rBt3U3JpyXjeKUfXHGdzptgqpZi8e6Eyjzbe/4WbBW0F8Y KyPlh8sdv424eBw0/+2asjEckVhcrA7THtX5UeFUN8p4LvQrhJdT6LBHSSnLisKvQ9gN BI3i2p0uFtedOL/7KgDOObcBdOBESepUVUFkyN9CSU5OnBPFqTBaOkIzounfcxjX9dLt CtCX2iVEv7DrdYXUj3K4Ik/733ai5zXuIffoiRcHBZHoVz454YcsJ1R+oGQnzK+PJru/ Ecpg== 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=4xQFIqWNMU8c+KhOZYA4z9ea/NlLxIYK5dSjY+wmJqw=; fh=gVewMLo+2c4PCIYa+SX8BUaJc5RpC9C1TgiXAjdxgyk=; b=CUhm6cHCuiOnYkXOR1CSDJHvYTg+FV70HYVe/ySWKViasmRSknvUj91VlhUEjSK0Yz 3Nc2BvhDMzlSSPntlldNrrpioWsKtjeZMJgW2sIhCkEUSrM8HO6KFkSptHSTkWkGfFwI pBAV1FLr7vcaw+DfeWq9xOA33pOY1bC5JA37QE6p9SBhUB1fp6EXEy9Wd8/NHMbZq2Fh lXMcTvox7jlgVA3LHAGHa3/9HYeA4KBhl7DfMABJk9bhm2NFrQDdwog4JoaZlavMQvv4 9MbPU1u5PT7lhsazormqflVWRcJbaB+wfbJ1pPpD3gbYZuGlGOLvkLAQI28gLZxhv0Av fLGQ==; 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=1774521842; x=1775126642; 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=4xQFIqWNMU8c+KhOZYA4z9ea/NlLxIYK5dSjY+wmJqw=; b=XR/+TmHlDObFIHZiJdo/WKZlXQ+hZmPPH/b+ZVc/Y/Sdgb9JLVDajBIfgqIUNmder1 9QLirYkRLskYZEX5kv/QSakvcmAcYO/PaKrlnXn90XMSJPXGVW+8LvBJd/je39O6C6yi DE0N96WYNmor7MLGyFsFm3S++D/58C7opvGewwNuLoA92NyK7tmdCdObp2l3kMzNTs95 9/Up7JCvXq3+DG8X9S3q2+gd/Avy0FnGbZfAFKGbFzcKUGsmxPgySkJG/wB7EHn5+gVw O9n4lPhsT8aGHyQxi86AScm/WzTF5V5QDFIRcm60A5aSUuro89pVpg4d0OYtUrwFB35l 0awQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774521842; x=1775126642; 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=4xQFIqWNMU8c+KhOZYA4z9ea/NlLxIYK5dSjY+wmJqw=; b=Ml6SGwb15L+jJ78y169RDg253mLHfuEtjoczLA0fXZaah0ebgRBlY989qSbZt/uhim rb81p3IGi5OUKVS8scoCc/TzXI9GyUwH20ihKKxCNKF67pNNX+GqXHr9UJ5ArCxaHh3+ ZKGmVKY4D/1Shg5BgXJWxVikBcxky6jdQ2EIvSU7FZS+t5Zo2/5HCrOBgVimtBAaRn3N cOUNIBKO/jAFuSgewcM2XbT14IBiYrYYEdu9JBR8v3NZ7pwTYsWVyDJHVADUHfsz2Icx IDBb4nt1fO4OlE6QLKHdDD3daR9xVoHmkg6yE8Rs1AFTKSBF2w2AfO1eYClzZZZmBLjw mtPQ== X-Forwarded-Encrypted: i=1; AJvYcCV5lxcvAwP1ZGL66q8yNegkDhW2yjkrlyAZipSCbA0uDQyeFj52OVq8M/cOrsQYDIz4QeRumaYZrEAwfOh8@lists.postgresql.org X-Gm-Message-State: AOJu0YyjWlpDGxgzSWiwOa4U0klAQz9dHGIrLlI+YKXCOA+mkpjFFAg/ IfcSkaFwu432UB7KCFHjIaRFApkcP/sbiFMRWQc/aJZrvvHsNTyQzmXpL+ELV6dmqxZi0a48Z87 ot4O4SyEmOnTiZRf3fyuWdBZaG/vgyyg= X-Gm-Gg: ATEYQzyH0GnBj1HsvpZ0rWZOTH+AM96PKlEsbSkLqbThvIzad6ut395MbAnoM8oHsBU JULvSwMGqKQpr1AwrT9Up/dHQ01K2XVgmfege+af2XRPShAlO93jyl0/pbQr1X4xX3wOvMntd4Q 4Y+k8UT8ZJN9XKrAQRzdUnB+YRWGIYpuK6F2ss8MhdLAzkbbtbzPILg8RsJAkW2DvhAYMblg5PA tVHQ3lLyKXC0TNZQPLDoPcmZi039eCOc1XJsGxoe9KYvH2UrRoYmevE2IMpvzVNseCG6sJmMHNY pdDgcshkM5PLiFQyeldMQO7WvY3tklw2RoZ0Robd X-Received: by 2002:a05:651c:888:b0:38a:6acb:eb13 with SMTP id 38308e7fff4ca-38c430cad80mr29793441fa.11.1774521841837; Thu, 26 Mar 2026 03:44:01 -0700 (PDT) MIME-Version: 1.0 References: <0c28fbd1-3320-4e9b-815c-6d62753aa063@wi3ck.info> In-Reply-To: From: Amit Kapila Date: Thu, 26 Mar 2026 16:13:50 +0530 X-Gm-Features: AQROBzBVihcR8Q29xQnRcIIbMC2jlrT77E9nitfRYQyBE7--LCj3vKA46A83_xo Message-ID: Subject: Re: Initial COPY of Logical Replication is too slow To: Masahiko Sawada Cc: Jan Wieck , pgsql-hackers@lists.postgresql.org 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 Wed, Mar 25, 2026 at 10:37=E2=80=AFAM Masahiko Sawada wrote: > > I figured out that the join with pg_publication works as a filter; > non-existence publication names are not passed to the function. If we > pass the list of publication names to the new function signature, > while we can simplify the patch and avoid a join, we would change the > existing function behavior so that it ignores non-existence > publications. > > I've attached the updated patch. The 0001 patch just incorporated the > review comments so far, and the 0002 patch is a draft change for the > above idea. Since pg_get_publication_tables(VARIADIC text) is not a > documented function, I think we can accept small behavior changes. So > I'm going to go with this direction. > What behaviour change are you referring to? In general, the direction appears right to me. --=20 With Regards, Amit Kapila.