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 1nZhY5-00032Y-LC for pgsql-committers@arkaria.postgresql.org; Wed, 30 Mar 2022 23:16:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nZhX5-0007EX-6a for pgsql-committers@arkaria.postgresql.org; Wed, 30 Mar 2022 23:15:19 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nZhX4-0007EM-N0 for pgsql-committers@lists.postgresql.org; Wed, 30 Mar 2022 23:15:18 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nZhX0-0004oA-VZ for pgsql-committers@lists.postgresql.org; Wed, 30 Mar 2022 23:15:17 +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=dCz+3dFUy2hXoqn95ep+v9H5AfflQl11xcPuz88vOB0=; b=OvBo/m4HC556hqQTVijKoZjkIF MnqxngxYH+1PuFf7FSoZbBnK6v59qmp1a6hSQbZKadlTGIE4136SmRY31J3HREdu9Gtds6anA7jAM JaGIVIi8kkP9zRDjAAWeM5iPF4jv3t0bDfHIRGcoFEKYyy5v3NQP+V7gieKzoarPnb4o3OQoM4+cK Q0Y3WYTEszeU4BNgWA7quTIkQ5GkD32DdSW5vUTgMTbZw0sFYxv8IN29uK83d9IeT82sDQNewNwoC Dvp1uz7YG18Ti9uNWiajj95ii1k1mbg0h73841Y/aLQ3KXTvVYO0DhRFfvny7p06SR2pQnCx/pUxu vBuo0Npg==; 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 1nZhX0-00007t-Ah for pgsql-committers@lists.postgresql.org; Wed, 30 Mar 2022 23:15:14 +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 1nZhWy-00047C-Sa for pgsql-committers@lists.postgresql.org; Wed, 30 Mar 2022 23:15:13 +0000 Content-Type: multipart/mixed; boundary="===============8596130844016550399==" MIME-Version: 1.0 From: Tomas Vondra To: pgsql-committers@lists.postgresql.org Subject: pgsql: Optimize order of GROUP BY keys X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Wed, 30 Mar 2022 23:15:13 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8596130844016550399== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 T3B0aW1pemUgb3JkZXIgb2YgR1JPVVAgQlkga2V5cwoKV2hlbiBldmFsdWF0aW5nIGEgcXVlcnkg d2l0aCBhIG11bHRpLWNvbHVtbiBHUk9VUCBCWSBjbGF1c2UgdXNpbmcgc29ydCwKdGhlIGNvc3Qg bWF5IGJlIGhlYXZpbHkgZGVwZW5kZW50IG9uIHRoZSBvcmRlciBpbiB3aGljaCB0aGUga2V5cyBh cmUKY29tcGFyZWQgd2hlbiBidWlsZGluZyB0aGUgZ3JvdXBzLiBHcm91cGluZyBkb2VzIG5vdCBp bXBseSBhbnkgb3JkZXJpbmcsCnNvIHdlJ3JlIGFsbG93ZWQgdG8gY29tcGFyZSB0aGUga2V5cyBp biBhcmJpdHJhcnkgb3JkZXIsIGFuZCBhIEhhc2ggQWdnCmxldmVyYWdlcyB0aGlzLiBCdXQgZm9y IEdyb3VwIEFnZywgd2Ugc2ltcGx5IGNvbXBhcmVkIGtleXMgaW4gdGhlIG9yZGVyCmFzIHNwZWNp ZmllZCBpbiB0aGUgcXVlcnkuIFRoaXMgY29tbWl0IGV4cGxvcmVzIGFsdGVybmF0aXZlIG9yZGVy aW5nIG9mCnRoZSBrZXlzLCB0cnlpbmcgdG8gZmluZCBhIGNoZWFwZXIgb25lLgoKSW4gcHJpbmNp cGxlLCB3ZSBtaWdodCBnZW5lcmF0ZSBncm91cGluZyBwYXRocyBmb3IgYWxsIHBlcm11dGF0aW9u cyBvZgp0aGUga2V5cywgYW5kIGxlYXZlIHRoZSByZXN0IHRvIHRoZSBvcHRpbWl6ZXIuIEJ1dCB0 aGF0IG1pZ2h0IGdldCB2ZXJ5CmV4cGVuc2l2ZSwgc28gd2UgdHJ5IHRvIHBpY2sgb25seSBhIGNv dXBsZSBpbnRlcmVzdGluZyBvcmRlcmluZ3MgYmFzZWQKb24gYm90aCBsb2NhbCBhbmQgZ2xvYmFs IGluZm9ybWF0aW9uLgoKV2hlbiBwbGFubmluZyB0aGUgZ3JvdXBpbmcgcGF0aCwgd2UgZXhwbG9y ZSBzdGF0aXN0aWNzIChudW1iZXIgb2YKZGlzdGluY3QgdmFsdWVzLCBjb3N0IG9mIHRoZSBjb21w YXJpc29uIGZ1bmN0aW9uKSBmb3IgdGhlIGtleXMgYW5kCnJlb3JkZXIgdGhlbSB0byBtaW5pbWl6 ZSBjb21wYXJpc29uIGNvc3RzLiBJbnR1aXRpdmVseSwgaXQgbWF5IGJlIGJldHRlcgp0byBwZXJm b3JtIG1vcmUgZXhwZW5zaXZlIGNvbXBhcmlzb25zIChmb3IgY29tcGxleCBkYXRhIHR5cGVzIGV0 Yy4pCmxhc3QsIGJlY2F1c2UgbWF5YmUgdGhlIGNoZWFwZXIgY29tcGFyaXNvbnMgd2lsbCBiZSBl bm91Z2guIFNpbWlsYXJseSwKdGhlIGhpZ2hlciB0aGUgY2FyZGluYWxpdHkgb2YgYSBrZXksIHRo ZSBsb3dlciB0aGUgcHJvYmFiaWxpdHkgd2XigJlsbApuZWVkIHRvIGNvbXBhcmUgbW9yZSBrZXlz LiBUaGUgcGF0Y2ggZ2VuZXJhdGVzIGFuZCBjb3N0cyB2YXJpb3VzCm9yZGVyaW5ncywgcGlja2lu ZyB0aGUgY2hlYXBlc3Qgb25lcy4KClRoZSBvcmRlcmluZyBvZiBncm91cCBrZXlzIG1heSBpbnRl cmFjdCB3aXRoIG90aGVyIHBhcnRzIG9mIHRoZSBxdWVyeSwKc29tZSBvZiB3aGljaCBtYXkgbm90 IGJlIGtub3duIHdoaWxlIHBsYW5uaW5nIHRoZSBncm91cGluZy4gRS5nLiB0aGVyZQptYXkgYmUg YW4gZXhwbGljaXQgT1JERVIgQlkgY2xhdXNlLCBvciBzb21lIG90aGVyIG9yZGVyaW5nLWRlcGVu ZGVudApvcGVyYXRpb24sIGhpZ2hlciB1cCBpbiB0aGUgcXVlcnksIGFuZCB1c2luZyB0aGUgc2Ft ZSBvcmRlcmluZyBtYXkgYWxsb3cKdXNpbmcgZWl0aGVyIGluY3JlbWVudGFsIHNvcnQgb3IgZXZl biBlbGltaW5hdGUgdGhlIHNvcnQgZW50aXJlbHkuCgpUaGUgcGF0Y2ggZ2VuZXJhdGVzIG9yZGVy aW5ncyBhbmQgcGlja3MgdGhvc2UgbWluaW1pemluZyB0aGUgY29tcGFyaXNvbgpjb3N0IChmb3Ig dmFyaW91cyBwYXRoa2V5cyksIGFuZCB0aGVuIGFkZHMgb3JkZXJpbmdzIHRoYXQgbWlnaHQgYmUK dXNlZnVsIGZvciBvcGVyYXRpb25zIGhpZ2hlciB1cCBpbiB0aGUgcGxhbiAoT1JERVIgQlksIGV0 Yy4pLiBGaW5hbGx5LAppdCBhbHdheXMga2VlcHMgdGhlIG9yZGVyaW5nIHNwZWNpZmllZCBpbiB0 aGUgcXVlcnksIG9uIHRoZSBhc3N1bXB0aW9uCnRoZSB1c2VyIG1pZ2h0IGhhdmUgYWRkaXRpb25h bCBpbnNpZ2h0cy4KClRoaXMgaW50cm9kdWNlcyBhIG5ldyBHVUMgZW5hYmxlX2dyb3VwX2J5X3Jl b3JkZXJpbmcsIHNvIHRoYXQgdGhlCm9wdGltaXphdGlvbiBtYXkgYmUgZGlzYWJsZWQgaWYgbmVl ZGVkLgoKVGhlIG9yaWdpbmFsIHBhdGNoIHdhcyBwcm9wb3NlZCBieSBUZW9kb3IgU2lnYWV2LCBh bmQgbGF0ZXIgaW1wcm92ZWQgYW5kCnJld29ya2VkIGJ5IERtaXRyeSBEb2xnb3YuIFJldmlld3Mg YnkgYSBudW1iZXIgb2YgcGVvcGxlLCBpbmNsdWRpbmcgbWUsCkFuZHJleSBMZXBpa2hvdiwgQ2xh dWRpbyBGcmVpcmUsIElicmFyIEFobWVkIGFuZCBaaGlob25nIFl1LgoKQXV0aG9yOiBEbWl0cnkg RG9sZ292LCBUZW9kb3IgU2lnYWV2LCBUb21hcyBWb25kcmEKUmV2aWV3ZWQtYnk6IFRvbWFzIFZv bmRyYSwgQW5kcmV5IExlcGlraG92LCBDbGF1ZGlvIEZyZWlyZSwgSWJyYXIgQWhtZWQsIFpoaWhv bmcgWXUKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS83Yzc5ZTZhNS04NTk3LTc0ZTgt MDY3MS0xYzM5ZDEyNGM5ZDYlNDBzaWdhZXYucnUKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3Iu ZXMvbS9DQSUyQnE2emNXXzRvMk5DMHp1dExrT0pQc0Z0ODBtZWdTcFhfZFZSbzZHSzlQQy1KeF9B ZyU0MG1haWwuZ21haWwuY29tCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0YWlscwotLS0tLS0t Cmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvZGIwZDY3ZGIyNDAxZWI2 MjM4Y2NjMDRjNjQwN2E0ZmQ0Zjk4NTgzMgoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0K Y29udHJpYi9wb3N0Z3Jlc19mZHcvZXhwZWN0ZWQvcG9zdGdyZXNfZmR3Lm91dCAgICB8ICAxNSAr LQpkb2Mvc3JjL3NnbWwvY29uZmlnLnNnbWwgICAgICAgICAgICAgICAgICAgICAgICAgIHwgIDE0 ICsKc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvY29zdHNpemUuYyAgICAgICAgICAgICB8IDM2 NiArKysrKysrKysrKy0Kc3JjL2JhY2tlbmQvb3B0aW1pemVyL3BhdGgvZXF1aXZjbGFzcy5jICAg ICAgICAgICB8ICAxMyArLQpzcmMvYmFja2VuZC9vcHRpbWl6ZXIvcGF0aC9wYXRoa2V5cy5jICAg ICAgICAgICAgIHwgNTY5ICsrKysrKysrKysrKysrKysrKysKc3JjL2JhY2tlbmQvb3B0aW1pemVy L3BsYW4vcGxhbm5lci5jICAgICAgICAgICAgICB8IDY0OSArKysrKysrKysrKysrLS0tLS0tLS0t CnNyYy9iYWNrZW5kL29wdGltaXplci91dGlsL3BhdGhub2RlLmMgICAgICAgICAgICAgfCAgIDIg Ky0Kc3JjL2JhY2tlbmQvdXRpbHMvYWR0L3NlbGZ1bmNzLmMgICAgICAgICAgICAgICAgICB8ICAz OCArLQpzcmMvYmFja2VuZC91dGlscy9taXNjL2d1Yy5jICAgICAgICAgICAgICAgICAgICAgIHwg IDEwICsKc3JjL2JhY2tlbmQvdXRpbHMvbWlzYy9wb3N0Z3Jlc3FsLmNvbmYuc2FtcGxlICAgICB8 ICAgMSArCnNyYy9pbmNsdWRlL25vZGVzL25vZGVzLmggICAgICAgICAgICAgICAgICAgICAgICAg fCAgIDEgKwpzcmMvaW5jbHVkZS9ub2Rlcy9wYXRobm9kZXMuaCAgICAgICAgICAgICAgICAgICAg IHwgIDEwICsKc3JjL2luY2x1ZGUvb3B0aW1pemVyL2Nvc3QuaCAgICAgICAgICAgICAgICAgICAg ICB8ICAgNCArLQpzcmMvaW5jbHVkZS9vcHRpbWl6ZXIvcGF0aHMuaCAgICAgICAgICAgICAgICAg ICAgIHwgICA3ICsKc3JjL2luY2x1ZGUvdXRpbHMvc2VsZnVuY3MuaCAgICAgICAgICAgICAgICAg ICAgICB8ICAgNSArCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvYWdncmVnYXRlcy5vdXQgICAg ICAgICAgfCAyNDQgKysrKysrKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9pbmNyZW1lbnRh bF9zb3J0Lm91dCAgICB8ICAgMiArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL2pvaW4ub3V0 ICAgICAgICAgICAgICAgIHwgIDUxICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvcGFydGl0 aW9uX2FnZ3JlZ2F0ZS5vdXQgfCAxMzYgKysrLS0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9w YXJ0aXRpb25fam9pbi5vdXQgICAgICB8ICA3NSArKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3Rl ZC9zeXN2aWV3cy5vdXQgICAgICAgICAgICB8ICAgMyArLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVj dGVkL3VuaW9uLm91dCAgICAgICAgICAgICAgIHwgIDYwICstCnNyYy90ZXN0L3JlZ3Jlc3Mvc3Fs L2FnZ3JlZ2F0ZXMuc3FsICAgICAgICAgICAgICAgfCAgOTkgKysrKwpzcmMvdGVzdC9yZWdyZXNz L3NxbC9pbmNyZW1lbnRhbF9zb3J0LnNxbCAgICAgICAgIHwgICAyICstCjI0IGZpbGVzIGNoYW5n ZWQsIDE4ODIgaW5zZXJ0aW9ucygrKSwgNDk0IGRlbGV0aW9ucygtKQoK --===============8596130844016550399==--