Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j0Jqd-0002X1-45 for pgsql-bugs@arkaria.postgresql.org; Sat, 08 Feb 2020 06:44:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1j0Jqa-0005Ip-Pe for pgsql-bugs@arkaria.postgresql.org; Sat, 08 Feb 2020 06:44:08 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1j0Jqa-0005Ih-HE for pgsql-bugs@lists.postgresql.org; Sat, 08 Feb 2020 06:44:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1j0JqW-0007Kn-HD for pgsql-bugs@lists.postgresql.org; Sat, 08 Feb 2020 06:44:07 +0000 Content-Type: multipart/mixed; boundary="===============6914426603261075608==" MIME-Version: 1.0 Subject: BUG #16251: ::text type casting of a constant breaks query performance To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: imyfess@gmail.com Reply-To: imyfess@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sat, 08 Feb 2020 06:43:22 +0000 Message-ID: <16251-51e254d9a8bacbb2@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============6914426603261075608== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjI1MQpMb2dnZWQgYnk6ICAgICAgICAgIERpbWEgUGF2bG92CkVtYWls IGFkZHJlc3M6ICAgICAgaW15ZmVzc0BnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJzaW9uOiAxMi4x Ck9wZXJhdGluZyBzeXN0ZW06ICAgV2luZG93cyAxMApEZXNjcmlwdGlvbjogICAgICAgIAoKVGVz dCB0YWJsZSBhbmQgaW5kZXhlcyAoUG9zdGdyZVNRTCAxMi4xKToNCg0KQ1JFQVRFIFRBQkxFIHQg KGR0IHRpbWVzdGFtcCB3aXRoIHRpbWUgem9uZSk7DQpDUkVBVEUgSU5ERVggaW5kIE9OIHQgVVNJ TkcgYnRyZWUgKGR0KTsNCg0KSU5TRVJUDQpJTlRPIHQoZHQpDQogICAgU0VMRUNUDQogICAgKA0K ICAgICAgICB0aW1lc3RhbXAgJzIwMjAtMDEtMDEgMDA6MDA6MDAnICsNCiAgICAgICAgcmFuZG9t KCkgKiAoDQogICAgICAgICAgICB0aW1lc3RhbXAgJzIwMjAtMDItMjkgMDA6MDA6MDAnIC0NCiAg ICAgICAgICAgIHRpbWVzdGFtcCAnMjAyMC0wMS0wMSAwMDowMDowMCcNCiAgICAgICAgKQ0KICAg ICkNCiAgICBGUk9NIGdlbmVyYXRlX3NlcmllcygxLCAxMDAwMCkNCg0KLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KDQpJbiB0aGUgZmlyc3QgcXVlcnksIGV2ZXJ5dGhpbmcg aXMgb2ssIGFwcHJvcHJpYXRlIGluZGV4ICJpbmQiIGlzIHVzZWQ6DQoNCmV4cGxhaW4gKGFuYWx5 emUsIGJ1ZmZlcnMpDQpTRUxFQ1QgKg0KRlJPTSB0DQpXSEVSRQ0KICAgKCcyMDIwLTAyLTA4Jyk6 OmRhdGUgSVMgTlVMTA0KICAgT1INCiAgIGR0ID4gJzIwMjAtMDItMDgnDQpPUkRFUiBCWSBkdA0K TElNSVQgMQ0KDQoiTGltaXQgIChjb3N0PTAuMjkuLjAuMzcgcm93cz0xIHdpZHRoPTgpIChhY3R1 YWwgdGltZT0wLjE4Ni4uMC4xODggcm93cz0xCmxvb3BzPTEpIg0KIiAgQnVmZmVyczogc2hhcmVk IGhpdD0zIg0KIiAgLT4gIEluZGV4IE9ubHkgU2NhbiB1c2luZyBpbmQgb24gdCAgKGNvc3Q9MC4y OS4uMzAzLjc1IHJvd3M9MzYyNyB3aWR0aD04KQooYWN0dWFsIHRpbWU9MC4xODQuLjAuMTg0IHJv d3M9MSBsb29wcz0xKSINCiIgICAgICAgIEluZGV4IENvbmQ6IChkdCA+ICcyMDIwLTAyLTA4IDAw OjAwOjAwKzA1Jzo6dGltZXN0YW1wIHdpdGggdGltZQp6b25lKSINCiIgICAgICAgIEhlYXAgRmV0 Y2hlczogMSINCiIgICAgICAgIEJ1ZmZlcnM6IHNoYXJlZCBoaXQ9MyINCiJQbGFubmluZyBUaW1l OiAyLjM2NSBtcyINCiJFeGVjdXRpb24gVGltZTogMC4yMzkgbXMiDQoNCi0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQoNCldpdGggJzo6dGV4dCcgdHlwZSBj YXN0aW5nIG9mICcyMDIwLTAyLTA4JyAod2hpY2ggaXMgYWxyZWFkeSB0ZXh0KSBxdWVyeQpwZXJt b2ZhbmNlIGlzIHZlcnkgbG93DQoNCmV4cGxhaW4gKGFuYWx5emUsIGJ1ZmZlcnMpDQpTRUxFQ1Qg Kg0KRlJPTSB0DQpXSEVSRQ0KICAgKCcyMDIwLTAyLTA4Jzo6dGV4dCk6OmRhdGUgSVMgTlVMTA0K ICAgT1INCiAgIGR0ID4gJzIwMjAtMDItMDgnDQpPUkRFUiBCWSBkdA0KTElNSVQgMQ0KDQoiTGlt aXQgIChjb3N0PTAuMjkuLjAuNDQgcm93cz0xIHdpZHRoPTgpIChhY3R1YWwgdGltZT00NS4zMDYu LjQ1LjMwNyByb3dzPTEKbG9vcHM9MSkiDQoiICBCdWZmZXJzOiBzaGFyZWQgaGl0PTYyMzIiDQoi ICAtPiAgSW5kZXggT25seSBTY2FuIHVzaW5nIGluZCBvbiB0ICAoY29zdD0wLjI5Li41NjEuMjgg cm93cz0zNjU4IHdpZHRoPTgpCihhY3R1YWwgdGltZT00NS4zMDQuLjQ1LjMwNCByb3dzPTEgbG9v cHM9MSkiDQoiICAgICAgICBGaWx0ZXI6ICgoKCcyMDIwLTAyLTA4Jzo6Y3N0cmluZyk6OmRhdGUg SVMgTlVMTCkgT1IgKGR0ID4KJzIwMjAtMDItMDggMDA6MDA6MDArMDUnOjp0aW1lc3RhbXAgd2l0 aCB0aW1lIHpvbmUpKSINCiIgICAgICAgIFJvd3MgUmVtb3ZlZCBieSBGaWx0ZXI6IDYzNjciDQoi ICAgICAgICBIZWFwIEZldGNoZXM6IDYzNjgiDQoiICAgICAgICBCdWZmZXJzOiBzaGFyZWQgaGl0 PTYyMzIiDQoiUGxhbm5pbmcgVGltZTogMC4zNDggbXMiDQoiRXhlY3V0aW9uIFRpbWU6IDQ1LjM0 MyBtcyIKCg== --===============6914426603261075608==--