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 1moqvl-0005m2-EY for pgsql-bugs@arkaria.postgresql.org; Sun, 21 Nov 2021 17:47:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1moqvk-0003fq-C1 for pgsql-bugs@arkaria.postgresql.org; Sun, 21 Nov 2021 17:47:08 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1moTbv-0001qC-Ne for pgsql-bugs@lists.postgresql.org; Sat, 20 Nov 2021 16:53:07 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1moTbr-0005Fr-QQ for pgsql-bugs@lists.postgresql.org; Sat, 20 Nov 2021 16:53:06 +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=ayu7BXJLy6G3yOFjOy+yM6Zu2E06yUSpr0WIxiTsbxU=; b=WROVeacndF3bIOlgd/lR5qmE3e Wl949pOuC7LNUR61odQpAJ54S8BbQMuEFNcA0yCmsTImEW3kFWyVLE3WS742uGx22UOmIsGcoDboS LfZ6t9EuAM0edPaC1Q9TAnP5fD5MkkiEsR+7fUKfjEN3BjeUtqihIQRGrZEUfOj52gYP22vqnTZJu E5kQ6smJh0wnOaVh6QeplUR4OG0XpYTbYUmblHR+J82AFMLFkKetk7oSauqy5n8b1pYigIH4r1Mvm RDdj8hkcJmAj+BGKTEc3i5zfG+7DDkU9rjkil04+UxALdehYQjw4axDhMjnwir+hLWwYVmSCAoZ0k xAUr+YEQ==; 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 1moTbr-0001CW-6M for pgsql-bugs@lists.postgresql.org; Sat, 20 Nov 2021 16:53:03 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1moTbq-0004cO-0z for pgsql-bugs@lists.postgresql.org; Sat, 20 Nov 2021 16:53:02 +0000 Content-Type: multipart/mixed; boundary="===============8343953748772263338==" MIME-Version: 1.0 Subject: BUG #17295: Different query plan with Index Only Scan and Bitmap Index Scan. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: udv.mail@gmail.com Reply-To: udv.mail@gmail.com, pgsql-bugs@lists.postgresql.org Date: Sat, 20 Nov 2021 16:52:50 +0000 Message-ID: <17295-82a33e30e35c0cd5@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 --===============8343953748772263338== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzI5NQpMb2dnZWQgYnk6ICAgICAgICAgIERtaXRyeQpFbWFpbCBhZGRy ZXNzOiAgICAgIHVkdi5tYWlsQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDEzLjIKT3Bl cmF0aW5nIHN5c3RlbTogICBEZWJpYW4gMTAgYnVzdGVyLCA0LjE5LjAtMTQtYW1kNjQKRGVzY3Jp cHRpb246ICAgICAgICAKCkhlbGxvLg0KQXMgZGVzY3JpYmVkIGluIGRvY3VtZW50YXRpb24gIjEx LjUuIENvbWJpbmluZyBNdWx0aXBsZSBJbmRleGVzIjogIlRvCmNvbWJpbmUgbXVsdGlwbGUgaW5k ZXhlcywgdGhlIHN5c3RlbSBzY2FucyBlYWNoIG5lZWRlZCBpbmRleCBhbmQgcHJlcGFyZXMgYQpi aXRtYXAgaW4gbWVtb3J5IGdpdmluZyB0aGUgbG9jYXRpb25zIG9mIHRhYmxlIHJvd3MgdGhhdCBh cmUgcmVwb3J0ZWQgYXMKbWF0Y2hpbmcgdGhhdCBpbmRleCdzIGNvbmRpdGlvbnMuIFRoZSBiaXRt YXBzIGFyZSB0aGVuIEFORGVkIGFuZCBPUmVkCnRvZ2V0aGVyIGFzIG5lZWRlZCBieSB0aGUgcXVl cnkuIi4NCk1heSBiZSBpbnRlcmVzdGluZyB0aGluZywgdGhhdCB3aXRoIHVzaW5nIElOIGluc3Rl YWQgb2YgT1JlZCBjb25kaXRpb25zLApQb3N0Z3JlcyBnZW5lcmF0ZXMgZGlmZmVyZW50IHBsYW5z IGZvciBxdWVyaWVzLg0KDQpQb3N0Z3JlU1FMIDEzLjIgb24geDg2XzY0LXBjLWxpbnV4LWdudSwg Y29tcGlsZWQgYnkgZ2NjIChEZWJpYW4gOC4zLjAtNikKOC4zLjAsIDY0LWJpdHwNCkRlYmlhbiAx MCBidXN0ZXIsIDQuMTkuMC0xNC1hbWQ2NCBEZWJpYW4gOC4zLjAtNg0KDQpDUkVBVEUgVEFCTEUg dChhIElOVEVHRVIsIGIgSU5URUdFUik7DQpJTlNFUlQgSU5UTyB0KGEsYikNCiAgU0VMRUNUICgx MDAqcmFuZG9tKCkqcy5pZCk6OklOVCwgKDEwMCpyYW5kb20oKSpzLmlkKTo6SU5UDQogIEZST00g Z2VuZXJhdGVfc2VyaWVzKCAxLCAxMDAwMDAwICkgQVMgcyggaWQgKTsNCkNSRUFURSBJTkRFWCB0 X2kgT04gdChhLGIpOw0KDQpFWFBMQUlOIFNFTEVDVCAqIEZST00gdCBXSEVSRSBhPTE0MiBPUiBh PTE0NyBPUiBhPTE1MyBPUiBhPTE5OTsNCi0tIEJpdG1hcCBIZWFwIFNjYW4gb24gdCAgKGNvc3Q9 MTcuNzMuLjMzLjQ1IHJvd3M9NCB3aWR0aD04KSAgICAgICAgICAgICB8DQotLSAgIFJlY2hlY2sg Q29uZDogKChhID0gMTQyKSBPUiAoYSA9IDE0NykgT1IgKGEgPSAxNTMpIE9SIChhID0gMTk5KSkg ICAgfA0KLS0gICAtPiAgQml0bWFwT3IgIChjb3N0PTE3LjczLi4xNy43MyByb3dzPTQgd2lkdGg9 MCkgICAgICAgICAgICAgICAgICAgIHwNCi0tICAgICAgICAgLT4gIEJpdG1hcCBJbmRleCBTY2Fu IG9uIHRfaSAgKGNvc3Q9MC4wMC4uNC40MyByb3dzPTEgd2lkdGg9MCl8DQotLSAgICAgICAgICAg ICAgIEluZGV4IENvbmQ6IChhID0gMTQyKSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgfA0KLS0gICAgICAgICAtPiAgQml0bWFwIEluZGV4IFNjYW4gb24gdF9pICAoY29zdD0wLjAw Li40LjQzIHJvd3M9MSB3aWR0aD0wKXwNCi0tICAgICAgICAgICAgICAgSW5kZXggQ29uZDogKGEg PSAxNDcpICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICB8DQotLSAgICAgICAgIC0+ ICBCaXRtYXAgSW5kZXggU2NhbiBvbiB0X2kgIChjb3N0PTAuMDAuLjQuNDMgcm93cz0xIHdpZHRo PTApfA0KLS0gICAgICAgICAgICAgICBJbmRleCBDb25kOiAoYSA9IDE1MykgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgIHwNCi0tICAgICAgICAgLT4gIEJpdG1hcCBJbmRleCBTY2Fu IG9uIHRfaSAgKGNvc3Q9MC4wMC4uNC40MyByb3dzPTEgd2lkdGg9MCl8DQotLSAgICAgICAgICAg ICAgIEluZGV4IENvbmQ6IChhID0gMTk5KSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgfA0KDQpFWFBMQUlOIFNFTEVDVCAqIEZST00gdCBXSEVSRSBhIElOICgxNDIsMTQ3LDE1Mywx OTkpOw0KLS0gSW5kZXggT25seSBTY2FuIHVzaW5nIHRfaSBvbiB0ICAoY29zdD0wLjQyLi4xNy43 NyByb3dzPTQgd2lkdGg9OCl8DQotLSAgIEluZGV4IENvbmQ6IChhID0gQU5ZICgnezE0MiwxNDcs MTUzLDE5OX0nOjppbnRlZ2VyW10pKSAgICAgICAgIHwNCg0KSWYgd2UgZW5sYXJnZSB0YWJsZSB3 aXRoIGdlbmVyYXRlX3NlcmllcyggMSwgMTAwMDAwMDAgKSwgdGhlIHJlc3VsdApjaGFuZ2VzOg0K DQpFWFBMQUlOIFNFTEVDVCAqIEZST00gdCBXSEVSRSBhIElOICgxNDIsMTQ3LDE1MywxOTkpOw0K LS0gQml0bWFwIEhlYXAgU2NhbiBvbiB0ICAoY29zdD0zNzM5Ljc0Li41MDk4Ny43NCByb3dzPTIw MDAwMCB3aWR0aD04KSAgICAKfA0KLS0gICBSZWNoZWNrIENvbmQ6IChhID0gQU5ZICgnezE0Miwx NDcsMTUzLDE5OX0nOjppbnRlZ2VyW10pKSAgICAgICAgICAgICAKfA0KLS0gICAtPiAgQml0bWFw IEluZGV4IFNjYW4gb24gdF9pICAoY29zdD0wLjAwLi4zNjg5Ljc0IHJvd3M9MjAwMDAwCndpZHRo PTApfA0KLS0gICAgICAgICBJbmRleCBDb25kOiAoYSA9IEFOWSAoJ3sxNDIsMTQ3LDE1MywxOTl9 Jzo6aW50ZWdlcltdKSkgICAgICAgICAKfA0KDQpTZXZlcmFsIG1pbnV0ZXMgbGF0ZXI6DQpFWFBM QUlOIFNFTEVDVCAqIEZST00gdCBXSEVSRSBhIElOICgxNDIsMTQ3LDE1MywxOTkpOw0KLS0gSW5k ZXggT25seSBTY2FuIHVzaW5nIHRfaSBvbiB0ICAoY29zdD0wLjQzLi4xNy44MSByb3dzPTQgd2lk dGg9OCl8DQotLSAgIEluZGV4IENvbmQ6IChhID0gQU5ZICgnezE0MiwxNDcsMTUzLDE5OX0nOjpp bnRlZ2VyW10pKSAgICAgICAgIHwNCg0KT1JlZCBjb25kaXRpb25zIGRpZCBub3QgY2hhbmdlZCwg c3RpbGwgc2V2ZXJhbCBCaXRtYXBzLg0KDQpCZXN0IHJlZ2FyZHMsIERtaXRyeS4KCg== --===============8343953748772263338==--