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.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1tuXDd-009afz-VF
	for pgsql-hackers@arkaria.postgresql.org; Tue, 18 Mar 2025 13:42:57 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1tuXDc-00F5Ne-EA
	for pgsql-hackers@arkaria.postgresql.org; Tue, 18 Mar 2025 13:42:56 +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.94.2)
	(envelope-from <robertmhaas@gmail.com>)
	id 1tuXDc-00F5LR-3p
	for pgsql-hackers@lists.postgresql.org; Tue, 18 Mar 2025 13:42:56 +0000
Received: from mail-yw1-x112e.google.com ([2607:f8b0:4864:20::112e])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <robertmhaas@gmail.com>)
	id 1tuXDX-003ZdA-2o
	for pgsql-hackers@lists.postgresql.org;
	Tue, 18 Mar 2025 13:42:55 +0000
Received: by mail-yw1-x112e.google.com with SMTP id
 00721157ae682-6ff2adbba3fso44345577b3.2
        for <pgsql-hackers@lists.postgresql.org>;
 Tue, 18 Mar 2025 06:42:53 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1742305372; x=1742910172;
 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=ULkwlyFRsb+A8vb2fzKzx0RvxsJlyTnVykz4Bsgwff4=;
        b=XG4DBiQJbGU3nD1BGsazo9TqFnrY5JUbPAgqtUIZYm96CvxuFfif4cVAsmLcmAN6PX
         riCGhMvqG5AavzG9bXaZw5nuf9v+LcBmINvABIJxgINDlvpplnkkrDqiLc6wRbtvJcS5
         rUY4E3r4sRfVTbcwe5eA3waj1+0rXXQ5Nf+dBk7qlqYQSJSw93hvaRdAJ2NlBhB0RDKs
         lIzF+YhaJKm2kagyqp7aAIjKx9zZ2bOZ2S0KLUsZXP9Xt3b2HyC60Xz56c3J0BEijP9U
         q1Y1b1qWElCWvxUBsbvzj0nhSx9HTJ+rjak89yvosmOuiqjpuRq3fqJzF/3wQ+N/cxQw
         X4lA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1742305372; x=1742910172;
        h=content-transfer-encoding:cc:to:subject:message-id:date:from
         :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc
         :subject:date:message-id:reply-to;
        bh=ULkwlyFRsb+A8vb2fzKzx0RvxsJlyTnVykz4Bsgwff4=;
        b=ay1rSXTPchJGg/PufZvkGOGlMgYsLJVYeOP+uiIQxbb9SbX/yzdobylrj6YClHXsHm
         qnzpnAz5Z9AueJvcptPb5736RQPnfSOsDK2AnQaLrjvuTQvIIHitusVThT45WJOUn0Wl
         AuQ3E5gzFCXp2aC4jxsq/cmPJgsPhaMi6qa3iZqdkJCFHJCdCeg4anEiYjG3fODCXg2I
         vYdPVW5lT+55ENySVuzaMNt+Z0uvTqLmYdicYWNL4yNRTcPR6BQ4YOIexwqk04h3ZNZ9
         G61VPbUsM5SaAcbpXSIDq0mxfRIrc2RDzY+vQk6uywO5dZooFcXWgGq9eR4aCf8a6xDi
         iD3Q==
X-Forwarded-Encrypted: i=1;
 AJvYcCW7Xfdnk30/ms2xsJmEpSHO5OaTCbX6qMTDSyqWq4PbsC7Yg4Ssg1rL7GENuZUTYza8XxdQ2O8mGAlpn5lD@lists.postgresql.org
X-Gm-Message-State: AOJu0Yx3zCu8/02ZYCQe54PydSeNVXWnJ+kvIpiqpGOYdf63n4nzVOiQ
	tv8sWChrdlc3LUmkD421mLUQGz6Qw4IeqWeZsjbny+q5mhIMa70t1zM8YD7wjYYtHF7COXvI08l
	IRvrnr3vSi0TV6DWfxWbDP46KapVZRtg8
X-Gm-Gg: ASbGncsQLeFrs+t0hmmiADG1xpW1jG9oZBWZivmV8jWGkncgla3ShznlN0In0Ht2PTP
	nPEiXqrkUq1eMhf1FZFcaneYpvkZYjpLlgZphRwFpJUP7zbnSUP7IAn+7l/aJdGD6iSiHsegaMH
	9hewjdinX3jSO3DpjAcHq9mb5qsA==
X-Google-Smtp-Source: 
 AGHT+IGYPOM6UqN4lj3DDxCxeJWPtwP7zZO2g5AeC++f7lcfEXmXIyx6oxmfUVCE3KyQnfpU1zcWph8btZlExClzAWA=
X-Received: by 2002:a05:690c:4485:b0:6fd:2762:9d11 with SMTP id
 00721157ae682-6ffd743419fmr47091507b3.8.1742305371739; Tue, 18 Mar 2025
 06:42:51 -0700 (PDT)
MIME-Version: 1.0
References: <E1tsZjz-002Ctd-1G@gemulon.postgresql.org>
 <CA+Tgmoa+GkGNZ86QmqyuOCHWaBkOEJAEPfghEQ1d8_+KudVknw@mail.gmail.com>
 <CAA4eK1JBuaC9R7r22Da+56L-Gi3Xm3TTbutkJwe6i0847fhx8Q@mail.gmail.com>
In-Reply-To: 
 <CAA4eK1JBuaC9R7r22Da+56L-Gi3Xm3TTbutkJwe6i0847fhx8Q@mail.gmail.com>
From: Robert Haas <robertmhaas@gmail.com>
Date: Tue, 18 Mar 2025 09:42:38 -0400
X-Gm-Features: AQ5f1Jo3tD2fHdmzVppUDx7oo5NqhSobI2_ga6rps9t5Oz7IGvs5sPX4CzUaM_0
Message-ID: 
 <CA+TgmoaNw1v+pqJiAPV+Esv6KrweRKXERMZNsRk-xOVJrJVEAg@mail.gmail.com>
Subject: Re: pgsql: Avoid invalidating all RelationSyncCache entries on
 publication
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: Amit Kapila <akapila@postgresql.org>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BTgmoaNw1v%2BpqJiAPV%2BEsv6KrweRKXERMZNsRk-xOVJrJVEAg%40mail.gmail.com>
Precedence: bulk

On Tue, Mar 18, 2025 at 2:30=E2=80=AFAM Amit Kapila <amit.kapila16@gmail.co=
m> wrote:
> I think I should have mentioned the future use and other improvements
> of this work in the commit message.

OK, thanks for the background. Yes, it would have been helpful to
mention at least in general terms that it would unblock other
optimization work.

--=20
Robert Haas
EDB: http://www.enterprisedb.com