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 1qO9rR-006ynp-8P for pgsql-committers@arkaria.postgresql.org; Tue, 25 Jul 2023 04:41:25 +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 1qO9rP-00EWuw-De for pgsql-committers@arkaria.postgresql.org; Tue, 25 Jul 2023 04:41:23 +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 1qO9rP-00EWuo-6Y for pgsql-committers@lists.postgresql.org; Tue, 25 Jul 2023 04:41:23 +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 1qO9rH-001QxB-IZ for pgsql-committers@lists.postgresql.org; Tue, 25 Jul 2023 04:41:21 +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 1qO9rG-00019G-OV for pgsql-committers@lists.postgresql.org; Tue, 25 Jul 2023 04:41:14 +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 1qO9rE-001DfX-RE for pgsql-committers@lists.postgresql.org; Tue, 25 Jul 2023 04:41:13 +0000 Content-Type: multipart/mixed; boundary="===============1449734247158057417==" MIME-Version: 1.0 From: Michael Paquier To: pgsql-committers@lists.postgresql.org Subject: pgsql: Optimize WAL insertion lock acquisition and release with some at X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Tue, 25 Jul 2023 04:41:13 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1449734247158057417== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 T3B0aW1pemUgV0FMIGluc2VydGlvbiBsb2NrIGFjcXVpc2l0aW9uIGFuZCByZWxlYXNlIHdpdGgg c29tZSBhdG9taWNzCgpUaGUgV0FMIGluc2VydGlvbiBsb2NrIHZhcmlhYmxlIGluc2VydGluZ0F0 IGlzIGN1cnJlbnRseSBiZWluZyByZWFkCmFuZCB3cml0dGVuIHdpdGggdGhlIGhlbHAgb2YgdGhl IExXTG9jayB3YWl0IGxpc3QgbG9jayB0byBhdm9pZCBhbnkgcmVhZApvZiB0b3JuIHZhbHVlcy4g IFRoaXMgd2FpdCBsaXN0IGxvY2sgY2FuIGJlY29tZSBhIHBvaW50IG9mIGNvbnRlbnRpb24gb24K YSBoaWdobHkgY29uY3VycmVudCB3cml0ZSB3b3JrbG9hZHMuCgpUaGlzIGNvbW1pdCBzd2l0Y2hl cyBpbnNlcnRpbmdBdCB0byBhIDY0YiBhdG9taWMgdmFyaWFibGUgdGhhdCBwcm92aWRlcwp0b3Ju LWZyZWUgcmVhZHMvd3JpdGVzLiAgT24gcGxhdGZvcm1zIHdpdGhvdXQgNjRiIGF0b21pYyBzdXBw b3J0LCB0aGUKZmFsbGJhY2sgaW1wbGVtZW50YXRpb24gdXNlcyBzcGlubG9ja3MgdG8gcHJvdmlk ZSB0aGUgc2FtZSBndWFyYW50ZWVzCmZvciB0aGUgdmFsdWVzIHJlYWQuICBMV0xvY2tXYWl0Rm9y VmFyKCksIHRocm91Z2gKTFdMb2NrQ29uZmxpY3RzV2l0aFZhcigpLCByZWFkcyB0aGUgbmV3IHZh bHVlIHRvIGNoZWNrIGlmIGl0IHN0aWxsIG5lZWRzCnRvIHdhaXQgd2l0aCBhIHU2NCBhdG9taWMg b3BlcmF0aW9uLiAgTFdMb2NrVXBkYXRlVmFyKCkgdXBkYXRlcyB0aGUKdmFyaWFibGUgYmVmb3Jl IHdha2luZyB1cCB0aGUgd2FpdGVycyB3aXRoIGFuIGV4Y2hhbmdlX3U2NCAoZnVsbCBtZW1vcnkK YmFycmllcikuICBMV0xvY2tSZWxlYXNlQ2xlYXJWYXIoKSBub3cgdXNlcyBhbHNvIGFuIGV4Y2hh bmdlX3U2NCB0bwpyZXNldCB0aGUgdmFyaWFibGUuICBCZWZvcmUgdGhpcyBjb21taXQsIGFsbCB0 aGVzZSBzdGVwcyByZWxpZWQgb24KTFdMb2NrV2FpdExpc3RMb2NrKCkgYW5kIExXTG9ja1dhaXRM aXN0VW5sb2NrKCkuCgpUaGlzIHJlZHVjZXMgY29udGVudGlvbiBvbiBMV0xvY2sgd2FpdCBsaXN0 IGxvY2sgYW5kIGltcHJvdmVzCnBlcmZvcm1hbmNlIG9mIGhpZ2hseS1jb25jdXJyZW50IHdyaXRl IHdvcmtsb2Fkcy4gIEhlcmUgYXJlIHNvbWUKbnVtYmVycyB1c2luZyBwZ19sb2dpY2FsX2VtaXRf bWVzc2FnZSgpIChIRUFEIGF0IGQ2Njc3YjkzKSB3aXRoIHZhcmlvdXMKYXJiaXRyYXJ5IHJlY29y ZCBsZW5ndGhzIGFuZCBjbGllbnRzIHVwIHRvIDFrIG9uIGEgcmF0aGVyLWxhcmdlIG1hY2hpbmUK KDY0IHZDUFVzLCA1MTJHQiBvZiBSQU0sIDE2IGNvcmVzIHBlciBzb2NrZXRzLCAyIHNvY2tldHMp LCBpbiB0ZXJtcyBvZgpUUFMgbnVtYmVycyBjb21pbmcgZnJvbSBwZ2JlbmNoOgogbWVzc2FnZV9z aXplX2IgICAgIHwgICAgIDE2IHwgICAgIDY0IHwgICAgMjU2IHwgICAxMDI0Ci0tLS0tLS0tLS0t LS0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0tKy0tLS0tLS0KIHBhdGNoXzRfY2xp ZW50cyAgICB8ICA4MzgzMCB8ICA4MjkyOSB8ICA4MDQ3OCB8ICA3MzEzMQogcGF0Y2hfMTZfY2xp ZW50cyAgIHwgMjY3NjU1IHwgMjY0OTczIHwgMjUwNTY2IHwgMjEzOTg1CiBwYXRjaF82NF9jbGll bnRzICAgfCAzODA0MjMgfCAzNzgzMTggfCAzNTY5MDcgfCAyOTQyNDgKIHBhdGNoXzI1Nl9jbGll bnRzICB8IDM2MDkxNSB8IDM1NDQzNiB8IDMyNjIwOSB8IDI2MzY2NAogcGF0Y2hfNTEyX2NsaWVu dHMgIHwgMzMyNjU0IHwgMzIxMTk5IHwgMjg3NTIxIHwgMjQwMTI4CiBwYXRjaF8xMDI0X2NsaWVu dHMgfCAyODgyNjMgfCAyNzY2MTQgfCAyNTgyMjAgfCAyMTcwNjMKIHBhdGNoXzIwNDhfY2xpZW50 cyB8IDI1MjI4MCB8IDI0MzU1OCB8IDIzMDA2MiB8IDE5MjQyOQogcGF0Y2hfNDA5Nl9jbGllbnRz IHwgMjEyNTY2IHwgMjEzNjU0IHwgMjA1OTUxIHwgMTY2OTU1CiBoZWFkXzRfY2xpZW50cyAgICAg fCAgODM2ODYgfCAgODM3NjYgfCAgODEyMzMgfCAgNzM3NDkKIGhlYWRfMTZfY2xpZW50cyAgICB8 IDI2NjUwMyB8IDI2NTU0NiB8IDI0OTI2MSB8IDIxMzY0NQogaGVhZF82NF9jbGllbnRzICAgIHwg MzY2MTIyIHwgMzYzNDYyIHwgMzQxMDc4IHwgMjYxNzA3CiBoZWFkXzI1Nl9jbGllbnRzICAgfCAx MzI2MDAgfCAxMzI1NzMgfCAxMzQzOTIgfCAxNjU3OTkKIGhlYWRfNTEyX2NsaWVudHMgICB8IDEx ODkzNyB8IDExNDMzMiB8IDExNjg2MCB8IDE1MDY3MgogaGVhZF8xMDI0X2NsaWVudHMgIHwgMTMz NTQ2IHwgMTE1MjU2IHwgMTI1MjM2IHwgMTUxMzkwCiBoZWFkXzIwNDhfY2xpZW50cyAgfCAxMzc4 NzcgfCAxMTc4MDIgfCAxMjA5MDkgfCAxMzgxNjUKIGhlYWRfNDA5Nl9jbGllbnRzICB8IDExMzQ0 MCB8IDExNTYxMSB8IDEyMDYzNSB8IDExNDM2MQoKQmhhcmF0aCBoYXMgYmVlbiBtZWFzdXJpbmcg c2ltaWxhciBpbXByb3ZlbWVudHMsIHdoZXJlIHRoZSBsaW1pdCBvZiB0aGUKV0FMIGluc2VydGlv biBsb2NrIGJlZ2lucyB0byBiZSBmZWx0IHdoZW4gbW9yZSB0aGFuIDI1NiBjb25jdXJyZW50CmNs aWVudHMgYXJlIGludm9sdmVkIGluIHRoaXMgc3BlY2lmaWMgd29ya2xvYWQuCgpBbiBleHRyYSBw YXRjaCBoYXMgYmVlbiBkaXNjdXNzZWQgdG8gaW50cm9kdWNlIGEgZmFzdC1leGl0IHBhdGggaW4K TFdMb2NrVXBkYXRlVmFyKCkgd2hlbiB0aGVyZSBhcmUgbm8gd2FpdGVycywgc3RpbGwgdGhpcyBk b2VzIG5vdAppbmZsdWVuY2UgdGhlIHdyaXRlLWhlYXZ5IHdvcmtsb2FkIGNhc2VzIGRpc2N1c3Nl ZCBhcyB0aGVyZSBhcmUgYWx3YXlzCndhaXRlcnMuICBUaGlzIHdpbGwgYmUgY29uc2lkZXJlZCBz ZXBhcmF0ZWx5LgoKQXV0aG9yOiBCaGFyYXRoIFJ1cGlyZWRkeQpSZXZpZXdlZC1ieTogTmF0aGFu IEJvc3NhcnQsIEFuZHJlcyBGcmV1bmQsIE1pY2hhZWwgUGFxdWllcgpEaXNjdXNzaW9uOiBodHRw czovL3Bvc3Rnci5lcy9tL0NBTGoyQUNWRis2akx2cUtlNnhoRHpDQ2tyPXJmZDZ1cGFHYzM0NzdQ amkxS2U5RzdCZ0BtYWlsLmdtYWlsLmNvbQoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFpbHMK LS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmLzcxZTRjYzZi OGVjNmEwOGY4MTk3M2JkMzg3ZmU1NzUxMzRjZDBiZGYKCk1vZGlmaWVkIEZpbGVzCi0tLS0tLS0t LS0tLS0tCnNyYy9iYWNrZW5kL2FjY2Vzcy90cmFuc2FtL3hsb2cuYyB8ICA0ICsrLS0Kc3JjL2Jh Y2tlbmQvc3RvcmFnZS9sbWdyL2x3bG9jay5jIHwgNDYgKysrKysrKysrKysrKysrKysrLS0tLS0t LS0tLS0tLS0tLS0tLS0tCnNyYy9pbmNsdWRlL3N0b3JhZ2UvbHdsb2NrLmggICAgICB8ICA2ICsr LS0tCjMgZmlsZXMgY2hhbmdlZCwgMjYgaW5zZXJ0aW9ucygrKSwgMzAgZGVsZXRpb25zKC0pCgo= --===============1449734247158057417==--