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 1n3lhx-00009h-Vk for pgsql-committers@arkaria.postgresql.org; Sat, 01 Jan 2022 21:14:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n3lhw-00036V-Qq for pgsql-committers@arkaria.postgresql.org; Sat, 01 Jan 2022 21:14:32 +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 1n3lg9-0000Zj-WA for pgsql-committers@lists.postgresql.org; Sat, 01 Jan 2022 21:12:41 +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 1n3lg7-0000wb-1Z for pgsql-committers@lists.postgresql.org; Sat, 01 Jan 2022 21:12:41 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1n3lg3-0007Lk-QA for pgsql-committers@lists.postgresql.org; Sat, 01 Jan 2022 21:12:35 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1n3lg2-0003lC-Tb for pgsql-committers@lists.postgresql.org; Sat, 01 Jan 2022 21:12:34 +0000 Content-Type: multipart/mixed; boundary="===============6386470310429475068==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix index-only scan plans when not all index columns can be retu X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 01 Jan 2022 21:12:34 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6386470310429475068== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IGluZGV4LW9ubHkgc2NhbiBwbGFucyB3aGVuIG5vdCBhbGwgaW5kZXggY29sdW1ucyBjYW4g YmUgcmV0dXJuZWQuCgpJZiBhbiBpbmRleCBoYXMgYm90aCByZXR1cm5hYmxlIGFuZCBub24tcmV0 dXJuYWJsZSBjb2x1bW5zLCBhbmQgb25lIG9mCnRoZSBub24tcmV0dXJuYWJsZSBjb2x1bW5zIGlz IGFuIGV4cHJlc3Npb24gdXNpbmcgYSBWYXIgdGhhdCBpcyBpbiBhCnJldHVybmFibGUgY29sdW1u LCB0aGVuIGEgcXVlcnkgcmV0dXJuaW5nIHRoYXQgZXhwcmVzc2lvbiBjb3VsZCByZXN1bHQKaW4g YW4gaW5kZXgtb25seSBzY2FuIHBsYW4gdGhhdCBhdHRlbXB0cyB0byByZWFkIHRoZSBub24tcmV0 dXJuYWJsZQpjb2x1bW4sIGluc3RlYWQgb2YgcmVjb21wdXRpbmcgdGhlIGV4cHJlc3Npb24gZnJv bSB0aGUgcmV0dXJuYWJsZQpjb2x1bW4gYXMgaW50ZW5kZWQuCgpUbyBmaXgsIHJlZGVmaW5lIHRo ZSAiaW5kZXh0bGlzdCIgbGlzdCBvZiBhbiBJbmRleE9ubHlTY2FuIHBsYW4gbm9kZQphcyBjb250 YWluaW5nIG51bGwgQ29uc3RzIGluIHBsYWNlIG9mIGFueSBub24tcmV0dXJuYWJsZSBjb2x1bW5z LgpUaGlzIHNvbHZlcyB0aGUgcHJvYmxlbSBieSBwcmV2ZW50aW5nIHNldHJlZnMuYyBmcm9tIGZh bHNlbHkgbWF0Y2hpbmcKdG8gc3VjaCBlbnRyaWVzLiAgVGhlIGV4ZWN1dG9yIGlzIGhhcHB5IHNp bmNlIGl0IG9ubHkgY2FyZXMgYWJvdXQgdGhlCmV4cG9zZWQgdHlwZXMgb2YgdGhlIGVudHJpZXMs IGFuZCBydWxldXRpbHMuYyBkb2Vzbid0IGNhcmUgYmVjYXVzZSBhCmNvcnJlY3QgcGxhbiB3b24n dCByZWZlcmVuY2UgdGhvc2UgZW50cmllcy4gIEkgY29uc2lkZXJlZCBzb21lIG90aGVyCndheXMg dG8gcHJldmVudCBzZXRyZWZzLmMgZnJvbSBkb2luZyB0aGUgd3JvbmcgdGhpbmcsIGJ1dCB0aGlz IHdheQpzZWVtcyBnb29kIHNpbmNlIChhKSBpdCBhbGxvd3MgYSB2ZXJ5IGxvY2FsaXplZCBmaXgs IChiKSBpdCBtYWtlcwp0aGUgaW5kZXh0bGlzdCBzdHJ1Y3R1cmUgbW9yZSBjb21wYWN0IGluIG1h bnkgY2FzZXMsIGFuZCAoYykgdGhlCmluZGV4dGxpc3QgaXMgbm93IGEgbW9yZSBmYWl0aGZ1bCBy ZXByZXNlbnRhdGlvbiBvZiB3aGF0IHRoZSBpbmRleCBBTQp3aWxsIGFjdHVhbGx5IHByb2R1Y2Us IHZpei4gbnVsbHMgZm9yIGFueSBub24tcmV0dXJuYWJsZSBjb2x1bW5zLgoKVGhpcyBpcyBlYXNp ZXIgdG8gaGl0IHNpbmNlIHdlIGludHJvZHVjZWQgaW5jbHVkZWQgY29sdW1ucywgYnV0IGl0J3MK cG9zc2libGUgdG8gY29uc3RydWN0IGZhaWxpbmcgZXhhbXBsZXMgd2l0aG91dCB0aGF0LCBhcyBw ZXIgdGhlCmFkZGVkIHJlZ3Jlc3Npb24gdGVzdC4gIEhlbmNlLCBiYWNrLXBhdGNoIHRvIGFsbCBz dXBwb3J0ZWQgYnJhbmNoZXMuCgpQZXIgYnVnICMxNzM1MCBmcm9tIExvdWlzIEphY2hpZXQuCgpE aXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzE3MzUwLWI1YmRjZjQ3NmU1YmFkYmJAcG9z dGdyZXNxbC5vcmcKCkJyYW5jaAotLS0tLS0KUkVMXzEyX1NUQUJMRQoKRGV0YWlscwotLS0tLS0t Cmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvZjc4OWI3NzMyZTBiNTM1 ZmUyNTg4ODc5YTYwZjUzNmFiZmI2YzZlMAoKTW9kaWZpZWQgRmlsZXMKLS0tLS0tLS0tLS0tLS0K c3JjL2JhY2tlbmQvb3B0aW1pemVyL3BsYW4vY3JlYXRlcGxhbi5jIHwgNTMgKysrKysrKysrKysr KysrKysrKysrKysrKysrKysrKy0tCnNyYy9pbmNsdWRlL25vZGVzL3BsYW5ub2Rlcy5oICAgICAg ICAgICB8ICAzICstCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvZ2lzdC5vdXQgICAgICB8IDI4 ICsrKysrKysrKysrKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3Mvc3FsL2dpc3Quc3FsICAgICAgICAg ICB8IDExICsrKysrKysKNCBmaWxlcyBjaGFuZ2VkLCA5MiBpbnNlcnRpb25zKCspLCAzIGRlbGV0 aW9ucygtKQoK --===============6386470310429475068==--