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 1w1D2N-00065Q-1q for pgsql-committers@arkaria.postgresql.org; Sat, 14 Mar 2026 00:39:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w1D1L-000cCB-3A for pgsql-committers@arkaria.postgresql.org; Sat, 14 Mar 2026 00:38:24 +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 1w1D1L-000cC3-2U for pgsql-committers@lists.postgresql.org; Sat, 14 Mar 2026 00:38:24 +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 1w1D1J-000000002GJ-3vtA for pgsql-committers@lists.postgresql.org; Sat, 14 Mar 2026 00:38:23 +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 1w1D1J-0006JB-13 for pgsql-committers@lists.postgresql.org; Sat, 14 Mar 2026 00:38:22 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w1D1I-0003Of-1q for pgsql-committers@lists.postgresql.org; Sat, 14 Mar 2026 00:38:21 +0000 Content-Type: multipart/mixed; boundary="===============6548493460594078237==" MIME-Version: 1.0 From: Peter Geoghegan To: pgsql-committers@lists.postgresql.org Subject: pgsql: Use fake LSNs to improve nbtree dropPin behavior. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sat, 14 Mar 2026 00:38:21 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============6548493460594078237== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VXNlIGZha2UgTFNOcyB0byBpbXByb3ZlIG5idHJlZSBkcm9wUGluIGJlaGF2aW9yLgoKVXNlIGZh a2UgTFNOcyBpbiBhbGwgbmJ0cmVlIGNyaXRpY2FsIHNlY3Rpb25zIHRoYXQgd3JpdGUgYSBXQUwg cmVjb3JkLgpUaGF0IHdheSB3ZSBjYW4gc2FmZWx5IGFwcGx5IHRoZSBfYnRfa2lsbGl0ZW1zIExT TiB0cmljayB3aXRoIGxvZ2dlZCBhbmQKdW5sb2dnZWQgaW5kZXhlcyBhbGlrZS4gIFRoaXMgYnJp bmdzIHRoZSBzYW1lIGJlbmVmaXRzIHRvIHBsYWluIHNjYW5zIG9mCnVubG9nZ2VkIHJlbGF0aW9u cyB0aGF0IGNvbW1pdCAyZWQ1Yjg3ZiBicm91Z2h0IHRvIHBsYWluIHNjYW5zIG9mIGxvZ2dlZApy ZWxhdGlvbnM6IHNjYW5zIHdpbGwgZHJvcCB0aGVpciBsZWFmIHBhZ2UgcGluIGVhZ2VybHkgKGJ5 IGFwcGx5aW5nIHRoZQoiZHJvcFBpbiIgb3B0aW1pemF0aW9uKSwgd2hpY2ggYXZvaWRzIGJsb2Nr aW5nIHByb2dyZXNzIGJ5IFZBQ1VVTS4gIFRoaXMKaXMgcGFydGljdWxhcmx5IGhlbHBmdWwgd2l0 aCBhcHBsaWNhdGlvbnMgdGhhdCBhbGxvdyBhIHNjcm9sbGFibGUgY3Vyc29yCnRvIHJlbWFpbiBp ZGxlIGZvciBsb25nIHBlcmlvZHMuCgpQcmVwYXJhdGlvbiBmb3IgYW4gdXBjb21pbmcgY29tbWl0 IHRoYXQgd2lsbCBhZGQgdGhlIGFtZ2V0YmF0Y2gKaW50ZXJmYWNlLCBhbmQgc3dpdGNoIG5idHJl ZSBvdmVyIHRvIGl0IChmcm9tIGFtZ2V0dHVwbGUpIHRvIGVuYWJsZSBJL08KcHJlZmV0Y2hpbmcu ICBUaGUgaW5kZXggcHJlZmV0Y2hpbmcgcmVhZCBzdHJlYW0ncyBlZmZlY3RpdmUgcHJlZmV0Y2gK ZGlzdGFuY2UgaXMgYWR2ZXJzZWx5IGFmZmVjdGVkIGJ5IGFueSBidWZmZXIgcGlucyBoZWxkIGJ5 IHRoZSBpbmRleCBBTS4KQXQgdGhlIHNhbWUgdGltZSwgaXQgY2FuIGJlIHVzZWZ1bCBmb3IgcHJl ZmV0Y2hpbmcgdG8gcmVhZCBkb3plbnMgb2YKbGVhZiBwYWdlcyBhaGVhZCBvZiB0aGUgc2NhbiB0 byBtYWludGFpbiBhbiBhZGVxdWF0ZSBwcmVmZXRjaCBkaXN0YW5jZS4KClRoZSBpbmRleCBwcmVm ZXRjaGluZyBwYXRjaCBhdm9pZHMgdGhpcyB0ZW5zaW9uIGJ5IGFsd2F5cyBlYWdlcmx5CmRyb3Bw aW5nIGluZGV4IHBhZ2UgcGlucyBvZiB0aGUga2luZCB0cmFkaXRpb25hbGx5IGhlbGQgYXMgYW4g aW50ZXJsb2NrCmFnYWluc3QgdW5zYWZlIGNvbmN1cnJlbnQgVElEIHJlY3ljbGluZyBieSBWQUNV VU0gKGVzc2VudGlhbGx5IHRoZSBzYW1lCndheSB0aGF0IGFtZ2V0Yml0bWFwIHJvdXRpbmVzIGhh dmUgYWx3YXlzIGF2b2lkZWQgaG9sZGluZyBvbnRvIHBpbnMpLgpUaGUgd29yayBmcm9tIHRoaXMg Y29tbWl0IG1ha2VzIHRoYXQgcG9zc2libGUgZHVyaW5nIHNjYW5zIG9mIG5idHJlZQp1bmxvZ2dl ZCBpbmRleGVzIC0tIHdpdGhvdXQgb3VyIGhhdmluZyB0byBnaXZlIHVwIG9uIHNldHRpbmcgTFBf REVBRApiaXRzIG9uIGluZGV4IHR1cGxlcyBhbHRvZ2V0aGVyLgoKRm9sbG93LXVwIHRvIGNvbW1p dCBkNzc0MDcyZiwgd2hpY2ggbW92ZWQgdGhlIGZha2UgTFNOIGluZnJhc3RydWN0dXJlCm91dCBv ZiBHaVNUIHNvIHRoYXQgaXQgY291bGQgYmUgdXNlZCBieSBvdGhlciBpbmRleCBBTXMuCgpBdXRo b3I6IFBldGVyIEdlb2doZWdhbiA8cGdAYm93dC5pZT4KUmV2aWV3ZWQtQnk6IEFuZHJlcyBGcmV1 bmQgPGFuZHJlc0BhbmFyYXplbC5kZT4KUmV2aWV3ZWQtQnk6IFRvbWFzIFZvbmRyYSA8dG9tYXNA dm9uZHJhLm1lPgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tL0NBSDItV3prZWh1aHh5 dUE4cXVjN3JSTjNFdE5YcGlLc2pQZk84bWhiKzBEcjJLMER0Z0BtYWlsLmdtYWlsLmNvbQoKQnJh bmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3Fs Lm9yZy9wZy9jb21taXRkaWZmLzhhODc5MTE5YTFkMTJmZjBhNDEwZmUzYjY0YWQxNTA2OWMzYTM3 N2MKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2FjY2Vzcy9uYnRy ZWUvUkVBRE1FICAgICAgfCAgNSArLS0Kc3JjL2JhY2tlbmQvYWNjZXNzL25idHJlZS9uYnRkZWR1 cC5jICB8ICA4ICsrLS0Kc3JjL2JhY2tlbmQvYWNjZXNzL25idHJlZS9uYnRpbnNlcnQuYyB8IDQ2 ICsrKysrKysrKysrLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2FjY2Vzcy9uYnRyZWUvbmJ0cGFnZS5j ICAgfCA4MiArKysrKysrKysrKysrKysrKysrKy0tLS0tLS0tLS0tLS0tLQpzcmMvYmFja2VuZC9h Y2Nlc3MvbmJ0cmVlL25idHJlZS5jICAgIHwgIDggLS0tLQpzcmMvYmFja2VuZC9hY2Nlc3MvbmJ0 cmVlL25idHNlYXJjaC5jIHwgIDEgLQpzcmMvYmFja2VuZC9hY2Nlc3MvbmJ0cmVlL25idHV0aWxz LmMgIHwgIDEgLQo3IGZpbGVzIGNoYW5nZWQsIDc5IGluc2VydGlvbnMoKyksIDcyIGRlbGV0aW9u cygtKQoK --===============6548493460594078237==--