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 1sZNo4-000df2-Qw for pgsql-committers@arkaria.postgresql.org; Thu, 01 Aug 2024 04:52:53 +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 1sZNo2-002N7b-D3 for pgsql-committers@arkaria.postgresql.org; Thu, 01 Aug 2024 04:52:50 +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 1sZNo1-002N7T-UB for pgsql-committers@lists.postgresql.org; Thu, 01 Aug 2024 04:52:50 +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.94.2) (envelope-from ) id 1sZNny-002Y6J-LB for pgsql-committers@lists.postgresql.org; Thu, 01 Aug 2024 04:52:49 +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=wLHCytkxEugJHppnvIOeJrKK7Wwb1X+AwrOvmHBIp2I=; b=gozJIgiC4hqzxJ0ap/adItiTWV dlN5o1CoXjss0AMdKkNS9TcJfc3kqZc0M0Ip1bs7wvRC2UI2Z6IInIntrWssgmGGjfrhxkQbSyHtU TN9Typu1CXdLOkRZd/q5d6ecJqZdjyqdjx9TUycCxOCXmX06X+MfxMkCETTPyJ3Z7TVEknBOH//W9 2eAkiPWSnLkSNVYnKsOiZL14CsePsH9VMF9MvNTrr9sFzxmFBmxVfcj14LwnNPPcbA0vAGhIjUpjz osTOyOlXAWM7//lsBKeMxPlpgPfmE17iyTY+AaX6WPVveTeXDP/2J7Ba69V1UMa1a1DvH5GDd4MHw FnfOehNw==; 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 1sZNnx-007leR-A5 for pgsql-committers@lists.postgresql.org; Thu, 01 Aug 2024 04:52:45 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sZNnw-0028xn-Op for pgsql-committers@lists.postgresql.org; Thu, 01 Aug 2024 04:52:44 +0000 Content-Type: multipart/mixed; boundary="===============0334891297728637542==" MIME-Version: 1.0 From: Amit Kapila To: pgsql-committers@lists.postgresql.org Subject: pgsql: Avoid duplicate table scans for cross-partition updates during l X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 01 Aug 2024 04:52:44 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0334891297728637542== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXZvaWQgZHVwbGljYXRlIHRhYmxlIHNjYW5zIGZvciBjcm9zcy1wYXJ0aXRpb24gdXBkYXRlcyBk dXJpbmcgbG9naWNhbCByZXBsaWNhdGlvbi4KCldoZW4gcGVyZm9ybWluZyBhIGNyb3NzLXBhcnRp dGlvbiB1cGRhdGUgaW4gdGhlIGFwcGx5IHdvcmtlciwgaXQKbmVlZGxlc3NseSBzY2FucyB0aGUg b2xkIHBhcnRpdGlvbiB0d2ljZSwgcmVzdWx0aW5nIGluIG5vdGljZWFibGUKb3ZlcmhlYWQuCgpU aGlzIGNvbW1pdCBvcHRpbWl6ZXMgaXQgYnkgcmVtb3ZpbmcgdGhlIHJlZHVuZGFudCB0YWJsZSBz Y2FuLgoKQXV0aG9yOiBIb3UgWmhpamllClJldmlld2VkLWJ5OiBIYXlhdG8gS3Vyb2RhLCBBbWl0 IEthcGlsYQpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL09TMFBSMDFNQjU3MTYyM0Uz OTk4NEQ5NENCQjUzNDFEOTk0QUIyQE9TMFBSMDFNQjU3MTYuanBucHJkMDEucHJvZC5vdXRsb29r LmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5w b3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2E2N2RhNDllMWQ5ODNmYzc2NjJmNzg1NGU5ZWVj NWRlYmJkMTQ0NDYKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL3Jl cGxpY2F0aW9uL2xvZ2ljYWwvd29ya2VyLmMgfCAyMCArKysrKysrKysrLS0tLS0tLS0tLQoxIGZp bGUgY2hhbmdlZCwgMTAgaW5zZXJ0aW9ucygrKSwgMTAgZGVsZXRpb25zKC0pCgo= --===============0334891297728637542==--