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 1n3li0-00009f-Ti for pgsql-committers@arkaria.postgresql.org; Sat, 01 Jan 2022 21:14:36 +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-00036W-Qv 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 1n3lgC-0001XK-DA for pgsql-committers@lists.postgresql.org; Sat, 01 Jan 2022 21:12:44 +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-0000wc-4C for pgsql-committers@lists.postgresql.org; Sat, 01 Jan 2022 21:12:44 +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-0007Lh-QB 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-0003l5-SA for pgsql-committers@lists.postgresql.org; Sat, 01 Jan 2022 21:12:34 +0000 Content-Type: multipart/mixed; boundary="===============5067257201290399590==" 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 --===============5067257201290399590== 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 dGdyZXNxbC5vcmcKCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0KaHR0cHM6 Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi80YWNlNDU2Nzc2NTI0ODM5ZWYzMjc5 YWIwYmFkOGEyYzlmNmNjMmE3CgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpzcmMvYmFj a2VuZC9vcHRpbWl6ZXIvcGxhbi9jcmVhdGVwbGFuLmMgfCA1MyArKysrKysrKysrKysrKysrKysr KysrKysrKysrKysrLS0Kc3JjL2luY2x1ZGUvbm9kZXMvcGxhbm5vZGVzLmggICAgICAgICAgIHwg IDMgKy0Kc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9naXN0Lm91dCAgICAgIHwgMjggKysrKysr KysrKysrKysrKysKc3JjL3Rlc3QvcmVncmVzcy9zcWwvZ2lzdC5zcWwgICAgICAgICAgIHwgMTEg KysrKysrKwo0IGZpbGVzIGNoYW5nZWQsIDkyIGluc2VydGlvbnMoKyksIDMgZGVsZXRpb25zKC0p Cgo= --===============5067257201290399590==--