Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w3ewE-001QsF-37 for pgsql-committers@arkaria.postgresql.org; Fri, 20 Mar 2026 18:51:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w3ewB-007oNX-1z for pgsql-committers@arkaria.postgresql.org; Fri, 20 Mar 2026 18:51:12 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w3ewB-007oNO-1J for pgsql-committers@lists.postgresql.org; Fri, 20 Mar 2026 18:51:11 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w3ew4-00000000DDV-3Y1H for pgsql-committers@lists.postgresql.org; Fri, 20 Mar 2026 18:51:05 +0000 Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w3ew4-0025c6-0h for pgsql-committers@lists.postgresql.org; Fri, 20 Mar 2026 18:51:04 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w3ew1-000gLf-0x for pgsql-committers@lists.postgresql.org; Fri, 20 Mar 2026 18:51:02 +0000 Content-Type: multipart/mixed; boundary="===============2103587088795815777==" MIME-Version: 1.0 From: Tom Lane To: pgsql-committers@lists.postgresql.org Subject: pgsql: Discount the metapage when estimating number of index pages visi X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Fri, 20 Mar 2026 18:51:02 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2103587088795815777== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 RGlzY291bnQgdGhlIG1ldGFwYWdlIHdoZW4gZXN0aW1hdGluZyBudW1iZXIgb2YgaW5kZXggcGFn ZXMgdmlzaXRlZC4KCmdlbmVyaWNjb3N0ZXN0aW1hdGUoKSBlc3RpbWF0ZXMgdGhlIG51bWJlciBv ZiBpbmRleCBsZWFmIHBhZ2VzIHRvCmJlIHZpc2l0ZWQgYXMgYSBwcm8tcmF0YSBmcmFjdGlvbiBv ZiB0aGUgdG90YWwgbnVtYmVyIG9mIGxlYWYgcGFnZXMuCk9yIGF0IGxlYXN0IHRoYXQgd2FzIHRo ZSBpbnRlbnRpb24uICBXaGF0IGl0IGFjdHVhbGx5IHVzZWQgaW4gdGhlCmNhbGN1bGF0aW9uIHdh cyB0aGUgdG90YWwgbnVtYmVyIG9mIGluZGV4IHBhZ2VzLCBzbyB0aGF0IG5vbi1sZWFmCnBhZ2Vz IHdlcmUgYWxzbyBjb3VudGVkLiAgSW4gYSBkZWNlbnQtc2l6ZWQgaW5kZXggdGhlIGVycm9yIGlz CnByb2JhYmx5IHNtYWxsLCBzaW5jZSB3ZSBleHBlY3QgdXBwZXIgcGFnZSBmYW5vdXQgdG8gYmUg aGlnaC4KQnV0IGluIGEgc21hbGwgaW5kZXggdGhhdCdzIG5vdCB0cnVlOyBpbiB0aGUgd29yc3Qg Y2FzZSB3aXRoIG9uZQpkYXRhLWJlYXJpbmcgcGFnZSBwbHVzIGEgbWV0YXBhZ2UsIHdlIGhhZCAx MDAlIHJlbGF0aXZlIGVycm9yLgpUaGlzIGxlZCB0byBzdXJwcmlzaW5nIHBsYW5uaW5nIGNob2lj ZXMgc3VjaCBhcyBub3QgdXNpbmcgYSBzbWFsbApwYXJ0aWFsIGluZGV4LgoKVG8gZml4LCBhc2sg Z2VuZXJpY2Nvc3Rlc3RpbWF0ZSdzIGNhbGxlciB0byBzdXBwbHkgYW4gZXN0aW1hdGUgb2YKdGhl IG51bWJlciBvZiBub24tbGVhZiBwYWdlcywgYW5kIHN1YnRyYWN0IHRoYXQuICBGb3IgdGhlIGJ1 aWx0LWluCmluZGV4IEFNcywgaXQgc2VlbXMgc3VmZmljaWVudCB0byBjb3VudCB0aGUgaW5kZXgg bWV0YXBhZ2UgKGlmIHRoZQpBTSB1c2VzIG9uZSkgYXMgbm9uLWxlYWYuICBQZXIgdGhlIGFib3Zl IGFyZ3VtZW50LCBjb3VudGluZyB1cHBlcgppbmRleCBwYWdlcyBzaG91bGRuJ3QgY2hhbmdlIHRo ZSBlc3RpbWF0ZSBtdWNoLCBhbmQgaW4gbW9zdCBjYXNlcwp3ZSBkb24ndCBoYXZlIGFueSBlYXN5 IHdheSBvZiBlc3RpbWF0aW5nIHRoZSBudW1iZXIgb2YgdXBwZXIgcGFnZXMuClRoaXMgbWlnaHQg YmUgYW4gYXJlYSBmb3IgZnVydGhlciByZXNlYXJjaCBpbiBmdXR1cmUuCgpBbnkgZXh0ZXJuYWwg Z2VuZXJpY2Nvc3Rlc3RpbWF0ZSBjYWxsZXJzIHRoYXQgZG8gbm90IHNldCB0aGUgbmV3IGZpZWxk CkdlbmVyaWNDb3N0cy5udW1Ob25MZWFmUGFnZXMgd2lsbCBzZWUgdGhlIHNhbWUgYmVoYXZpb3Ig YXMgYmVmb3JlLAphc3N1bWluZyB0aGV5IGZvbGxvd2VkIHRoZSBhZHZpY2UgdG8gemVybyBvdXQg dGhhdCB3aG9sZSBzdHJ1Y3QuCgpVbnN1cnByaXNpbmdseSwgdGhpcyBjaGFuZ2UgYWZmZWN0cyBh IG51bWJlciBvZiBwbGFucyBzZWVuIGluIHRoZQpjb3JlIHJlZ3Jlc3Npb24gdGVzdHMuICBJIGhh Y2tlZCB1cCB0aGUgZXhpc3RpbmcgdGVzdHMgdG8ga2VlcCB0aGUKdGVzdHMnIHBsYW5zIHRoZSBz YW1lLCBzaW5jZSBpbiBlYWNoIGNhc2UgaXQgYXBwZWFyZWQgdGhhdCB0aGUKdGVzdCdzIGludGVu dCB3YXMgdG8gdGVzdCBleGFjdGx5IHRoYXQgcGxhbi4gIEFsc28gYWRkIG9uZSBuZXcKdGVzdCBj YXNlIGRlbW9uc3RyYXRpbmcgdGhhdCBhIGJldHRlciBpbmRleCBjaG9pY2UgaXMgbm93IG1hZGUu CgpBdXRob3I6IFRvbSBMYW5lIDx0Z2xAc3NzLnBnaC5wYS51cz4KUmV2aWV3ZWQtYnk6IEhlbnNv biBDaG9pIDxhc3NhbTI1OEBnbWFpbC5jb20+CkRpc2N1c3Npb246IGh0dHBzOi8vcG9zdGdyLmVz L20vODcwNTIxLjE3NDU4NjA3NTJAc3NzLnBnaC5wYS51cwoKQnJhbmNoCi0tLS0tLQptYXN0ZXIK CkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZm LzczM2YyMGRmNTM3MjFiNWJlMDQ4MWFmZTlmMjZiOWMyYTRkNTE3MTIKCk1vZGlmaWVkIEZpbGVz Ci0tLS0tLS0tLS0tLS0tCmNvbnRyaWIvYmxvb20vYmxjb3N0LmMgICAgICAgICAgICAgICAgfCAg MyArKysKc3JjL2JhY2tlbmQvdXRpbHMvYWR0L3NlbGZ1bmNzLmMgICAgICB8IDMyICsrKysrKysr KysrKysrKysrKysrKysrKysrKystLS0tCnNyYy9pbmNsdWRlL3V0aWxzL3NlbGZ1bmNzLmggICAg ICAgICAgfCAgNyArKysrKysrCnNyYy90ZXN0L3JlZ3Jlc3MvZXhwZWN0ZWQvam9pbi5vdXQgICAg fCAgOCArKysrKy0tLQpzcmMvdGVzdC9yZWdyZXNzL2V4cGVjdGVkL21lbW9pemUub3V0IHwgIDIg KysKc3JjL3Rlc3QvcmVncmVzcy9leHBlY3RlZC9zZWxlY3Qub3V0ICB8IDE1ICsrKysrKysrKysr KysrLQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9qb2luLnNxbCAgICAgICAgIHwgMTAgKysrKysrLS0t LQpzcmMvdGVzdC9yZWdyZXNzL3NxbC9tZW1vaXplLnNxbCAgICAgIHwgIDIgKysKc3JjL3Rlc3Qv cmVncmVzcy9zcWwvc2VsZWN0LnNxbCAgICAgICB8IDExICsrKysrKysrKystCjkgZmlsZXMgY2hh bmdlZCwgNzcgaW5zZXJ0aW9ucygrKSwgMTMgZGVsZXRpb25zKC0pCgo= --===============2103587088795815777==--