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 1kJJQG-0000sv-KV for pgsql-bugs@arkaria.postgresql.org; Fri, 18 Sep 2020 16:39:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kJJQD-000609-Pw for pgsql-bugs@arkaria.postgresql.org; Fri, 18 Sep 2020 16:39:41 +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 1kJJ2X-0005FD-TG for pgsql-bugs@lists.postgresql.org; Fri, 18 Sep 2020 16:15:14 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kJJ2T-00016g-8L for pgsql-bugs@lists.postgresql.org; Fri, 18 Sep 2020 16:15:13 +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=rB2dM296Nzf/xfGkavrUBJTAgYasQ63HxFBhkm21Tfo=; b=VQYD8Gg5fE8FByuKTJN4i80GVB cOKv95jIkD9QKhf/b6hu0QLFir9fR2fhNw3wWMcN2cLrxK1ODykYQHpCyWHfYNg5ThDvPR9K3/hid gsTKj9zEXTKqENqno5tJ6UOiO6vJck0t6WEBFu8FpUKZK0JTmJj6Btb3IrsanEg/0CCX8rfU16ONa 3zFbHj3nLe+fy5BfuI8lTyltNnWXiOaU/numoL5xVbcQIP25+o95Gxo9g0EwpnMxAZCXTYEkWRV8O Q8Rhw4UDLpaYZ8vPZimtam2UJyvQKiUcisGe6jcogAzWpyRZQ6Yx7eWpa7hFggctDW61cOTlG6K7t oe0GKpXg==; 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 1kJJ2Q-00052g-Nf for pgsql-bugs@lists.postgresql.org; Fri, 18 Sep 2020 16:15:06 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kJJ2M-0008D4-Ui for pgsql-bugs@lists.postgresql.org; Fri, 18 Sep 2020 16:15:02 +0000 Content-Type: multipart/mixed; boundary="===============7770043190618967630==" MIME-Version: 1.0 Subject: BUG #16624: Query Optimizer - Performance bug related to predicate simplification To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: XINYULIU@UMICH.EDU Reply-To: XINYULIU@UMICH.EDU, pgsql-bugs@lists.postgresql.org Date: Fri, 18 Sep 2020 16:14:17 +0000 Message-ID: <16624-1375434d97659203@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --===============7770043190618967630== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjYyNApMb2dnZWQgYnk6ICAgICAgICAgIFhJTllVIExJVQpFbWFpbCBh ZGRyZXNzOiAgICAgIFhJTllVTElVQFVNSUNILkVEVQpQb3N0Z3JlU1FMIHZlcnNpb246IDEzcmMx Ck9wZXJhdGluZyBzeXN0ZW06ICAgVWJ1bnR1IDIwLjA0CkRlc2NyaXB0aW9uOiAgICAgICAgCgpI ZWxsbywNCg0KV2UgYXJlIGRldmVsb3BpbmcgYSB0b29sIGZvciBhdXRvbWF0aWNhbGx5IGZpbmRp bmcgcGVyZm9ybWFuY2UgYnVncyBpbgpQb3N0Z3JlU1FMLiBPdXIga2V5IGluc2lnaHQgaXMgdGhh dCBnaXZlbiBhIHBhaXIgb2Ygc2VtYW50aWMgZXF1aXZhbGVudApxdWVyaWVzLCBhIHJvYnVzdCBE Qk1TIHNob3VsZCByZXR1cm4gdGhlIHNhbWUgcmVzdWx0IHdpdGhpbiBhIHNpbWlsYXIKZXhlY3V0 aW9uIHRpbWUuIFNpZ25pZmljYW50IHRpbWUgZGlmZmVyZW5jZSBzdWdnZXN0cyBhIHBvdGVudGlh bCBwZXJmb3JtYW5jZQpidWcgaW4gdGhlIERCTVMuDQoNCldlIGFyZSBzaGFyaW5nIGEgcGFpciBv ZiBUUEMtSCBxdWVyaWVzIHRoYXQgZXhoaWJpdCBhIHBvdGVudGlhbCBwZXJmb3JtYW5jZQpidWcg aW4gdGhpcyByZXBvcnQ6DQoNCkZpcnN0IHF1ZXJ5Og0KU0VMRUNUICJwc19zdXBwa2V5IiANCkZS T00gICAicGFydHN1cHAiIA0KV0hFUkUgICJwc19wYXJ0a2V5IiA9IDE0ODY7IA0KDQpTZWNvbmQg cXVlcnk6DQpTRUxFQ1QgInBzX3N1cHBrZXkiIA0KRlJPTSAgICJwYXJ0c3VwcCIgDQpXSEVSRSAg InBzX3BhcnRrZXkiICsgMTQ4NiA9IDI5NzI7IA0KDQpbQWN0dWFsIEJlaGF2aW9yXQ0KV2UgZXhl Y3V0ZWQgYm90aCBxdWVyaWVzIG9uIHRoZSBUUEMtSCBiZW5jaG1hcmsgb2Ygc2NhbGUgZmFjdG9y IDU6IHRoZSBmaXJzdApxdWVyeSB0YWtlcyBvbmx5IDEuMDU5IG1pbGxpc2Vjb25kLCB3aGlsZSB0 aGUgc2Vjb25kIHF1ZXJ5IHRha2VzIDI0Ny4xNzYKbWlsbGlzZWNvbmQuIFdlIHRoaW5rIHRoZSB0 aW1lIGRpZmZlcmVuY2UgcmVzdWx0cyBmcm9tIGRpZmZlcmVudCBwbGFucwpzZWxlY3RlZC4NCg0K W1F1ZXJ5IEV4ZWN1dGlvbiBQbGFuXQ0KKiBGaXJzdCBxdWVyeToNCiAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIFFVRVJZIFBMQU4gICAgICAg ICAKICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQotLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLQ0KIEluZGV4IE9ubHkgU2NhbiB1c2luZyBwYXJ0c3VwcF9wa2V5IG9uIHBhcnRzdXBw ICAoY29zdD0wLjQzLi40LjU5IHJvd3M9OQp3aWR0aD00KSAoYWN0dWFsIHRpbWU9MC42OTIuLjAu Njk0IHJvd3M9NCBsb29wcz0xKQ0KICAgSW5kZXggQ29uZDogKHBzX3BhcnRrZXkgPSAxNDg2KQ0K ICAgSGVhcCBGZXRjaGVzOiAwDQogUGxhbm5pbmcgVGltZTogNC43NDggbXMNCiBFeGVjdXRpb24g VGltZTogMS4wNTkgbXMNCig1IHJvd3MpDQoNCiogU2Vjb25kIHF1ZXJ5Og0KICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg IFFVRVJZClBMQU4gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgCg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLQ0KIEdhdGhlciAgKGNvc3Q9MTAwMC40My4uOTE4NjUuOTQgcm93cz0xOTk5NCB3aWR0 aD00KSAoYWN0dWFsCnRpbWU9Mi4wMzIuLjI0Ni44MjEgcm93cz00IGxvb3BzPTEpDQogICBXb3Jr ZXJzIFBsYW5uZWQ6IDINCiAgIFdvcmtlcnMgTGF1bmNoZWQ6IDINCiAgIC0+ICBQYXJhbGxlbCBJ bmRleCBPbmx5IFNjYW4gdXNpbmcgcGFydHN1cHBfcGtleSBvbiBwYXJ0c3VwcCAKKGNvc3Q9MC40 My4uODg4NjYuNTQgcm93cz04MzMxIHdpZHRoPTQpIChhY3R1YWwgdGltZT0xNTkuMzcxLi4yNDAu MDEyIHJvd3M9MQpsb29wcz0zKQ0KICAgICAgICAgRmlsdGVyOiAoKHBzX3BhcnRrZXkgKyAxNDg2 KSA9IDI5NzIpDQogICAgICAgICBSb3dzIFJlbW92ZWQgYnkgRmlsdGVyOiAxMzMzMzMyDQogICAg ICAgICBIZWFwIEZldGNoZXM6IDANCiBQbGFubmluZyBUaW1lOiA0LjU1NiBtcw0KIEV4ZWN1dGlv biBUaW1lOiAyNDcuMTc2IG1zDQooOSByb3dzKQ0KDQoNCltFeHBlY3RlZCBCZWhhdmlvcl0NCkkg d291bGQgaGF2ZSBleHBlY3RlZCB0aGUgREJNUyB0byBydW4gdGhlc2UgdHdvIHF1ZXJpZXMgd2l0 aCBzaW1pbGFyCmV4ZWN1dGlvbiB0aW1lLCBnaXZlbiB0aGF0IHRoZXkgYm90aCBoYXZlIHRoZSBz YW1lIHNlbWFudGljcy4gTm90YWJseSwgdGhlCmV4ZWN1dGlvbiB0aW1lIGRpZmZlcmVuY2UgYmV0 d2VlbiB0aGVzZSB0d28gcXVlcmllcyB3aWxsIGdyb3cgc2lnbmlmaWNhbnRseQp3aGVuIHRoZSBz aXplIG9mIHRoZSBkYXRhYmFzZSBncm93cy4gT24gdGhlIFRQQy1IIGJlbmNobWFyayBvZiBzY2Fs ZSBmYWN0b3IKMTAwLCB0aGUgZmlyc3QgcXVlcnkgdGFrZXMgMS45IG1pbGxpc2Vjb25kLCB3aGls ZSB0aGUgc2Vjb25kIHF1ZXJ5IHRha2VzIDgzCnNlY29uZHMuDQoNCltUZXN0IEVudmlyb25tZW50 XQ0KVWJ1bnR1IDIwLjA0IG1hY2hpbmUgIkxpbnV4IHBhbmRhIDUuNC4wLTQwLWdlbmVyaWMgIzQ0 LVVidW50dSBTTVAgVHVlIEp1biAyMwowMDowMTowNCBVVEMgMjAyMCB4ODZfNjQgeDg2XzY0IHg4 Nl82NCBHTlUvTGludXgiDQpQb3N0Z3JlU1FMIHYxMyBiZXRhMw0KRGF0YWJhc2U6IFRQQy1IIGJl bmNobWFyayAod2l0aCBzY2FsZSBmYWN0b3IgNSkNCg0KW1N0ZXBzIGZvciByZXByb2R1Y2luZyBv dXIgb2JzZXJ2YXRpb25zXQ0KCQ0KKiBEb3dubG9hZCB0aGUgZGF0YXNldCBmcm9tIHRoZSBsaW5r OgpodHRwczovL2RyaXZlLmdvb2dsZS5jb20vZmlsZS9kLzEzckZhMUJORGk0ZTJSbVhCbi15RVFr Y3F0NmxzQnUxYy92aWV3P3VzcD1zaGFyaW5nDQoqIFNldCB1cCBUUEMtSCBiZW5jaG1hcmsNCnRh ciB4enZmIHRwY2g1X3Bvc3RncmVzcWwudGFyLmd6DQpjZCB0cGNoNV9wb3N0Z3Jlc3FsDQpkYj10 cGNoNQ0KY3JlYXRlZGIgJGRiDQpwc3FsIC1kICRkYiA8IGRzcy5kZGwNCmZvciBpIGluIGBscyAq LnRibGANCmRvDQogICAgZWNobyAkaQ0KICAgIG5hbWU9YGVjaG8gJGl8Y3V0IC1kJy4nIC1mMWAN CiAgICBwc3FsIC1kICRkYiAtYyAiQ09QWSAkbmFtZSBGUk9NICdgcHdkYC8kaScgREVMSU1JVEVS ICd8JyBFTkNPRElORwonTEFUSU4xJzsiDQpkb25lDQpwc3FsIC1kICRkYiA8IGRzc19wb3N0Z3Jl cy5yaQ0KKiBFeGVjdXRlIHRoZSBxdWVyaWVzCgo= --===============7770043190618967630==--