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 1kJfAn-00059w-B2 for pgsql-bugs@arkaria.postgresql.org; Sat, 19 Sep 2020 15:53:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kJfAk-0006wj-4Z for pgsql-bugs@arkaria.postgresql.org; Sat, 19 Sep 2020 15:53:10 +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 1kJTcj-00060u-6v for pgsql-bugs@lists.postgresql.org; Sat, 19 Sep 2020 03:33:17 +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 1kJTcZ-0007WF-Um for pgsql-bugs@lists.postgresql.org; Sat, 19 Sep 2020 03:33:16 +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=nccgFQNeavjlZ+JRXPPi2VT5psjBKuVOid+tKFdZy+o=; b=cJKbrPoslTl6j8t/3hxXEn87Uk 6oDMWPDLkLWNsZSul52g8f/5Fafqk6VqyZwbSkSwf8zJXZmmBlvs6Xbl/0RvXu3+zPq9wCYdvMORs 9atgPtWZ912PLWtiJzb36WN86XUg3yyODXfsbXoI7w9ww7CiJ4PVKPyV9XflaQRfAfRCnKsUHsuNB yGGjGjq1HWyD/GpjDg3OFhvRHySm/vgpnx0Lfq/LIF0YP6X4cProcTufRM9IXDoy2xtk1/bxsN9rm EUQePRJbpOvdB4BGzk9SE7Ls3IXMstMXGo9fhiUYPwmQ2/EBGBv6Sxb0LffkSSuk8wI0zuQIPTi7+ ko02NiBA==; 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 1kJTcY-0006X0-Fn for pgsql-bugs@lists.postgresql.org; Sat, 19 Sep 2020 03:33: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 1kJTcU-00034u-QE for pgsql-bugs@lists.postgresql.org; Sat, 19 Sep 2020 03:33:02 +0000 Content-Type: multipart/mixed; boundary="===============7760575238465836774==" MIME-Version: 1.0 Subject: BUG #16625: Query Optimizer - Performance bug related to removal of unnecessary aggregate function 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: Sat, 19 Sep 2020 03:32:41 +0000 Message-ID: <16625-07403f18463add24@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 --===============7760575238465836774== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjYyNQpMb2dnZWQgYnk6ICAgICAgICAgIFhJTllVIExJVQpFbWFpbCBh ZGRyZXNzOiAgICAgIHhpbnl1bGl1QHVtaWNoLmVkdQpQb3N0Z3JlU1FMIHZlcnNpb246IDEyLjMK T3BlcmF0aW5nIHN5c3RlbTogICBVYnVudHUgMTkuMTAKRGVzY3JpcHRpb246ICAgICAgICAKCkhl bGxvLA0KDQpXZSBhcmUgZGV2ZWxvcGluZyBhIHRvb2wgZm9yIGF1dG9tYXRpY2FsbHkgZmluZGlu ZyBwZXJmb3JtYW5jZSBidWdzIGluClBvc3RncmVTUUwuIE91ciBrZXkgaW5zaWdodCBpcyB0aGF0 IGdpdmVuIGEgcGFpciBvZiBzZW1hbnRpYyBlcXVpdmFsZW50CnF1ZXJpZXMsIGEgcm9idXN0IERC TVMgc2hvdWxkIHJldHVybiB0aGUgc2FtZSByZXN1bHQgd2l0aGluIGEgc2ltaWxhcgpleGVjdXRp b24gdGltZS4gU2lnbmlmaWNhbnQgdGltZSBkaWZmZXJlbmNlIHN1Z2dlc3RzIGEgcG90ZW50aWFs IHBlcmZvcm1hbmNlCmJ1ZyBpbiB0aGUgREJNUy4NCg0KV2UgYXJlIHNoYXJpbmcgYSBwYWlyIG9m IFRQQy1IIHF1ZXJpZXMgdGhhdCBleGhpYml0IGEgcG90ZW50aWFsIHBlcmZvcm1hbmNlCmJ1ZyBp biB0aGlzIHJlcG9ydDoNCg0KRmlyc3QgcXVlcnk6DQpTRUxFQ1QgInNfc3VwcGtleSIgDQpGUk9N ICAgInN1cHBsaWVyIiANCldIRVJFICBzX3N1cHBrZXkgPiAxMDA7ICANCg0KU2Vjb25kIHF1ZXJ5 Og0KU0VMRUNUICJzX3N1cHBrZXkiIA0KRlJPTSAgICJzdXBwbGllciIgDQpXSEVSRSAgc19zdXBw a2V5ID4gMTAwIA0KR1JPVVAgIEJZIHNfc3VwcGtleTsgDQoNCltBY3R1YWwgQmVoYXZpb3JdDQpX ZSBleGVjdXRlZCBib3RoIHF1ZXJpZXMgb24gdGhlIFRQQy1IIGJlbmNobWFyayBvZiBzY2FsZSBm YWN0b3IgNTogdGhlIGZpcnN0CnF1ZXJ5IHRha2VzIG9ubHkgMTcgbWlsbGlzZWNvbmQsIHdoaWxl IHRoZSBzZWNvbmQgcXVlcnkgdGFrZXMgNDIKbWlsbGlzZWNvbmQuIFdlIHRoaW5rIHRoZSB0aW1l IGRpZmZlcmVuY2UgcmVzdWx0cyBmcm9tIGRpZmZlcmVudCBwbGFucwpzZWxlY3RlZC4NCg0KW1F1 ZXJ5IEV4ZWN1dGlvbiBQbGFuXQ0KRmlyc3QgcXVlcnk6DQogICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkgUExBTiAgICAgICAgICAgCiAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQotLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIFNlcSBTY2FuIG9uIHN1cHBsaWVy ICAoY29zdD0wLjAwLi4xNzM0LjAwIHJvd3M9NDk5MDkgd2lkdGg9NCkgKGFjdHVhbAp0aW1lPTAu MDQ3Li4xNC44OTggcm93cz00OTkwMCBsb29wcz0xKQ0KICAgRmlsdGVyOiAoc19zdXBwa2V5ID4g MTAwKQ0KICAgUm93cyBSZW1vdmVkIGJ5IEZpbHRlcjogMTAwDQogUGxhbm5pbmcgVGltZTogMC42 MzkgbXMNCiBFeGVjdXRpb24gVGltZTogMTcuNDY5IG1zDQooNSByb3dzKQ0KDQoNCg0KDQpTZWNv bmQgcXVlcnk6DQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgUVVFUlkKUExBTiAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAKDQotLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIEhh c2hBZ2dyZWdhdGUgIChjb3N0PTE4NTguNzcuLjIzNTcuODYgcm93cz00OTkwOSB3aWR0aD00KSAo YWN0dWFsCnRpbWU9MzAuMDkzLi4zOC41NDEgcm93cz00OTkwMCBsb29wcz0xKQ0KICAgR3JvdXAg S2V5OiBzX3N1cHBrZXkNCiAgIC0+ICBTZXEgU2NhbiBvbiBzdXBwbGllciAgKGNvc3Q9MC4wMC4u MTczNC4wMCByb3dzPTQ5OTA5IHdpZHRoPTQpIChhY3R1YWwKdGltZT0wLjA0Ny4uMTMuNjU2IHJv d3M9NDk5MDAgbG9vcHM9MSkNCiAgICAgICAgIEZpbHRlcjogKHNfc3VwcGtleSA+IDEwMCkNCiAg ICAgICAgIFJvd3MgUmVtb3ZlZCBieSBGaWx0ZXI6IDEwMA0KIFBsYW5uaW5nIFRpbWU6IDAuNjY5 IG1zDQogRXhlY3V0aW9uIFRpbWU6IDQyLjI3MCBtcw0KKDcgcm93cykNCg0KDQpbRXhwZWN0ZWQg QmVoYXZpb3JdDQpTaW5jZSB0aGVzZSB0d28gcXVlcmllcyBhcmUgc2VtYW50aWNhbGx5IGVxdWl2 YWxlbnQsIHdlIHdlcmUgaG9waW5nIHRoYXQKUG9zdGdyZVNRTCB3aWxsIHJldHVybiB0aGUgc2Ft ZSByZXN1bHRzIGluIHJvdWdobHkgdGhlIHNhbWUgYW1vdW50IG9mCnRpbWUuDQoNCg0KW1Rlc3Qg RW52aXJvbm1lbnRdDQpVYnVudHUgMTkuMTANClBvc3RncmVTUUwgdjEyLjMNCkRhdGFiYXNlOiBU UEMtSCBiZW5jaG1hcmsgKHdpdGggc2NhbGUgZmFjdG9yIDUpDQoNCg0KW1N0ZXBzIGZvciByZXBy b2R1Y2luZyBvdXIgb2JzZXJ2YXRpb25zXQ0KCQ0KKiBEb3dubG9hZCB0aGUgZGF0YXNldCBmcm9t IHRoZSBsaW5rOgpodHRwczovL2RyaXZlLmdvb2dsZS5jb20vZmlsZS9kLzEzckZhMUJORGk0ZTJS bVhCbi15RVFrY3F0NmxzQnUxYy92aWV3P3VzcD1zaGFyaW5nDQoqIFNldCB1cCBUUEMtSCBiZW5j aG1hcmsNCnRhciB4enZmIHRwY2g1X3Bvc3RncmVzcWwudGFyLmd6DQpjZCB0cGNoNV9wb3N0Z3Jl c3FsDQpkYj10cGNoNQ0KY3JlYXRlZGIgJGRiDQpwc3FsIC1kICRkYiA8IGRzcy5kZGwNCmZvciBp IGluIGBscyAqLnRibGANCmRvDQogICAgZWNobyAkaQ0KICAgIG5hbWU9YGVjaG8gJGl8Y3V0IC1k Jy4nIC1mMWANCiAgICBwc3FsIC1kICRkYiAtYyAiQ09QWSAkbmFtZSBGUk9NICdgcHdkYC8kaScg REVMSU1JVEVSICd8JyBFTkNPRElORwonTEFUSU4xJzsiDQpkb25lDQpwc3FsIC1kICRkYiA8IGRz c19wb3N0Z3Jlcy5yaQ0KKkV4ZWN1dGUgdGhlIHF1ZXJpZXMKCg== --===============7760575238465836774==--