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 ) id 1tsZk5-003Gg2-Kd for pgsql-committers@arkaria.postgresql.org; Thu, 13 Mar 2025 04:00:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tsZk4-002sTu-3O for pgsql-committers@arkaria.postgresql.org; Thu, 13 Mar 2025 04:00:20 +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 ) id 1tsZk3-002sTk-Kl for pgsql-committers@lists.postgresql.org; Thu, 13 Mar 2025 04:00:19 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tsZjz-002ZZi-26 for pgsql-committers@lists.postgresql.org; Thu, 13 Mar 2025 04:00:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=7YfHdSyGtQmf11ELoSFwz0UkXNPwxksCKc+RpTXxZRQ=; b=Lty6BUGwoqB4x8GwqTMELJ0/EI 3hBBQyKQYa1leTpdQCPXfpAJYw3G5hMGXw6oJgzkchpaDjwRmqH4DJbvKbbO3pq8v37FgLDpr/ukd vj8snxLXpDOpWzr2/K2J6HH+JNUeR7dAbsF2BqqHrxDQPfnjCb6YnF7gG0oOCqAyZfcJXJGC5I60Z d/TMvslp40HU27uzpKkunTLIAxnQXk4tbe2hxMLuxIbrxgEHhr/54NtVzAcxUb/gKLyNkpuZev0yT ow4b2s5kOVQVUlIModbfvXjaSBMgwPDMgQ3/JIgTHfuKEOzHZID2sLQ6eqTldityMZxQVD3JeM87o fQ6GFQ6A==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tsZjz-006Zlt-Hd for pgsql-committers@lists.postgresql.org; Thu, 13 Mar 2025 04:00:15 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1tsZjz-002Ctd-1G for pgsql-committers@lists.postgresql.org; Thu, 13 Mar 2025 04:00:15 +0000 Content-Type: multipart/mixed; boundary="===============3151097393020460414==" MIME-Version: 1.0 From: Amit Kapila To: pgsql-committers@lists.postgresql.org Subject: pgsql: Avoid invalidating all RelationSyncCache entries on publication X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 13 Mar 2025 04:00:15 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============3151097393020460414== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXZvaWQgaW52YWxpZGF0aW5nIGFsbCBSZWxhdGlvblN5bmNDYWNoZSBlbnRyaWVzIG9uIHB1Ymxp Y2F0aW9uIHJlbmFtZS4KCk9uIFB1YmxpY2F0aW9uIHJlbmFtZSwgd2UgbmVlZCB0byBvbmx5IGlu dmFsaWRhdGUgdGhlIFJlbGF0aW9uU3luY0NhY2hlCmVudHJpZXMgY29ycmVzcG9uZGluZyB0byBy ZWxhdGlvbnMgdGhhdCBhcmUgcGFydCBvZiB0aGUgcHVibGljYXRpb24gYmVpbmcKcmVuYW1lZC4K CkFzIHBhcnQgb2YgdGhpcyBwYXRjaCwgd2UgaW50cm9kdWNlIGEgbmV3IGludmFsaWRhdGlvbiBt ZXNzYWdlIHRvCmludmFsaWRhdGUgdGhlIGNhY2hlIG1haW50YWluZWQgYnkgdGhlIGxvZ2ljYWwg ZGVjb2Rpbmcgb3V0cHV0IHBsdWdpbi4gV2UKY2FuJ3QgdXNlIGV4aXN0aW5nIHJlbGNhY2hlIGlu dmFsaWRhdGlvbiBmb3IgdGhpcyBwdXJwb3NlLCBhcyB0aGF0IHdvdWxkCnVubmVjZXNzYXJpbHkg Y2F1c2UgcmVsY2FjaGUgaW52YWxpZGF0aW9ucyBpbiBvdGhlciBiYWNrZW5kcy4KClRoaXMgd2ls bCBpbXByb3ZlIHBlcmZvcm1hbmNlIGJ5IGJ1aWxkaW5nIGZld2VyIHJlbGF0aW9uIGNhY2hlIGVu dHJpZXMKZHVyaW5nIGxvZ2ljYWwgcmVwbGljYXRpb24uCgpBdXRob3I6IEhheWF0byBLdXJvZGEg PGt1cm9kYS5oYXlhdG9AZnVqaXRzdS5jb20+CkF1dGhvcjogU2hsb2sgS3lhbCA8c2hsb2sua3lh bC5vc3NAZ21haWwuY29tPgpSZXZpZXdlZC1ieTogSG91IFpoaWppZSA8aG91emouZm5zdEBmdWpp dHN1LmNvbT4KUmV2aWV3ZWQtYnk6IEFtaXQgS2FwaWxhIDxhbWl0LmthcGlsYTE2QGdtYWlsLmNv bT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9PU0NQUjAxTUIxNDk2NkMwOUFBMjAx RUZGQTcwNjU3NkE3RjVDOTJAT1NDUFIwMU1CMTQ5NjYuanBucHJkMDEucHJvZC5vdXRsb29rLmNv bQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0 Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzNhYmU5ZGMxODg5MmI5ZjY5YmI0OGEyZWIyMWZiZTVj ZjM0OGE0ODkKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2FjY2Vz cy9ybWdyZGVzYy9zdGFuZGJ5ZGVzYy5jICAgfCAgIDIgKwpzcmMvYmFja2VuZC9jb21tYW5kcy9h bHRlci5jICAgICAgICAgICAgICAgIHwgIDE2ICsrKysKc3JjL2JhY2tlbmQvY29tbWFuZHMvcHVi bGljYXRpb25jbWRzLmMgICAgICB8ICAzOSArKysrKysrKysKc3JjL2JhY2tlbmQvcmVwbGljYXRp b24vcGdvdXRwdXQvcGdvdXRwdXQuYyB8ICAgOCArLQpzcmMvYmFja2VuZC91dGlscy9jYWNoZS9p bnZhbC5jICAgICAgICAgICAgIHwgMTI1ICsrKysrKysrKysrKysrKysrKysrKysrKysrKysKc3Jj L2luY2x1ZGUvY29tbWFuZHMvcHVibGljYXRpb25jbWRzLmggICAgICB8ICAgMSArCnNyYy9pbmNs dWRlL3BnX2NvbmZpZ19tYW51YWwuaCAgICAgICAgICAgICAgfCAgIDggKy0Kc3JjL2luY2x1ZGUv c3RvcmFnZS9zaW52YWwuaCAgICAgICAgICAgICAgICB8ICAyNCArKysrLS0Kc3JjL2luY2x1ZGUv dXRpbHMvaW52YWwuaCAgICAgICAgICAgICAgICAgICB8ICAxMCArKysKc3JjL3Rlc3Qvc3Vic2Ny aXB0aW9uL3QvMDA3X2RkbC5wbCAgICAgICAgICB8ICA4NSArKysrKysrKysrKysrKysrKysrCjEw IGZpbGVzIGNoYW5nZWQsIDMwMiBpbnNlcnRpb25zKCspLCAxNiBkZWxldGlvbnMoLSkKCg== --===============3151097393020460414==--