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 1lXUOl-0007fl-U4 for pgsql-bugs@arkaria.postgresql.org; Fri, 16 Apr 2021 19:45:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lXUOk-0005A3-SN for pgsql-bugs@arkaria.postgresql.org; Fri, 16 Apr 2021 19:45:02 +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 1lXTzl-0004kJ-Je for pgsql-bugs@lists.postgresql.org; Fri, 16 Apr 2021 19:19:13 +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 1lXTze-0002ZI-KM for pgsql-bugs@lists.postgresql.org; Fri, 16 Apr 2021 19:19: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=b9ohPiqxaaC7Z+LXUhANc3iuyS4GpvXoFxCk2JwOSGo=; b=nz9856fdalAvMyn2Y1JzVJkB2D VBeg90dL6sZAG1h2tHvmc6zwbO/JjVRM32CsLKf1GLMp/vErN2ZDUb0S4g36a2ybSX3dAXyI8je45 QOA7JxqloNA/9YZsz5/Z43k47BKzNqprxL4ul81bNoUl5PI8/C9GcjfKx7s+TTU1ALeBCO+368bc/ 6IVIjX6Fi66y3ADDG51FCa3bD+ATip4PnimMkJ/TBd8NhGUvhcMHFMuk6w4WH+uLk1DjbQe2p3iIs C85tyhjJ5dNMZeVuvSnNfCH/fLHipB87rOAzIacu7TFHNgd0wcoNfrTFZ7KQ56/zLkFQcZ5QQEGpJ MtyJZtTQ==; 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 1lXTzb-0001Hh-Uy for pgsql-bugs@lists.postgresql.org; Fri, 16 Apr 2021 19:19:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lXTza-0006r9-PC for pgsql-bugs@lists.postgresql.org; Fri, 16 Apr 2021 19:19:02 +0000 Content-Type: multipart/mixed; boundary="===============1834470357673587012==" MIME-Version: 1.0 Subject: BUG #16968: Planner does not recognize optimization To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: kes-kes@yandex.ru Reply-To: kes-kes@yandex.ru, pgsql-bugs@lists.postgresql.org Date: Fri, 16 Apr 2021 19:18:45 +0000 Message-ID: <16968-9c8a1708c1c04355@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1834470357673587012== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNjk2OApMb2dnZWQgYnk6ICAgICAgICAgIEV1Z2VuIEtvbmtvdgpFbWFp bCBhZGRyZXNzOiAgICAgIGtlcy1rZXNAeWFuZGV4LnJ1ClBvc3RncmVTUUwgdmVyc2lvbjogMTMu MQpPcGVyYXRpbmcgc3lzdGVtOiAgIExpbnV4IE1pbnQgMTkuMwpEZXNjcmlwdGlvbjogICAgICAg IAoKVExEUjsNCklmIEkgcmVmZXIgdG8gc2FtZSBjb2x1bW4gYnkgZGlmZmVyZW50IHdheXMgcGxh bm5lciBtYXkgb3IgbWF5IG5vdCByZWNvZ25pemUKb3B0aW1pemF0aW9uDQoNCnNlbGVjdCAqIGZy b20gb3JkZXJfdG90YWxfc3VtYSgpIG90cyB3aGVyZSBhZ3JlZW1lbnRfaWQgPSAzOTQzOyAgICAg ICAgICAgIAotLSBmYXN0DQpzZWxlY3QgKiBmcm9tIG9yZGVyX3RvdGFsX3N1bWEoKSBvdHMgd2hl cmUgKG90cy5vKS5hZ3JlZW1lbnRfaWQgPSAzOTQzOyAgLS0Kc2xvdw0KDQpXaGVyZSBgb3JkZXJf dG90YWxfc3VtYWAgaXMgc3FsIGZ1bmN0aW9uOg0KDQoJCVNFTEVDVA0KCQkgc3VtKCBvY2QuaXRl bV9zdW1hICAgICApIE9WRVIoIFBBUlRJVElPTiBCWSAob2NkLm8pLmFncmVlbWVudF9pZCAgICAg ICAgIAogICAgICAgKSBBUyBhZ3JlZW1lbnRfc3VtYSwNCgkJIHN1bSggb2NkLml0ZW1fc3VtYSAg ICAgKSBPVkVSKCBQQVJUSVRJT04gQlkgKG9jZC5vKS5hZ3JlZW1lbnRfaWQsCihvY2QubykuaWQg ICAgICAgICAgICAgICAgICAgICAgICAgICApIEFTIG9yZGVyX3N1bWEsDQoJCSBzdW0oIG9jZC5p dGVtX2Nvc3QgICAgICkgT1ZFUiggUEFSVElUSU9OIEJZIChvY2QubykuYWdyZWVtZW50X2lkLAoo b2NkLm8pLmlkLCAob2NkLmljKS5jb25zdW1lZF9wZXJpb2QgKSBBUyBncm91cF9jb3N0LA0KCQkg c3VtKCBvY2QuaXRlbV9zdW1hICAgICApIE9WRVIoIFBBUlRJVElPTiBCWSAob2NkLm8pLmFncmVl bWVudF9pZCwKKG9jZC5vKS5pZCwgKG9jZC5pYykuY29uc3VtZWRfcGVyaW9kICkgQVMgZ3JvdXBf c3VtYSwNCgkJIG1heCggKG9jZC5pYykuY29uc3VtZWQgKSBPVkVSKCBQQVJUSVRJT04gQlkgKG9j ZC5vKS5hZ3JlZW1lbnRfaWQsCihvY2QubykuaWQsIChvY2QuaWMpLmNvbnN1bWVkX3BlcmlvZCAp IEFTIGNvbnN1bWVkLA0KCQkgb2NkLml0ZW1fcXR5LCBvY2QuaXRlbV9wcmljZSwgb2NkLml0ZW1f Y29zdCwgb2NkLml0ZW1fc3VtYSwNCgkJIG9jZC5vLCBvY2QuYywgb2NkLnAsIG9jZC5pYywNCgkJ IChvY2QubykuaWQgYXMgb3JkZXJfaWQsDQoJCSAob2NkLm8pLmFncmVlbWVudF9pZCBhcyBhZ3Jl ZW1lbnRfaWQNCgkJRlJPTSBvcmRlcl9jb3N0X2RldGFpbHMoIF90YXJnZXRfcmFuZ2UgKSBvY2QN Cg0KUHJvYmxlbSBpcyB3aW5kb3cgZnVuY3Rpb24sIGJlY2F1c2UgSUQgY2FuIG5vdCBnbyB0aHJv dWdoLiBCdXQgdGhpcyBvY2N1cgpub3QgYWx3YXlzLg0KV2hlbiBJIGZpbHRlciBieSBmaWVsZCBJ IHBhcnRpdGlvbiByZXN1bHQgYnkgdGhlbiBvcHRpbWl6YXRpb24gb2NjdXIgDQpCVVQgb25seSB3 aGVuIEkgY3JlYXRlIGFuIGFsaWFzIGZvciB0aGlzIGZpZWxkIGFuZCBkbyBmaWx0ZXJpbmcgdmlh IHRoaXMKYWxpYXMuDQoNCkV4cGVjdGVkOiBhcHBseSBvcHRpbWl6YXRpb24gbm90IG9ubHkgd2hl biBJIGRvIGBXSEVSRSBhZ3JlZW1lbnRfaWQgPSBYWFhgCg0KYnV0IGFuZCBmb3IgYFdIRVJFIChv dHMubykuYWdyZWVtZW50X2lkID0gWFhYYA0KDQpUaGFuayB5b3UuCgo= --===============1834470357673587012==--