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 1w06c3-001cZZ-25 for pgsql-committers@arkaria.postgresql.org; Tue, 10 Mar 2026 23:35:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w06c0-006iO7-2X for pgsql-committers@arkaria.postgresql.org; Tue, 10 Mar 2026 23:35:41 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w06c0-006iNz-1r for pgsql-committers@lists.postgresql.org; Tue, 10 Mar 2026 23:35:41 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w06by-000000022t0-03n5 for pgsql-committers@lists.postgresql.org; Tue, 10 Mar 2026 23:35:40 +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 1w06bw-003dm1-2E for pgsql-committers@lists.postgresql.org; Tue, 10 Mar 2026 23:35:37 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w06bw-003New-1T for pgsql-committers@lists.postgresql.org; Tue, 10 Mar 2026 23:35:36 +0000 Content-Type: multipart/mixed; boundary="===============2907569379688855657==" MIME-Version: 1.0 From: Andres Freund To: pgsql-committers@lists.postgresql.org Subject: pgsql: Require share-exclusive lock to set hint bits and to flush X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 10 Mar 2026 23:35:36 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2907569379688855657== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVxdWlyZSBzaGFyZS1leGNsdXNpdmUgbG9jayB0byBzZXQgaGludCBiaXRzIGFuZCB0byBmbHVz aAoKQXQgdGhlIG1vbWVudCBoaW50IGJpdHMgY2FuIGJlIHNldCB3aXRoIGp1c3QgYSBzaGFyZSBs b2NrIG9uIGEgcGFnZSAoYW5kLAp1bnRpbCA0NWY2NThkYWNiOSwgaW4gb25lIGNhc2UgZXZlbiB3 aXRob3V0IGFueSBsb2NrKS4gQmVjYXVzZSBvZiB0aGlzIHdlIG5lZWQKdG8gY29weSBwYWdlcyB3 aGlsZSB3cml0aW5nIHRoZW0gb3V0LCBhcyBvdGhlcndpc2UgdGhlIGNoZWNrc3VtIGNvdWxkIGJl CmNvcnJ1cHRlZC4KClRoZSBuZWVkIHRvIGNvcHkgdGhlIHBhZ2UgaXMgcHJvYmxlbWF0aWMgdG8g aW1wbGVtZW50IEFJTyB3cml0ZXM6CgoxKSBJbnN0ZWFkIG9mIGp1c3QgbmVlZGluZyBhIHNpbmds ZSBidWZmZXIgZm9yIGEgY29waWVkIHBhZ2Ugd2UgbmVlZCBvbmUgZm9yCiAgIGVhY2ggcGFnZSB0 aGF0J3MgcG90ZW50aWFsbHkgdW5kZXJnb2luZyBJL08KMikgVG8gYmUgYWJsZSB0byB1c2UgdGhl ICJ3b3JrZXIiIEFJTyBpbXBsZW1lbnRhdGlvbiB0aGUgY29waWVkIHBhZ2UgbmVlZHMgdG8KICAg cmVzaWRlIGluIHNoYXJlZCBtZW1vcnkKCkl0IGFsc28gY2F1c2VzIHByb2JsZW1zIGZvciB1c2lu ZyB1bmJ1ZmZlcmVkL2RpcmVjdC1JTywgaW5kZXBlbmRlbnQgb2YgQUlPOgpTb21lIGZpbGVzeXN0 ZW1zLCByYWlkIGltcGxlbWVudGF0aW9ucywgLi4uIGRvIG5vdCB0b2xlcmF0ZSB0aGUgZGF0YSBi ZWluZwp3cml0dGVuIG91dCB0byBjaGFuZ2UgZHVyaW5nIHRoZSB3cml0ZS4gRS5nLiB0aGV5IG1h eSBjb21wdXRlIGludGVybmFsCmNoZWNrc3VtcyB0aGF0IGNhbiBiZSBpbnZhbGlkYXRlZCBieSBj b25jdXJyZW50IG1vZGlmaWNhdGlvbnMsIGxlYWRpbmcgZS5nLiB0bwpmaWxlc3lzdGVtIGVycm9y cyAoYXMgdGhlIGNhc2Ugd2l0aCBidHJmcykuCgpJdCBhbHNvIGp1c3QgaXMgcGxhaW4gb2RkIHRv IGFsbG93IG1vZGlmaWNhdGlvbnMgb2YgYnVmZmVycyB0aGF0IGFyZSBqdXN0CnNoYXJlIGxvY2tl ZC4KClRvIGFkZHJlc3MgdGhlc2UgaXNzdWVzLCB0aGlzIGNvbW1pdCBjaGFuZ2VzIHRoZSBydWxl cyBzbyB0aGF0IG1vZGlmaWNhdGlvbnMKdG8gcGFnZXMgYXJlIG5vdCBhbGxvd2VkIGFueW1vcmUg d2hpbGUgaG9sZGluZyBhIHNoYXJlIGxvY2suIEluc3RlYWQgdGhlIG5ldwpzaGFyZS1leGNsdXNp dmUgbG9jayAoaW50cm9kdWNlZCBpbiBmY2I5Yzk3N2FhNSkgYWxsb3dzIGF0IG1vc3Qgb25lIGJh Y2tlbmQgdG8KbW9kaWZ5IGEgYnVmZmVyIHdoaWxlIG90aGVyIGJhY2tlbmRzIGhhdmUgdGhlIHNh bWUgcGFnZSBzaGFyZSBsb2NrZWQuIEFuCmV4aXN0aW5nIHNoYXJlLWxvY2sgY2FuIGJlIHVwZ3Jh ZGVkIHRvIGEgc2hhcmUtZXhjbHVzaXZlIGxvY2ssIGlmIHRoZXJlIGFyZSBubwpjb25mbGljdGlu ZyBsb2Nrcy4gRm9yIHRoYXQgQnVmZmVyQmVnaW5TZXRIaW50Qml0cygpL0J1ZmZlckZpbmlzaFNl dEhpbnRCaXRzKCkKYW5kIEJ1ZmZlclNldEhpbnRCaXRzMTYoKSBoYXZlIGJlZW4gaW50cm9kdWNl ZC4KClRvIHByZXZlbnQgaGludCBiaXRzIGZyb20gYmVpbmcgc2V0IHdoaWxlIHRoZSBidWZmZXIg aXMgYmVpbmcgd3JpdHRlbiBvdXQsCndyaXRpbmcgb3V0IGJ1ZmZlcnMgbm93IHJlcXVpcmVzIGEg c2hhcmUtZXhjbHVzaXZlIGxvY2suCgpUaGUgdXNlIG9mIHNoYXJlLWV4Y2x1c2l2ZSB0byBnYXRl IHNldHRpbmcgaGludCBiaXRzIG1lYW5zIHRoYXQgZnJvbSBub3cgb24Kb25seSBvbmUgYmFja2Vu ZCBjYW4gc2V0IGhpbnQgYml0cyBhdCBhIHRpbWUuIFRvIGFsbG93IG11bHRpcGxlIGJhY2tlbmRz IHRvCnNldCBoaW50IGJpdHMgd291bGQgcmVxdWlyZSBtb3JlIGNvbXBsaWNhdGVkIGxvY2tpbmc6 IEZvciBzZXR0aW5nIGhpbnQgYml0cwp3ZSdkIG5lZWQgdG8gc3RvcmUgdGhlIGNvdW50IG9mIGJh Y2tlbmRzIGN1cnJlbnRseSBzZXR0aW5nIGhpbnQgYml0cyBhbmQgd2UKd291bGQgbmVlZCBhbm90 aGVyIGxvY2stbGV2ZWwgZm9yIEkvTyBjb25mbGljdGluZyB3aXRoIHRoZSBsb2NrLWxldmVsIHRv IHNldApoaW50IGJpdHMuIEdpdmVuIHRoYXQgdGhlIHNoYXJlLWV4Y2x1c2l2ZSBsb2NrIGZvciBz ZXR0aW5nIGhpbnQgYml0cyBpcyBvbmx5CmhlbGQgZm9yIGEgc2hvcnQgdGltZSwgdGhhdCBiYWNr ZW5kcyB3b3VsZCBvZnRlbiBqdXN0IHNldCB0aGUgc2FtZSBoaW50IGJpdHMKYW5kIHRoYXQgdGhl IGNvc3Qgb2Ygb2NjYXNpb25hbGx5IG5vdCBzZXR0aW5nIGhpbnQgYml0cyBpbiBob3RseSBhY2Nl c3NlZApwYWdlcyBpcyBmYWlybHkgbG93LCB0aGlzIHNlZW1zIGxpa2UgYW4gYWNjZXB0YWJsZSB0 cmFkZW9mZi4KClRoZSBiaWdnZXN0IGNoYW5nZSB0byBhZGFwdCB0byB0aGlzIGlzIGluIGhlYXBh bS4gVG8gYXZvaWQgcGVyZm9ybWFuY2UKcmVncmVzc2lvbnMgZm9yIHNlcXVlbnRpYWwgc2NhbnMg dGhhdCBuZWVkIHRvIHNldCBhIGxvdCBvZiBoaW50IGJpdHMsIHdlIG5lZWQKdG8gYW1vcnRpemUg dGhlIGNvc3Qgb2YgQnVmZmVyQmVnaW5TZXRIaW50Qml0cygpIGZvciBjYXNlcyB3aGVyZSBoaW50 IGJpdHMgYXJlCnNldCBhdCBhIGhpZ2ggZnJlcXVlbmN5LiBUbyB0aGF0IGVuZCBIZWFwVHVwbGVT YXRpc2ZpZXNNVkNDQmF0Y2goKSB1c2VzIHRoZQpuZXcgU2V0SGludEJpdHNFeHQoKSwgd2hpY2gg ZGVmZXJzIEJ1ZmZlckZpbmlzaFNldEhpbnRCaXRzKCkgdW50aWwgYWxsIGhpbnQKYml0cyBvbiBh IHBhZ2UgaGF2ZSBiZWVuIHNldC4gIENvbnZlcnNlbHksIHRvIGF2b2lkIHJlZ3Jlc3Npb25zIGlu IGNhc2VzIHdoZXJlCndlIGNhbid0IHNldCBoaW50IGJpdHMgaW4gYnVsayAoYmVjYXVzZSB3ZSdy ZSBsb29raW5nIG9ubHkgYXQgaW5kaXZpZHVhbAp0dXBsZXMpLCB1c2UgQnVmZmVyU2V0SGludEJp dHMxNigpIHdoZW4gc2V0dGluZyBoaW50IGJpdHMgd2l0aG91dCBiYXRjaGluZy4KClNldmVyYWwg b3RoZXIgcGxhY2VzIGFsc28gbmVlZCB0byBiZSBhZGFwdGVkLCBidXQgdGhvc2UgY2hhbmdlcyBh cmUKY29tcGFyYXRpdmVseSBzaW1wbGVyLgoKQWZ0ZXIgdGhpcyB3ZSBkbyBub3QgbmVlZCB0byBj b3B5IGJ1ZmZlcnMgdG8gd3JpdGUgdGhlbSBvdXQgYW55bW9yZS4gVGhhdApjaGFuZ2UgaXMgZG9u ZSBzZXBhcmF0ZWx5IGhvd2V2ZXIuCgpSZXZpZXdlZC1ieTogTWVsYW5pZSBQbGFnZW1hbiA8bWVs YW5pZXBsYWdlbWFuQGdtYWlsLmNvbT4KUmV2aWV3ZWQtYnk6IEhlaWtraSBMaW5uYWthbmdhcyA8 aGxpbm5ha2FAaWtpLmZpPgpSZXZpZXdlZC1ieTogQ2hhbyBMaSA8bGkuZXZhbi5jaGFvQGdtYWls LmNvbT4KRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS9mdmZta3I1a2s0bnlleDU2ZWpn eGozdXppNjNpc2Z4b3ZwMmJpZWNiNGJzcGJqcnplN0BhejJwbGphYmhuZmYKRGlzY3Vzc2lvbjog aHR0cHM6Ly9wb3N0Z3IuZXMvbS9zdGozNmVhNnl5aG94dHFraHBpZWlhMno0a3JuYW03cXlldGM1 N3JmZXpnazR6Z2FwZiU0MGdjbmFjdGo0ejU2bQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFp bHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzgyNDY3 ZjYyN2JkNDc4NTY5ZGUwNGY0YTNmMTk5MzA5OGU4MGM4MTIKCk1vZGlmaWVkIEZpbGVzCi0tLS0t LS0tLS0tLS0tCnNyYy9iYWNrZW5kL2FjY2Vzcy9naXN0L2dpc3RnZXQuYyAgICAgICAgICAgfCAg MjAgKy0Kc3JjL2JhY2tlbmQvYWNjZXNzL2hhc2gvaGFzaHV0aWwuYyAgICAgICAgICB8ICAxNCAr LQpzcmMvYmFja2VuZC9hY2Nlc3MvaGVhcC9oZWFwYW1fdmlzaWJpbGl0eS5jIHwgMTMwICsrKysr KystLQpzcmMvYmFja2VuZC9hY2Nlc3MvbmJ0cmVlL25idGluc2VydC5jICAgICAgIHwgIDMxICsr LQpzcmMvYmFja2VuZC9hY2Nlc3MvbmJ0cmVlL25idHV0aWxzLmMgICAgICAgIHwgIDE0ICstCnNy Yy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL3hsb2dpbnNlcnQuYyAgICAgfCAgMTEgKy0Kc3JjL2Jh Y2tlbmQvc3RvcmFnZS9idWZmZXIvUkVBRE1FICAgICAgICAgICB8ICA2NiArKystLQpzcmMvYmFj a2VuZC9zdG9yYWdlL2J1ZmZlci9idWZtZ3IuYyAgICAgICAgIHwgMzk2ICsrKysrKysrKysrKysr KysrKysrKy0tLS0tLS0Kc3JjL2JhY2tlbmQvc3RvcmFnZS9mcmVlc3BhY2UvZnJlZXNwYWNlLmMg ICB8ICAxNCArLQpzcmMvYmFja2VuZC9zdG9yYWdlL2ZyZWVzcGFjZS9mc21wYWdlLmMgICAgIHwg IDExICstCnNyYy9pbmNsdWRlL3N0b3JhZ2UvYnVmbWdyLmggICAgICAgICAgICAgICAgfCAgIDQg KwpzcmMvdG9vbHMvcGdpbmRlbnQvdHlwZWRlZnMubGlzdCAgICAgICAgICAgIHwgICAxICsKMTIg ZmlsZXMgY2hhbmdlZCwgNTI4IGluc2VydGlvbnMoKyksIDE4NCBkZWxldGlvbnMoLSkKCg== --===============2907569379688855657==--