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.94.2) (envelope-from ) id 1sdETd-00E1Kq-Pc for pgsql-committers@arkaria.postgresql.org; Sun, 11 Aug 2024 19:43:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sdETc-00CVhC-CQ for pgsql-committers@arkaria.postgresql.org; Sun, 11 Aug 2024 19:43:40 +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.94.2) (envelope-from ) id 1sdETc-00CVh4-4Y for pgsql-committers@lists.postgresql.org; Sun, 11 Aug 2024 19:43:40 +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.94.2) (envelope-from ) id 1sdETU-004Ear-Rz for pgsql-committers@lists.postgresql.org; Sun, 11 Aug 2024 19:43:38 +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.94.2) (envelope-from ) id 1sdETT-00DFPW-Px for pgsql-committers@lists.postgresql.org; Sun, 11 Aug 2024 19:43:31 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sdETS-003kcT-Pv for pgsql-committers@lists.postgresql.org; Sun, 11 Aug 2024 19:43:30 +0000 Content-Type: multipart/mixed; boundary="===============7855253848851189073==" MIME-Version: 1.0 From: Peter Geoghegan To: pgsql-committers@lists.postgresql.org Subject: pgsql: Avoid unneeded nbtree backwards scan buffer locks. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sun, 11 Aug 2024 19:43:30 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7855253848851189073== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QXZvaWQgdW5uZWVkZWQgbmJ0cmVlIGJhY2t3YXJkcyBzY2FuIGJ1ZmZlciBsb2Nrcy4KClRlYWNo IG5idHJlZSBiYWNrd2FyZHMgc2NhbnMgdG8gYXZvaWQgcmVsb2NraW5nIGEganVzdC1yZWFkIGxl YWYgcGFnZSB0bwpyZWFkIGl0cyBjdXJyZW50IGxlZnQgc2libGluZyBsaW5rIHdoZW4gaXQgaXNu J3QgdHJ1bHkgbmVjZXNzYXJ5LiAgVGhpcwpoYXBwZW5lZCBpbnNpZGUgX2J0X3JlYWRuZXh0cGFn ZSB3aGVuZXZlciBfYnRfcmVhZHBhZ2UgaGFkIGFscmVhZHkKZGV0ZXJtaW5lZCB0aGF0IHRoZXJl J2xsIGJlIG5vIGZ1cnRoZXIgbWF0Y2hlcyB0byB0aGUgbGVmdCAob3IgYXQgbGVhc3QKbm9uZSBm b3IgdGhlIGN1cnJlbnQgcHJpbWl0aXZlIGluZGV4IHNjYW4sIGZvciBhIHNjYW4gd2l0aCBhcnJh eSBrZXlzKS4KCkEgbmV3IHByZWNoZWNrIGluc2lkZSBfYnRfcmVhZG5leHRwYWdlIGlzIGFsbCB0 aGF0IHdlIG5lZWQgdG8gYXZvaWQKdGhlc2UgdXNlbGVzcyBsb2NrIGFjcXVpc2l0aW9ucy4gIEFy Z3VhYmx5LCB1c2luZyBhIHByZWNoZWNrIGxpa2UgdGhpcwp3YXMgYSBtaXNzZWQgb3Bwb3J0dW5p dHkgZm9yIGNvbW1pdCAyZWQ1Yjg3Zjk2LCB3aGljaCB0YXVnaHQgbmJ0cmVlIHRvCmRyb3AgbGVh ZiBwYWdlIHBpbnMgZWFybHkgdG8gYXZvaWQgYmxvY2tpbmcgY2xlYW51cCBieSBWQUNVVU0uICBG b3J3YXJkcwpzY2FucyBhbHJlYWR5IG1hbmFnZWQgdG8gYXZvaWQgcmVsb2NraW5nIHRoZSBwYWdl IGxpa2UgdGhpcy4KClRoZSBvcHRpbWl6YXRpb24gYWRkZWQgYnkgdGhpcyBjb21taXQgaXMgcGFy dGljdWxhcmx5IGhlbHBmdWwgd2l0aApiYWNrd2FyZHMgc2NhbnMgdGhhdCB1c2UgYXJyYXkga2V5 cyB3aGVyZSB0aGUgc2NhbiBtdXN0IHBlcmZvcm0gbXVsdGlwbGUKcHJpbWl0aXZlIGluZGV4IHNj YW5zLiAgU3VjaCBiYWNrd2FyZHMgc2NhbnMgd2lsbCBub3cgYXZvaWQgYSB1c2VsZXNzCmxlYWYg cGFnZSByZS1sb2NrIGF0IHRoZSBlbmQgb2YgZWFjaCBwcmltaXRpdmUgaW5kZXggc2Nhbi4KCk5v dGUgdGhhdCB0aGlzIGNvbW1pdCBkb2VzIG5vdCBhdHRlbXB0IHRvIGF2b2lkIG5lZWRsZXNzbHkg cmUtbG9ja2luZyBhCmxlYWYgcGFnZSB0aGF0IHdhcyBqdXN0IHJlYWQgd2hlbiB0aGUgc2NhbiBt dXN0IGZvbGxvdyB0aGUgbGVhZiBwYWdlJ3MKbGVmdCBsaW5rLiAgVGhhdCBtb3JlIGFtYml0aW91 cyBvcHRpbWl6YXRpb24gY291bGQgd29yayBieSBzdGFzaGluZyB0aGUKbGVmdCBsaW5rIHdoZW4g dGhlIHBhZ2UgaXMgZmlyc3QgcmVhZCBieSBhIGJhY2t3YXJkcyBzY2FuLCBhbGxvd2luZyB0aGUK c3Vic2VxdWVudCBfYnRfcmVhZG5leHRwYWdlIGNhbGwgdG8gb3B0aW1pc3RpY2FsbHkgc2tpcCBy ZS1yZWFkaW5nIHRoZQpvcmlnaW5hbCBwYWdlIGp1c3QgdG8gZ2V0IGEgbmV3IGNvcHkgb2YgaXRz IGxlZnQgbGluay4gIEZvciBub3cgd2Ugb25seQphZGRyZXNzIGNhc2VzIHdoZXJlIHdlIGRvbid0 IGNhcmUgYWJvdXQgb3VyIG9yaWdpbmFsIHBhZ2UncyBsZWZ0IGxpbmsuCgpBdXRob3I6IFBldGVy IEdlb2doZWdhbiA8cGdAYm93dC5pZT4KUmV2aWV3ZWQtQnk6IE1hdHRoaWFzIHZhbiBkZSBNZWVu dCA8Ym9la2V3dXJtK3Bvc3RncmVzQGdtYWlsLmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0 Z3IuZXMvbS9DQUgyLVd6PXhnczdQb2pHPUVVdmhnYWR3RU56dV9tWV9yaU5oLXc5d0ZQc2FTNzE3 ZXdAbWFpbC5nbWFpbC5jb20KCkJyYW5jaAotLS0tLS0KbWFzdGVyCgpEZXRhaWxzCi0tLS0tLS0K aHR0cHM6Ly9naXQucG9zdGdyZXNxbC5vcmcvcGcvY29tbWl0ZGlmZi8zZjQ0OTU5ZjQ3NDYwZmIz NTBkMjVkNzYwY2YyMzg0ZjlhYTE0ZTlhCgpNb2RpZmllZCBGaWxlcwotLS0tLS0tLS0tLS0tLQpz cmMvYmFja2VuZC9hY2Nlc3MvbmJ0cmVlL25idHNlYXJjaC5jIHwgMjMgKysrKysrKysrKysrKysr KysrLS0tLS0KMSBmaWxlIGNoYW5nZWQsIDE4IGluc2VydGlvbnMoKyksIDUgZGVsZXRpb25zKC0p Cgo= --===============7855253848851189073==--