Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q0mFk-0003bc-E6 for pgsql-committers@arkaria.postgresql.org; Sun, 21 May 2023 16:49:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q0mFj-0006o8-CR for pgsql-committers@arkaria.postgresql.org; Sun, 21 May 2023 16:49:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q0mCj-0003YV-Es for pgsql-committers@lists.postgresql.org; Sun, 21 May 2023 16:46:45 +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.94.2) (envelope-from ) id 1q0mCb-001CDg-68 for pgsql-committers@lists.postgresql.org; Sun, 21 May 2023 16:46:44 +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 1q0mCa-0007Wm-85 for pgsql-committers@lists.postgresql.org; Sun, 21 May 2023 16:46:36 +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 1q0mCa-0012Wv-0e for pgsql-committers@lists.postgresql.org; Sun, 21 May 2023 16:46:35 +0000 Content-Type: multipart/mixed; boundary="===============0733609553880589348==" MIME-Version: 1.0 From: Andres Freund To: pgsql-committers@lists.postgresql.org Subject: pgsql: Optimize walsender wake up logic using condition variables X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Sun, 21 May 2023 16:46:35 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============0733609553880589348== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 T3B0aW1pemUgd2Fsc2VuZGVyIHdha2UgdXAgbG9naWMgdXNpbmcgY29uZGl0aW9uIHZhcmlhYmxl cwoKV2FsU25kV2FrZXVwKCkgY3VycmVudGx5IGxvb3BzIHRocm91Z2ggYWxsIHRoZSB3YWxzZW5k ZXJzIHNsb3RzLCB3aXRoIGEKc3BpbmxvY2sgYWNxdWlzaXRpb24gYW5kIHJlbGVhc2UgZm9yIGV2 ZXJ5IGl0ZXJhdGlvbiwgdG8gd2FrZSB1cCB3YWl0aW5nCndhbHNlbmRlcnMuCgpUaGlzIGNvbW1v bmx5IHdhcyBub3QgYSBwcm9ibGVtIGJlZm9yZSBlMTAxZGZhYzNhNTNjLiBCdXQsIHRvIGFsbG93 IGxvZ2ljYWwKZGVjb2Rpbmcgb24gc3RhbmRieXMsIHdlIG5lZWQgdG8gd2FrZSB1cCBsb2dpY2Fs IHdhbHNlbmRlcnMgYWZ0ZXIgZXZlcnkgV0FMCnJlY29yZCBpcyBhcHBsaWVkIG9uIHRoZSBzdGFu ZGJ5LCByYXRoZXIganVzdCB3aGVuIGZsdXNoaW5nIFdBTCBvciBzd2l0Y2hpbmcKdGltZWxpbmVz LiAgVGhpcyBjYXVzZXMgYSBwZXJmb3JtYW5jZSByZWdyZXNzaW9uIGZvciB3b3JrbG9hZHMgcmVw bGF5aW5nIGEgbG90Cm9mIFdBTCByZWNvcmRzLgoKVG8gc29sdmUgdGhpcywgd2UgdXNlIGNvbmRp dGlvbiB2YXJpYWJsZSAoQ1YpIHRvIGVmZmljaWVudGx5IHdha2UgdXAKd2Fsc2VuZGVycyBpbiBX YWxTbmRXYWtldXAoKS4KCkV2ZXJ5IHdhbHNlbmRlciBwcmVwYXJlcyB0byBzbGVlcCBvbiBhIHNo YXJlZCBtZW1vcnkgQ1YuIE5vdGUgdGhhdCBpdCBqdXN0CnByZXBhcmVzIHRvIHNsZWVwIG9uIHRo ZSBDViAoaS5lLiwgYWRkcyBpdHNlbGYgdG8gdGhlIENWJ3Mgd2FpdGxpc3QpLCBidXQgZG9lcwpu b3QgYWN0dWFsbHkgd2FpdCBvbiB0aGUgQ1YgKElPVywgaXQgbmV2ZXIgY2FsbHMgQ29uZGl0aW9u VmFyaWFibGVTbGVlcCgpKS4gSXQKc3RpbGwgdXNlcyBXYWl0RXZlbnRTZXRXYWl0KCkgZm9yIHdh aXRpbmcsIGJlY2F1c2UgQ1YgaW5mcmFzdHJ1Y3R1cmUgZG9lc24ndApoYW5kbGUgRmVCZSBzb2Nr ZXQgZXZlbnRzIGN1cnJlbnRseS4gVGhlIHByb2Nlc3NlcyAoc3RhcnR1cCBwcm9jZXNzLAp3YWxy ZWNlaXZlciBldGMuKSAgd2FudGluZyB0byB3YWtlIHVwIHdhbHNlbmRlcnMgdXNlCkNvbmRpdGlv blZhcmlhYmxlQnJvYWRjYXN0KCksIHdoaWNoIGluIHR1cm4gY2FsbHMgU2V0TGF0Y2goKSwgaGVs cGluZwp3YWxzZW5kZXJzIGNvbWUgb3V0IG9mIFdhaXRFdmVudFNldFdhaXQoKS4KCldlIHVzZSBz ZXBhcmF0ZSBzaGFyZWQgbWVtb3J5IENWcyBmb3IgcGh5c2ljYWwgYW5kIGxvZ2ljYWwgd2Fsc2Vu ZGVycyBmb3IKc2VsZWN0aXZlIHdha2UgdXBzLCBzZWUgV2FsU25kV2FrZXVwKCkgZm9yIG1vcmUg ZGV0YWlscy4KClRoaXMgYXBwcm9hY2ggaXMgc2ltcGxlIGFuZCByZWFzb25hYmx5IGVmZmljaWVu dC4gQnV0IG5vdCB2ZXJ5IGVsZWdhbnQuIEJ1dApmb3IgMTYgaXQgc2VlbXMgdG8gYmUgYSBiZXR0 ZXIgcGF0aCB0aGFuIGEgbGFyZ2VyIHJlZGVzaWduIG9mIHRoZSBDVgptZWNoYW5pc20uICBBIGRl c2lyYWJsZSBmdXR1cmUgaW1wcm92ZW1lbnQgd291bGQgYmUgdG8gYWRkIHN1cHBvcnQgZm9yIENW cwppbnRvIFdhaXRFdmVudFNldFdhaXQoKS4KClRoaXMgc3RpbGwgbGVhdmVzIHVzIHdpdGggYSBz bWFsbCByZWdyZXNzaW9uIGluIHZlcnkgZXh0cmVtZSB3b3JrbG9hZHMgKGR1ZSB0bwp0aGUgc3Bp bmxvY2sgYWNxdWlzaXRpb24gaW4gQ29uZGl0aW9uVmFyaWFibGVCcm9hZGNhc3QoKSB3aGVuIHRo ZXJlIGFyZSBubwp3YWl0ZXJzKSAtIGJ1dCB0aGF0IHNlZW1zIGFjY2VwdGFibGUuCgpSZXBvcnRl ZC1ieTogQW5kcmVzIEZyZXVuZCA8YW5kcmVzQGFuYXJhemVsLmRlPgpTdWdnZXN0ZWQtYnk6IEFu ZHJlcyBGcmV1bmQgPGFuZHJlc0BhbmFyYXplbC5kZT4KQXV0aG9yOiBCaGFyYXRoIFJ1cGlyZWRk eSA8YmhhcmF0aC5ydXBpcmVkZHlmb3Jwb3N0Z3Jlc0BnbWFpbC5jb20+ClJldmlld2VkLWJ5OiAi RHJvdXZvdCwgQmVydHJhbmQiIDxiZXJ0cmFuZGRyb3V2b3QucGdAZ21haWwuY29tPgpSZXZpZXdl ZC1ieTogWmhpamllIEhvdSA8aG91emouZm5zdEBmdWppdHN1LmNvbT4KRGlzY3Vzc2lvbjogaHR0 cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC8yMDIzMDUwOTE5MDI0Ny4zcnJwbGhk Z2VtNnN1NmNnJTQwYXdvcmszLmFuYXJhemVsLmRlCgpCcmFuY2gKLS0tLS0tCm1hc3RlcgoKRGV0 YWlscwotLS0tLS0tCmh0dHBzOi8vZ2l0LnBvc3RncmVzcWwub3JnL3BnL2NvbW1pdGRpZmYvYmM5 NzFmNDAyNWMzNzhjZTUwMGQ4NjU5N2MzNGIwZWY5OTZkNGQ4YwoKTW9kaWZpZWQgRmlsZXMKLS0t LS0tLS0tLS0tLS0Kc3JjL2JhY2tlbmQvcmVwbGljYXRpb24vd2Fsc2VuZGVyLmMgICAgICAgICB8 IDcyICsrKysrKysrKysrKysrKysrKystLS0tLS0tLS0tCnNyYy9pbmNsdWRlL3JlcGxpY2F0aW9u L3dhbHNlbmRlcl9wcml2YXRlLmggfCAgNSArKwoyIGZpbGVzIGNoYW5nZWQsIDUzIGluc2VydGlv bnMoKyksIDI0IGRlbGV0aW9ucygtKQoK --===============0733609553880589348==--