Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oIdOT-0001ih-QM for pgsql-committers@arkaria.postgresql.org; Mon, 01 Aug 2022 21:56:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oIdOS-0005Xx-MK for pgsql-committers@arkaria.postgresql.org; Mon, 01 Aug 2022 21:56:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oIdOS-0005Xo-Ck for pgsql-committers@lists.postgresql.org; Mon, 01 Aug 2022 21:56:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oIdOO-0007Yu-ET for pgsql-committers@lists.postgresql.org; Mon, 01 Aug 2022 21:56:08 +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=/bqmXrJRHHXGtmrX7W/NNeqkAwt3ynNcBHJm61hqHHI=; b=JlGfx55vJ6vbkzZsgSoA0uLLxu na9Mzt+Ul6lQFpRZNnDqRlPLSITw4DKqdC+w/01gCVw7PA9bpbv6XdWJAA5gy9PJccWHWm1qmFKb8 ceD8RyRx6uWLSLhRaJnIOwQsp9IOrBLXhBueLySLwkulb6jtzzzKg/YWUH727r1wMIMUtv5aTFd/5 jxsa9YzjPwBbeSdyEDZ+ssm/me+j44QWLPGubGitlKxzf+TOiHxghBjiyHE6fA/jEWXI5aEN5IEVi dYEXdDM0EKab4+YHvTQq4MHaNIZ/kTTZck8whx7z3mc52JoJxhVmxexvBQ3fNJN7VYAkNsBWybOsU kdcuf/xQ==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oIdOM-0006Wp-Vs for pgsql-committers@lists.postgresql.org; Mon, 01 Aug 2022 21:56:02 +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 1oIdOL-002JRQ-CR for pgsql-committers@lists.postgresql.org; Mon, 01 Aug 2022 21:56:02 +0000 Content-Type: multipart/mixed; boundary="===============6592414201581812575==" MIME-Version: 1.0 From: David Rowley To: pgsql-committers@lists.postgresql.org Subject: pgsql: Have ExecFindPartition cache the last found partition X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 01 Aug 2022 21:56:02 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6592414201581812575== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SGF2ZSBFeGVjRmluZFBhcnRpdGlvbiBjYWNoZSB0aGUgbGFzdCBmb3VuZCBwYXJ0aXRpb24KCkhl cmUgd2UgYWRkIGNvZGUgd2hpY2ggZGV0ZWN0cyB3aGVuIEV4ZWNGaW5kUGFydGl0aW9uKCkgY29u dGludWFsbHkgZmluZHMKdGhlIHNhbWUgcGFydGl0aW9uIGFuZCBhZGQgYSBjYWNoaW5nIGxheWVy IHRvIGltcHJvdmUgcGFydGl0aW9uIGxvb2t1cApwZXJmb3JtYW5jZSBmb3Igc3VjaCBjYXNlcy4K CkJvdGggUkFOR0UgYW5kIExJU1QgcGFydGl0aW9uZWQgdGFibGVzIHRyYWRpdGlvbmFsbHkgcmVx dWlyZSBhIGJpbmFyeQpzZWFyY2ggZm9yIHRoZSBzZXQgb2YgRGF0dW1zIHRoYXQgYSBwYXJ0aXRp b24gbmVlZHMgdG8gYmUgZm91bmQgZm9yLiBUaGlzCmJpbmFyeSBzZWFyY2ggaXMgY29tbW9ubHkg dmlzaWJsZSBpbiBwcm9maWxlcyB3aGVuIGJ1bGsgbG9hZGluZyBpbnRvIGEKcGFydGl0aW9uZWQg dGFibGUuICBIZXJlIHdlIGFpbSB0byByZWR1Y2UgdGhlIG92ZXJoZWFkIG9mIGJ1bGstbG9hZGlu ZwppbnRvIHBhcnRpdGlvbmVkIHRhYmxlcyBmb3IgY2FzZXMgd2hlcmUgbWFueSBjb25zZWN1dGl2 ZSB0dXBsZXMgYmVsb25nIHRvCnRoZSBzYW1lIHBhcnRpdGlvbiBhbmQgbWFrZSB0aGUgcGVyZm9y bWFuY2Ugb2YgdGhpcyBvcGVyYXRpb24gY2xvc2VyIHRvCndoYXQgaXQgaXMgd2l0aCBhIHRyYWRp dGlvbmFsIG5vbi1wYXJ0aXRpb25lZCB0YWJsZS4KCldoZW4gd2UgZmluZCB0aGUgc2FtZSBwYXJ0 aXRpb24gMTYgdGltZXMgaW4gYSByb3csIHRoZSBuZXh0IHNlYXJjaCB3aWxsCnJlc3VsdCBpbiB1 cyBzaW1wbHkganVzdCBjaGVja2luZyBpZiB0aGUgY3VycmVudCBzZXQgb2YgdmFsdWVzIGJlbG9u Z3MgdG8KdGhlIGxhc3QgZm91bmQgcGFydGl0aW9uLiAgRm9yIExJU1QgcGFydGl0aW9uaW5nIHdl IHJlY29yZCB0aGUgaW5kZXggaW50bwp0aGUgUGFydGl0aW9uQm91bmRJbmZvJ3MgZGF0dW0gYXJy YXkuICBUaGlzIGFsbG93cyB1cyB0byBjaGVjayBpZiB0aGUKY3VycmVudCBEYXR1bSBpcyB0aGUg c2FtZSBhcyB0aGUgRGF0dW0gdGhhdCB3YXMgbGFzdCBsb29rZWQgdXAuICBUaGlzCm1lYW5zIGlm IGFueSBnaXZlbiBMSVNUIHBhcnRpdGlvbiBzdXBwb3J0cyBzdG9yaW5nIG11bHRpcGxlIGRpZmZl cmVudApEYXR1bSB2YWx1ZXMsIHRoZW4gdGhlIGNhY2hpbmcgb25seSB3b3JrcyB3aGVuIHdlIGZp bmQgdGhlIHNhbWUgdmFsdWUgYXMKd2UgZGlkIHRoZSBsYXN0IHRpbWUuICBGb3IgUkFOR0UgcGFy dGl0aW9uaW5nIHdlIHNpbXBseSBjaGVjayBpZiB0aGUgZ2l2ZW4KRGF0dW1zIGFyZSBpbiB0aGUg c2FtZSByYW5nZSBhcyB0aGUgcHJldmlvdXNseSBmb3VuZCBwYXJ0aXRpb24uCgpXZSBzdG9yZSB0 aGUgZGV0YWlscyBvZiB0aGUgY2FjaGVkIHBhcnRpdGlvbiBpbiBQYXJ0aXRpb25EZXNjIChpLmUu CnJlbGNhY2hlKSBzbyB0aGF0IHRoZSBjYWNoZWQgdmFsdWVzIGFyZSBtYWludGFpbmVkIG92ZXIg bXVsdGlwbGUKc3RhdGVtZW50cy4KCk5vIGNhY2hpbmcgaXMgZG9uZSBmb3IgSEFTSCBwYXJ0aXRp b25zLiAgVGhlIG1ham9yaXR5IG9mIHRoZSBjb3N0IGluIEhBU0gKcGFydGl0aW9uIGxvb2t1cHMg YXJlIGluIHRoZSBoYXNoaW5nIGZ1bmN0aW9uKHMpLCB3aGljaCB3b3VsZCBhbHNvIGhhdmUgdG8K YmUgZXhlY3V0ZWQgaWYgd2Ugd2VyZSB0byB0cnkgdG8gZG8gY2FjaGluZyBmb3IgSEFTSCBwYXJ0 aXRpb25lZCB0YWJsZXMuClNpbmNlIG1vc3Qgb2YgdGhlIGNvc3QgaXMgYWxyZWFkeSBpbmN1cnJl ZCwgd2UganVzdCBkb24ndCBib3RoZXIuICBXZSBhbHNvCmRvbid0IGRvIGFueSBjYWNoaW5nIGZv ciBMSVNUIHBhcnRpdGlvbnMgd2hlbiB3ZSBjb250aW51YWxseSBmaW5kIHRoZQp2YWx1ZXMgYmVp bmcgbG9va2VkIHVwIGJlbG9uZyB0byB0aGUgREVGQVVMVCBwYXJ0aXRpb24uICBXZSd2ZSBubwpj b3JyZXNwb25kaW5nIGluZGV4IGluIHRoZSBQYXJ0aXRpb25Cb3VuZEluZm8ncyBkYXR1bSBhcnJh eSBmb3IgdGhpcyBjYXNlLgpXZSBhbHNvIGRvbid0IGNhY2hlIHdoZW4gd2UgZmluZCB0aGUgZ2l2 ZW4gdmFsdWVzIG1hdGNoIHRvIGEgTElTVApwYXJ0aXRpb25lZCB0YWJsZSdzIE5VTEwgcGFydGl0 aW9uLiAgVGhpcyBpcyBzbyBjaGVhcCB0aGF0IHRoZXJlJ3Mgbm8KcG9pbnQgaW4gZG9pbmcgYW55 IGNhY2hpbmcgZm9yIHRoaXMuICBXZSBhbHNvIGRvbid0IGNhY2hlIGZvciBhIFJBTkdFCnBhcnRp dGlvbmVkIHRhYmxlJ3MgREVGQVVMVCBwYXJ0aXRpb24uCgpUaGVyZSBoYXZlIGJlZW4gYSBudW1i ZXIgb2YgZGlmZmVyZW50IHBhdGNoZXMgc3VibWl0dGVkIHRvIGltcHJvdmUKcGFydGl0aW9uIGxv b2t1cHMuIEhvdSwgWmhpamllIHN1Ym1pdHRlZCBhIHBhdGNoIHRvIGRldGVjdCB3aGVuIHRoZSB2 YWx1ZQpiZWxvbmdpbmcgdG8gdGhlIHBhcnRpdGlvbiBrZXkgY29sdW1uKHMpIHdlcmUgY29uc3Rh bnQgYW5kIGFkZGVkIGNvZGUgdG8KY2FjaGUgdGhlIHBhcnRpdGlvbiBpbiB0aGF0IGNhc2UuICBB bWl0IExhbmdvdGUgdGhlbiBpbXBsZW1lbnRlZCBhbiBpZGVhCnN1Z2dlc3RlZCBieSBtZSB0byBy ZW1lbWJlciB0aGUgbGFzdCBmb3VuZCBwYXJ0aXRpb24gYW5kIHN0YXJ0IHRvIGNoZWNrIGlmCnRo ZSBjdXJyZW50IHZhbHVlcyB3b3JrIGZvciB0aGF0IHBhcnRpdGlvbi4gIFRoZSBmaW5hbCBwYXRj aCBoZXJlIHdhcwp3cml0dGVuIGJ5IG1lIGFuZCB3YXMgZG9uZSBieSB0YWtpbmcgbWFueSBvZiB0 aGUgaWRlYXMgSSBsaWtlZCBmcm9tIHRoZQpwYXRjaGVzIGluIHRoZSB0aHJlYWQgYW5kIHJlZGVz aWduaW5nIG90aGVyIGFzcGVjdHMuCgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL09T MFBSMDFNQjU3MTY0OUIyN0U5MTJFQTZDQzRFRUYwMzk0MkQ5JTQwT1MwUFIwMU1CNTcxNi5qcG5w cmQwMS5wcm9kLm91dGxvb2suY29tCkF1dGhvcjogQW1pdCBMYW5nb3RlLCBIb3UgWmhpamllLCBE YXZpZCBSb3dsZXkKUmV2aWV3ZWQtYnk6IEFtaXQgTGFuZ290ZSwgSG91IFpoaWppZQoKQnJhbmNo Ci0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9y Zy9wZy9jb21taXRkaWZmLzM1OTJlMGZmOThiMTMwYzQyOGMxZDgwOTFmYzYxNzY3Zjc2MDg3MzIK Ck1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2V4ZWN1dG9yL2V4ZWNQ YXJ0aXRpb24uYyB8IDE5MiArKysrKysrKysrKysrKysrKysrKysrKysrKysrKysrLS0tLQpzcmMv YmFja2VuZC9wYXJ0aXRpb25pbmcvcGFydGRlc2MuYyAgfCAgIDYgKysKc3JjL2luY2x1ZGUvcGFy dGl0aW9uaW5nL3BhcnRkZXNjLmggIHwgIDI1ICsrKysrCjMgZmlsZXMgY2hhbmdlZCwgMjA0IGlu c2VydGlvbnMoKyksIDE5IGRlbGV0aW9ucygtKQoK --===============6592414201581812575==--