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 1iNenW-0008T7-2h for pgsql-bugs@arkaria.postgresql.org; Thu, 24 Oct 2019 15:13:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iNenU-0002fx-K8 for pgsql-bugs@arkaria.postgresql.org; Thu, 24 Oct 2019 15:13: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 1iNenU-0002fp-Cd for pgsql-bugs@lists.postgresql.org; Thu, 24 Oct 2019 15:13:08 +0000 Received: from wrigleys.postgresql.org ([2620:122:b000:7::246]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iNenR-00028E-NE for pgsql-bugs@lists.postgresql.org; Thu, 24 Oct 2019 15:13:08 +0000 Content-Type: multipart/mixed; boundary="===============7193853622610572855==" MIME-Version: 1.0 Subject: BUG #16076: JIT causes huge delays in a complex query. jit=off solves it. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: yuriastrakhan@gmail.com Reply-To: yuriastrakhan@gmail.com, pgsql-bugs@lists.postgresql.org Date: Thu, 24 Oct 2019 15:12:16 +0000 Message-ID: <16076-3ec3880ea1914088@postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7193853622610572855== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjA3NgpMb2dnZWQgYnk6ICAgICAgICAgIFl1cmkgQXN0cmFraGFuCkVt YWlsIGFkZHJlc3M6ICAgICAgeXVyaWFzdHJha2hhbkBnbWFpbC5jb20KUG9zdGdyZVNRTCB2ZXJz aW9uOiAxMi4wCk9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDE5LjEwCkRlc2NyaXB0aW9uOiAg ICAgICAgCgooaHVnZSB0aGFua3MgdG8gQEtvbXpwYSAtIERhcmFmZWkgUHJhbGlhc2tvdXNraSB3 aG8gZmlndXJlZCBvdXQgdGhlCmN1bHByaXQpDQoNClBvc3RncmVTUUwgMTIuMCAoVWJ1bnR1IDEy LjAtMi5wZ2RnMTkuMTArMSkgb24geDg2XzY0LXBjLWxpbnV4LWdudSwgY29tcGlsZWQKYnkgZ2Nj IChVYnVudHUgOS4yLjEtOXVidW50dTEpIDkuMi4xIDIwMTkxMDA4LCA2NC1iaXQNClBPU1RHSVM9 IjMuMC4wIHIxNzk4MyIgW0VYVEVOU0lPTl0gUEdTUUw9IjEyMCIgR0VPUz0iMy44LjAtQ0FQSS0x LjEzLjEgIgpQUk9KPSJSZWwuIDUuMi4wLCBTZXB0ZW1iZXIgMTV0aCwgMjAxOCIgTElCWE1MPSIy LjkuNCIgTElCSlNPTj0iMC4xMy4xIgpMSUJQUk9UT0JVRj0iMS4zLjEiIFdBR1lVPSIwLjQuMyAo SW50ZXJuYWwpIg0KDQpJIGhhdmUgYSBmdWxsIE9wZW5TdHJlZXRNYXAgbG9hZGVkIHVzaW5nIE9w ZW5NYXBUaWxlcyBjb25maWd1cmF0aW9uIGludG8KbXVsdGlwbGUgbWFjaGluZSBjb25maWd1cmF0 aW9ucy4gQSBzaW5nbGUgcXVlcnkgKHdyYXBwZWQgYXMgYSBVREYpIGdlbmVyYXRlcwp0aGUgd2hv bGUgTVZUIHRpbGUgYmxvYiwgYW5kIHVzZXMgbWFueSBsYXllcnMsIHN1Yi1xdWVyaWVzLCBhbmQg VURGcy4gV2hlbgpKSVQgaXMgZW5hYmxlZCwgdGhlIHF1ZXJ5IHRha2VzIDUtMTAgc2Vjb25kcyB0 byBydW4uIERpc2FibGluZyBKSVQgbWFrZXMgdGhlCnF1ZXJ5IHJ1biBpbiBtaWxsaXNlY29uZHMu ICBTYW1lIHF1ZXJpZXMgb24gUG9zdGdyZVNRTCAxMCArIFBvc3RnaXMKMi41LjIvR0VPUyAzLjYg aGF2ZSBubyBpc3N1ZXMgKGFzIHRoZXJlIHdhcyBubyBKSVQpLg0KDQpEZXRhaWxzOg0KVGhlIHF1 ZXJ5IGlzIGEgY29uY2F0ZW5hdGlvbiBvZiBtdWx0aXBsZSBtYXAgbGF5ZXJzIChiaW5hcnkgYmxv YnMgaW4gTVZUCmZvcm1hdCBmcm9tIFNUX0FzTVZUKCkpLiBBbGwgbGF5ZXJzIGFyZSAiVU5JT04g QUxMLWVkIiBmcm9tIHN1YnF1ZXJpZXMsIG9uZQpxdWVyeSBwZXIgbGF5ZXIuIFRoZSAiZXhwbGFp biBhbmFseXplIiBzaG93cyBodWdlIGNvc3Qgb2YgdGhlIGZpcnN0IGxheWVyCnF1ZXJ5LCByZWdh cmRsZXNzIG9mIHRoZSBvcmRlciBvZiB0aG9zZSBsYXllcnMuICBFdmVyeSBsYXllciBhZGRlZCBh Ym91dAoyMDAtMzAwbXMgdG8gdGhlIGV4ZWN1dGlvbiAobm90IHBsYW5uaW5nISkgdGltZSwgdG90 YWxsaW5nIGFib3V0IDUtNwpzZWNvbmRzLiBZZXQsIEkgbm90aWNlZCB0aGF0IHdoZW4gSSB3YXMg dGVzdGluZyBhIHBvcnRpb24gb2YgbGF5ZXJzLApyZW1vdmluZyBsYXllcl93YXRlcndheSBtYWRl IHF1ZXJ5IHJ1biBpbiBtaWxsaXNlY29uZHMgKEkgc3VzcGVjdCB0aGVyZSBhcmUKbW9yZSB0aGFu IG9uZSBsYXllciB0aGF0IGNhdXNlcyB0aGlzIGJ1ZykuDQoNCkkgd2lsbCB0cnkgdG8gcmVwcm9k dWNlIHRoaXMgZXJyb3IgdXNpbmcgT3Blbk1hcFRpbGVzJ3MgcXVpY2tzdGFydCBzZXR1cCwKYnV0 IHRoYXQgd2lsbCBpbnZvbHZlIHNvbWUgaGVhdnkgY3VzdG9taXphdGlvbi4gIElzIHRoaXMgYSBr bm93biBidWcsIG9yCnNob3VsZCBJIHRyeSB0byBnZXQgYW4gZWFzeSB0byBzZXQgdXAgcmVwbz8g IFRoYW5rcyENCg0KKiAicGVyZiB0b3AiIHJlc3VsdHMgLQpodHRwczovL2dpc3QuZ2l0aHViLmNv bS9ueXVyaWsvZmEwY2IwZGQ5MzVkNTBlNzk2Y2Q1ZDU4ZDhkNDEwNjcNCiogQSBmZXcgZXhwbG9y ZSBhbmFseXplIHJ1bnMgd2l0aCBkaWZmZXJlbnQgbGF5ZXIgb3JkZXJpbmdzOg0KICAqIGh0dHBz Oi8vZXhwbGFpbi5kZXBlc3ouY29tL3MvZmVjQw0KICAqIGh0dHBzOi8vZXhwbGFpbi5kZXBlc3ou Y29tL3MvTXBNbw0KICAqIGh0dHBzOi8vZXhwbGFpbi5kZXBlc3ouY29tL3MvZDdSVQ0KKiBtYWlu IHF1ZXJ5IC0KaHR0cHM6Ly9naXN0LmdpdGh1Yi5jb20vbnl1cmlrL2VkODBjNWU2ZDIwZjY3ZmQx NGQzN2VhMjUwM2E5Y2JkDQoqIGhlbHBlcnMgLSBodHRwczovL2dpc3QuZ2l0aHViLmNvbS9ueXVy aWsvMDBjNGM5ZDY5YjdkNGZhNjdjODYxNTliOWNlODMwMjcKCg== --===============7193853622610572855==--