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 1oOiVU-0006gc-NJ for pgsql-committers@arkaria.postgresql.org; Thu, 18 Aug 2022 16:36:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oOiVS-0006dv-IV for pgsql-committers@arkaria.postgresql.org; Thu, 18 Aug 2022 16:36:30 +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 1oOiVS-0006bb-BD for pgsql-committers@lists.postgresql.org; Thu, 18 Aug 2022 16:36:30 +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 1oOiVP-0003Jw-PR for pgsql-committers@lists.postgresql.org; Thu, 18 Aug 2022 16:36:29 +0000 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 1oOiVO-00056o-8T for pgsql-committers@lists.postgresql.org; Thu, 18 Aug 2022 16:36:26 +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 1oOiVM-0008b4-Nq for pgsql-committers@lists.postgresql.org; Thu, 18 Aug 2022 16:36:25 +0000 Content-Type: multipart/mixed; boundary="===============8812929206581085993==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Improve performance of adjust_appendrel_attrs_multilevel. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Thu, 18 Aug 2022 16:36:25 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8812929206581085993== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW1wcm92ZSBwZXJmb3JtYW5jZSBvZiBhZGp1c3RfYXBwZW5kcmVsX2F0dHJzX211bHRpbGV2ZWwu CgpUaGUgcHJlc2VudCBpbXBsZW1lbnRhdGlvbnMgb2YgYWRqdXN0X2FwcGVuZHJlbF9hdHRyc19t dWx0aWxldmVsIGFuZAppdHMgc2libGluZyBhZGp1c3RfY2hpbGRfcmVsaWRzX211bHRpbGV2ZWwg YXJlIHZlcnkgbWVzc3ksIGJlY2F1c2UKdGhleSB3b3JrIGJ5IHJlY29uc3RydWN0aW5nIHRoZSBy ZWxpZHMgb2YgdGhlIGNoaWxkJ3MgaW1tZWRpYXRlCnBhcmVudCBhbmQgdGhlbiBzZWVpbmcgaWYg dGhhdCdzIGJtc19lcXVhbCB0byB0aGUgcmVsaWRzIG9mIHRoZQp0YXJnZXQgcGFyZW50LiAgQXNp ZGUgZnJvbSBiZWluZyBxdWl0ZSBpbmVmZmljaWVudCwgdGhpcyB3aWxsIG5vdAp3b3JrIHdpdGgg cGxhbm5lZCBmdXR1cmUgY2hhbmdlcyB0byBtYWtlIGpvaW5yZWxzJyByZWxpZCBzZXRzCmNvbnRh aW4gb3V0ZXItam9pbiByZWxpZHMgaW4gYWRkaXRpb24gdG8gYmFzZXJlbHMuCgpUaGUgd2hvbGUg dGhpbmcgY2FuIGJlIHNvbHZlZCBhdCBhIHN0cm9rZSBieSBhZGRpbmcgZXhwbGljaXQgcGFyZW50 CmFuZCB0b3BfcGFyZW50IGxpbmtzIHRvIGNoaWxkIFJlbE9wdEluZm9zLCBhbmQgbWFraW5nIHRo ZXNlIGZ1bmN0aW9ucwp3b3JrIHdpdGggUmVsT3B0SW5mbyBwb2ludGVycyBpbnN0ZWFkIG9mIHJl bGlkcy4gIERvaW5nIHRoYXQgaXMKc2ltcGxlciBmb3IgbW9zdCBjYWxsZXJzLCB0b28uCgpJbiBt eSBvcmlnaW5hbCB2ZXJzaW9uIG9mIHRoaXMgcGF0Y2gsIEkgZ290IHJpZCBvZgpSZWxPcHRJbmZv LnRvcF9wYXJlbnRfcmVsaWRzIG9uIHRoZSBncm91bmRzIHRoYXQgaXQgd2FzIG5vdyByZWR1bmRh bnQuCkhvd2V2ZXIsIHRoYXQgYWRkcyBhIGxvdCBvZiBjb2RlIGNodXJuIGluIHBsYWNlcyB0aGF0 IG90aGVyd2lzZSB3b3VsZApub3QgbmVlZCBjaGFuZ2luZywgYW5kIGFyZ3VhYmx5IHRoZSBleHRy YSBpbmRpcmVjdGlvbiBuZWVkZWQgdG8gZmV0Y2gKdG9wX3BhcmVudC0+cmVsaWRzIGluIHRob3Nl IHBsYWNlcyBjb3N0cyBzb21ldGhpbmcuICBTbyB0aGlzIHZlcnNpb24KbGVhdmVzIHRoYXQgZmll bGQgaW4gcGxhY2UuCgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzU1MzA4MC4xNjU3 NDgxOTE2QHNzcy5wZ2gucGEudXMKCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0t LS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8yZjE3YjU3MDE3ZTVm MTk5M2RiZTBmMzg5ZTAxZjEzMDJhNTQxMTk2CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0t LQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9lcXVpdmNsYXNzLmMgfCAxNiArKystLS0Kc3Jj L2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vcGxhbm5lci5jICAgIHwgMTYgKysrLS0tCnNyYy9iYWNr ZW5kL29wdGltaXplci91dGlsL2FwcGVuZGluZm8uYyB8IDkyICsrKysrKysrKysrKystLS0tLS0t LS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvdXRpbC9wYXRobm9kZS5jICAgfCAg OCArLS0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3V0aWwvcmVsbm9kZS5jICAgIHwgMjMgKysrKy0t LS0tCnNyYy9iYWNrZW5kL3BhcnRpdGlvbmluZy9wYXJ0cHJ1bmUuYyAgICB8ICA0ICstCnNyYy9p bmNsdWRlL25vZGVzL3BhdGhub2Rlcy5oICAgICAgICAgICB8IDEwICsrKy0Kc3JjL2luY2x1ZGUv b3B0aW1pemVyL2FwcGVuZGluZm8uaCAgICAgIHwgIDggKy0tCjggZmlsZXMgY2hhbmdlZCwgODMg aW5zZXJ0aW9ucygrKSwgOTQgZGVsZXRpb25zKC0pCgo= --===============8812929206581085993==--