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 1tubD3-00A5BU-W1 for pgsql-committers@arkaria.postgresql.org; Tue, 18 Mar 2025 17:58:37 +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 1tubD2-001zOB-Cz for pgsql-committers@arkaria.postgresql.org; Tue, 18 Mar 2025 17:58:36 +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 1tubD2-001zO3-4z for pgsql-committers@lists.postgresql.org; Tue, 18 Mar 2025 17:58:36 +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.96) (envelope-from ) id 1tubCy-003brB-0D for pgsql-committers@lists.postgresql.org; Tue, 18 Mar 2025 17:58:35 +0000 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 1tubCx-009KF4-Aw for pgsql-committers@lists.postgresql.org; Tue, 18 Mar 2025 17:58:31 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1tubCw-0038AS-24 for pgsql-committers@lists.postgresql.org; Tue, 18 Mar 2025 17:58:30 +0000 Content-Type: multipart/mixed; boundary="===============4303844883962490206==" MIME-Version: 1.0 From: =?utf-8?q?=C3=81lvaro_Herrera?= To: pgsql-committers@lists.postgresql.org Subject: pgsql: Introduce squashing of constant lists in query jumbling X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 18 Mar 2025 17:58:30 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4303844883962490206== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 SW50cm9kdWNlIHNxdWFzaGluZyBvZiBjb25zdGFudCBsaXN0cyBpbiBxdWVyeSBqdW1ibGluZwoK cGdfc3RhdF9zdGF0ZW1lbnRzIHByb2R1Y2VzIG11bHRpcGxlIGVudHJpZXMgZm9yIHF1ZXJpZXMg bGlrZQogICAgU0VMRUNUIHNvbWV0aGluZyBGUk9NIHRhYmxlIFdIRVJFIGNvbCBJTiAoMSwgMiwg MywgLi4uKQoKZGVwZW5kaW5nIG9uIHRoZSBudW1iZXIgb2YgcGFyYW1ldGVycywgYmVjYXVzZSBl dmVyeSBlbGVtZW50IG9mCkFycmF5RXhwciBpcyBpbmRpdmlkdWFsbHkganVtYmxlZC4gIE1vc3Qg b2YgdGhlIHRpbWUgdGhhdCdzIHVuZGVzaXJhYmxlLAplc3BlY2lhbGx5IGlmIHRoZSBsaXN0IGJl Y29tZXMgdG9vIGxhcmdlLgoKRml4IHRoaXMgYnkgaW50cm9kdWNpbmcgYSBuZXcgR1VDIHF1ZXJ5 X2lkX3NxdWFzaF92YWx1ZXMgd2hpY2ggbW9kaWZpZXMKdGhlIG5vZGUganVtYmxpbmcgY29kZSB0 byBvbmx5IGNvbnNpZGVyIHRoZSBmaXJzdCBhbmQgbGFzdCBlbGVtZW50IG9mIGEKbGlzdCBvZiBj b25zdGFudHMsIHJhdGhlciB0aGFuIGVhY2ggbGlzdCBlbGVtZW50IGluZGl2aWR1YWxseS4gIFRo aXMKYWZmZWN0cyBib3RoIHRoZSBxdWVyeV9pZCBnZW5lcmF0ZWQgYnkgcXVlcnkganVtYmxpbmcs IGFzIHdlbGwgYXMKcGdfc3RhdF9zdGF0ZW1lbnRzIHF1ZXJ5IG5vcm1hbGl6YXRpb24gc28gdGhh dCBpdCBzdXBwcmVzc2VzIHByaW50aW5nIG9mCnRoZSBpbmRpdmlkdWFsIGVsZW1lbnRzIG9mIHN1 Y2ggYSBsaXN0LgoKVGhlIGRlZmF1bHQgdmFsdWUgaXMgb2ZmLCBtZWFuaW5nIHRoZSBwcmV2aW91 cyBiZWhhdmlvciBpcyBtYWludGFpbmVkLgoKQXV0aG9yOiBEbWl0cnkgRG9sZ292IDw5ZXJ0aGFs aW9uNkBnbWFpbC5jb20+ClJldmlld2VkLWJ5OiBTZXJnZXkgRHVkb2xhZG92IChteXN0ZXJpb3Vz LCBvZmYtbGlzdCkKUmV2aWV3ZWQtYnk6IERhdmlkIEdlaWVyIDxnZWlkYXYucGdAZ21haWwuY29t PgpSZXZpZXdlZC1ieTogUm9iZXJ0IEhhYXMgPHJvYmVydG1oYWFzQGdtYWlsLmNvbT4KUmV2aWV3 ZWQtYnk6IMOBbHZhcm8gSGVycmVyYSA8YWx2aGVycmVAYWx2aC5uby1pcC5vcmc+ClJldmlld2Vk LWJ5OiBTYW1pIEltc2VpaCA8c2FtaW1zZWloQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IFN1dG91 IEtvdWhlaSA8a291QGNsZWFyLWNvZGUuY29tPgpSZXZpZXdlZC1ieTogVG9tIExhbmUgPHRnbEBz c3MucGdoLnBhLnVzPgpSZXZpZXdlZC1ieTogTWljaGFlbCBQYXF1aWVyIDxtaWNoYWVsQHBhcXVp ZXIueHl6PgpSZXZpZXdlZC1ieTogTWFyY29zIFBlZ29yYXJvIDxtYXJjb3NAZjEwLmNvbS5icj4K UmV2aWV3ZWQtYnk6IEp1bGllbiBSb3VoYXVkIDxyanVqdTEyM0BnbWFpbC5jb20+ClJldmlld2Vk LWJ5OiBaaGlob25nIFl1IDx6eXVAeXVnYWJ5dGUuY29tPgpUZXN0ZWQtYnk6IFlhc3VvIEhvbmRh IDx5YXN1by5ob25kYUBnbWFpbC5jb20+ClRlc3RlZC1ieTogU2VyZ2VpIEtvcm5pbG92IDxza0B6 c3J2Lm9yZz4KVGVzdGVkLWJ5OiBNYWNpZWsgU2FrcmVqZGEgPG0uc2FrcmVqZGFAZ21haWwuY29t PgpUZXN0ZWQtYnk6IENoZW5neGkgU3VuIDxzdW5jaGVuZ3hpQGhpZ2hnby5jb20+ClRlc3RlZC1i eTogSmFrdWIgV2FydGFrIDxqYWt1Yi53YXJ0YWtAZW50ZXJwcmlzZWRiLmNvbT4KRGlzY3Vzc2lv bjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9DQStxNnpjV3RVYlRfU3hqMFY2SFk2RVo4OXV2NXd1RzVh ZWZwZV85bjBKcjNWd250RmdAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpE ZXRhaWxzCi0tLS0tLS0KaHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi82 MmQ3MTJlY2ZkOTQwZjYwZTY4YmRlNWI2OTcyYjY4NTk5MzdjNDEyCgpNb2RpZmllZCBGaWxlcwot LS0tLS0tLS0tLS0tLQpjb250cmliL3BnX3N0YXRfc3RhdGVtZW50cy9NYWtlZmlsZSAgICAgICAg ICAgICAgIHwgICAyICstCmNvbnRyaWIvcGdfc3RhdF9zdGF0ZW1lbnRzL2V4cGVjdGVkL3NxdWFz aGluZy5vdXQgfCA0NjQgKysrKysrKysrKysrKysrKysrKysrKwpjb250cmliL3BnX3N0YXRfc3Rh dGVtZW50cy9tZXNvbi5idWlsZCAgICAgICAgICAgIHwgICAxICsKY29udHJpYi9wZ19zdGF0X3N0 YXRlbWVudHMvcGdfc3RhdF9zdGF0ZW1lbnRzLmMgICB8ICA3NiArKystCmNvbnRyaWIvcGdfc3Rh dF9zdGF0ZW1lbnRzL3NxbC9zcXVhc2hpbmcuc3FsICAgICAgfCAxODAgKysrKysrKysrCmRvYy9z cmMvc2dtbC9jb25maWcuc2dtbCAgICAgICAgICAgICAgICAgICAgICAgICAgfCAgMzAgKysKZG9j L3NyYy9zZ21sL3Bnc3RhdHN0YXRlbWVudHMuc2dtbCAgICAgICAgICAgICAgICB8ICAyNCArLQpz cmMvYmFja2VuZC9ub2Rlcy9nZW5fbm9kZV9zdXBwb3J0LnBsICAgICAgICAgICAgIHwgIDE5ICst CnNyYy9iYWNrZW5kL25vZGVzL3F1ZXJ5anVtYmxlZnVuY3MuYyAgICAgICAgICAgICAgfCAxNDYg KysrKysrLQpzcmMvYmFja2VuZC9wb3N0bWFzdGVyL2xhdW5jaF9iYWNrZW5kLmMgICAgICAgICAg IHwgICAzICsKc3JjL2JhY2tlbmQvdXRpbHMvbWlzYy9ndWNfdGFibGVzLmMgICAgICAgICAgICAg ICB8ICAxMCArCnNyYy9iYWNrZW5kL3V0aWxzL21pc2MvcG9zdGdyZXNxbC5jb25mLnNhbXBsZSAg ICAgfCAgIDEgKwpzcmMvaW5jbHVkZS9ub2Rlcy9ub2Rlcy5oICAgICAgICAgICAgICAgICAgICAg ICAgIHwgICAyICsKc3JjL2luY2x1ZGUvbm9kZXMvcHJpbW5vZGVzLmggICAgICAgICAgICAgICAg ICAgICB8ICAgMiArLQpzcmMvaW5jbHVkZS9ub2Rlcy9xdWVyeWp1bWJsZS5oICAgICAgICAgICAg ICAgICAgIHwgICA3ICsKMTUgZmlsZXMgY2hhbmdlZCwgOTQ1IGluc2VydGlvbnMoKyksIDIyIGRl bGV0aW9ucygtKQoK --===============4303844883962490206==--