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 1pneSf-0005WY-Vq for pgsql-bugs@arkaria.postgresql.org; Sat, 15 Apr 2023 11:52:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pneRe-0002Mv-Vz for pgsql-bugs@arkaria.postgresql.org; Sat, 15 Apr 2023 11:51:54 +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 1pnL6r-0002Ky-Jk for pgsql-bugs@lists.postgresql.org; Fri, 14 Apr 2023 15:13:09 +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 1pnL6o-002sde-26 for pgsql-bugs@lists.postgresql.org; Fri, 14 Apr 2023 15:13:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=N52N22TzXT4vfOC3hyZUBUjQ8oWSwakhyk8glwBFGE8=; b=wdIby1J7zTNeo38dvJUQf9WJ56 D4uSLoxqLECCjRvqeb5nFeRuUMbEsHKS+phliX3mYGhS15ABG5Rxxl0kGBiZiNWaSc9YS5lSWjuCi yWi4KR5aDO0ZF7BU/UAwLvbkrQPyJeIEMmyyHRO8fIKpu54cACaAR4eLuHFDk3scLTWzqldRQMUT8 iKGpa3W5ir/OOwdJ9vwrdxdUheIt9TE5b/kv4QxSWQSiLO1S9nETlOKu9O1l1XpAZS0ZC1B6LueS3 UprK6Jw0VrByS6xzYQ5ItEj4QtR9cBALxY57E5CbX/kwAQhZkrFvCQEM4NI0skleZGnHmlsCfu3ro If8nAZkQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pnL6m-0001Hg-87 for pgsql-bugs@lists.postgresql.org; Fri, 14 Apr 2023 15:13:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pnL6l-00Ag4N-43 for pgsql-bugs@lists.postgresql.org; Fri, 14 Apr 2023 15:13:02 +0000 Content-Type: multipart/mixed; boundary="===============4731200636925717862==" MIME-Version: 1.0 Subject: BUG #17896: xmlagg exponentially slower than string_agg equivalent To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: sf_postgresql@informationsoftworks.com Reply-To: sf_postgresql@informationsoftworks.com, pgsql-bugs@lists.postgresql.org Date: Fri, 14 Apr 2023 15:12:59 +0000 Message-ID: <17896-f4bf54f99b6a3089@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4731200636925717862== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzg5NgpMb2dnZWQgYnk6ICAgICAgICAgIFBhdWwgV2VocgpFbWFpbCBh ZGRyZXNzOiAgICAgIHNmX3Bvc3RncmVzcWxAaW5mb3JtYXRpb25zb2Z0d29ya3MuY29tClBvc3Rn cmVTUUwgdmVyc2lvbjogMTQuNgpPcGVyYXRpbmcgc3lzdGVtOiAgIERlYmlhbiBHTlUvTGludXgg MTEgKGJ1bGxzZXllKQpEZXNjcmlwdGlvbjogICAgICAgIAoKTm90IGEgYnVnIGluIHRlcm1zIG9m IGZ1bmN0aW9uYWxpdHksIGJ1dCBhbiBpbnRlcmVzdGluZyBkaWZmZXJlbmNlIGluCnBlcmZvcm1h bmNlLiAgSWYgbm90aGluZyBlbHNlIGhvcGVmdWxseSBkb2N1bWVudGluZyB0aGlzIHdvcmstYXJv dW5kIG1pZ2h0CmhlbHAgYW55b25lIGVsc2UgdGhhdCBtYXkgYmUgYWdncmVnYXRpbmcgeG1sZWxl bWVudHMgb24gdGhpcyBzY2FsZS4NCg0KVXNpbmcgeG1sYWdnKHhtbCkgb24gNjAsMDAwIHJvd3Mg b2YgeG1sIHRha2VzIDE2LjNzIG9uIG15IGhhcmR3YXJlLiAgSWYgSQpyZXBsYWNlICJ4bWxhZ2co eG1sKSIgd2l0aCAic3RyaW5nX2FnZyh4bWw6OnRleHQpOjp4bWwiLCBJIGNhbiBnZXQgdGhlIHNh bWUKcmVzdWx0IGluIDAuMDUxcy4gIChzZWUgc2NyaXB0IGJlbG93KS4gSSBoYXZlIGNvbmZpcm1l ZCB0aGlzIGJlaGF2aW9yIG9uCm90aGVyIGhhcmR3YXJlLCBhbmQgaW4gdmVyc2lvbnMgMTEuMTks IDEzLjcgYW5kIDE0LjYuDQoNCkFsc28sIHdoaWxlIHN0cmluZ19hZ2coKSBzZWVtcyB0byBzY2Fs ZSBsaW5lYXJseSAoTyhuKSksIHhtbGFnZygpIHNlZW1zIHRvCnNjYWxlIHNvbWV3aGF0IHN0ZWVw ZXIgKE8obl4yKT8pLiAgUnVubmluZyB0aGUgc2FtZSBzY3JpcHQgb24gdmFyaW91cyBzZWNvbmQK cGFyYW1ldGVyIHZhbHVlcyBpbiB0aGUgZ2VuZXJhdGVfc2VyaWVzKCkgZnVuY3Rpb24gcHJvZHVj ZWQgdGhlc2UgcmVzdWx0czoNCg0KICAgICAgIHwgICAgICAgICAgICAgICAgfCAgIHN0cmluZ19h Z2coKQ0KIFJvd3MgIHwgIHhtbGFnZygpLCBtcyAgfCB3b3JrLWFyb3VuZCwgbXMNCi0tLS0tLS0r LS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0NCiAxMDAwMCB8ICAgICAgMzE0LjQ0 ICAgIHwgICAgICAxNC4yMDcNCiAyMDAwMCB8ICAgIDExMTEuMTA0ICAgIHwgICAgICAyMy43NTQN CiAzMDAwMCB8ICAgIDI1NTguNzA2ICAgIHwgICAgICAzNy41NjUNCiA0MDAwMCB8ICAgIDUzMDYu NjMxICAgIHwgICAgICA1MS4wMjENCiA1MDAwMCB8ICAgMTAxNzguNDk2ICAgIHwgICAgICA2MS45 MjgNCiA2MDAwMCB8ICAgMTYzMDYuNjUxICAgIHwgICAgICA3NS4xNDYNCiA3MDAwMCB8ICAgMjM4 NTMuMzMxICAgIHwgICAgICA5My41MjkNCiA4MDAwMCB8ICAgMzIyNDMuOTA4ICAgIHwgICAgIDEw NS4zMTgNCg0KDQotLS0tLS0tLSBwc3FsIHRlc3Qgc2NyaXB0IG91dHB1dCAtLS0tLS0tLS0tLS0t LS0tDQoNCnNlbGVjdCB2ZXJzaW9uKCk7DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgIHZlcnNpb24gICAgICAgICAgCiAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBQb3N0 Z3JlU1FMIDE0LjYgKERlYmlhbiAxNC42LTEucGdkZzExMCsxKSBvbiB4ODZfNjQtcGMtbGludXgt Z251LCBjb21waWxlZApieSBnY2MgKERlYmlhbiAxMC4yLjEtNikgMTAuMi4xIDIwMjEwMTEwLCA2 NC1iaXQNCigxIHJvdykNCg0KY3JlYXRlIHRlbXBvcmFyeSB0YWJsZSB4bWxzYW1wbGUgYXMNCnNl bGVjdCB4bWxlbGVtZW50KG5hbWUgdGVzdCwgJ3Rlc3QnKSBhcyB4bWwNCmZyb20gZ2VuZXJhdGVf c2VyaWVzKDEsNjAwMDApIGFzIGkgKGkpDQo7DQpTRUxFQ1QgNjAwMDANCmV4cGxhaW4gYW5hbHl6 ZSBzZWxlY3QgeG1sYWdnKHhtbCkgYXMgeG1sIGZyb20geG1sc2FtcGxlOw0KICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFOICAgICAg ICAgICAgIAogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQotLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCiBB Z2dyZWdhdGUgIChjb3N0PTEwMzQuMTAuLjEwMzQuMTEgcm93cz0xIHdpZHRoPTMyKSAoYWN0dWFs CnRpbWU9MTYzMDQuMDA5Li4xNjMwNC4wMTAgcm93cz0xIGxvb3BzPTEpDQogICAtPiAgU2VxIFNj YW4gb24geG1sc2FtcGxlICAoY29zdD0wLjAwLi45MDMuODggcm93cz01MjA4OCB3aWR0aD0zMikK KGFjdHVhbCB0aW1lPTAuMDIxLi4xMi43NTQgcm93cz02MDAwMCBsb29wcz0xKQ0KIFBsYW5uaW5n IFRpbWU6IDAuMzUxIG1zDQogRXhlY3V0aW9uIFRpbWU6IDE2MzA2LjY1MSBtcw0KKDQgcm93cykN Cg0KZXhwbGFpbiBhbmFseXplIHNlbGVjdCBzdHJpbmdfYWdnKHhtbDo6dGV4dCwgJycpOjp4bWwg YXMgeG1sIGZyb20KeG1sc2FtcGxlOw0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICBRVUVSWSBQTEFOICAgICAgICAgICAgIAogICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICANCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQogQWdncmVnYXRlICAoY29zdD0xMDM0LjEw Li4xMDM0LjEyIHJvd3M9MSB3aWR0aD0zMikgKGFjdHVhbAp0aW1lPTYzLjA3Ni4uNjMuMDc4IHJv d3M9MSBsb29wcz0xKQ0KICAgLT4gIFNlcSBTY2FuIG9uIHhtbHNhbXBsZSAgKGNvc3Q9MC4wMC4u OTAzLjg4IHJvd3M9NTIwODggd2lkdGg9MzIpCihhY3R1YWwgdGltZT0wLjAxMC4uNS41OTEgcm93 cz02MDAwMCBsb29wcz0xKQ0KIFBsYW5uaW5nIFRpbWU6IDAuMDk4IG1zDQogRXhlY3V0aW9uIFRp bWU6IDc1LjE0NiBtcw0KKDQgcm93cykKCg== --===============4731200636925717862==--