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 1r7dvO-00670R-65 for pgsql-committers@arkaria.postgresql.org; Mon, 27 Nov 2023 15:53:30 +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 1r7dvM-00Egpi-RY for pgsql-committers@arkaria.postgresql.org; Mon, 27 Nov 2023 15:53:28 +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.94.2) (envelope-from ) id 1r7duV-00EfrX-PY for pgsql-committers@lists.postgresql.org; Mon, 27 Nov 2023 15:52:35 +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 1r7duT-008oaj-4n for pgsql-committers@lists.postgresql.org; Mon, 27 Nov 2023 15:52:35 +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 1r7duR-009jsx-3D for pgsql-committers@lists.postgresql.org; Mon, 27 Nov 2023 15:52: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 1r7duP-007WNv-5r for pgsql-committers@lists.postgresql.org; Mon, 27 Nov 2023 15:52:29 +0000 Content-Type: multipart/mixed; boundary="===============1423667658433791788==" MIME-Version: 1.0 From: Heikki Linnakangas To: pgsql-committers@lists.postgresql.org Subject: pgsql: Reduce rate of walwriter wakeups due to async commits. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 27 Nov 2023 15:52:29 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1423667658433791788== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 UmVkdWNlIHJhdGUgb2Ygd2Fsd3JpdGVyIHdha2V1cHMgZHVlIHRvIGFzeW5jIGNvbW1pdHMuCgpY TG9nU2V0QXN5bmNYYWN0TFNOKCksIGNhbGxlZCBhdCBhc3luY2hyb25vdXMgY29tbWl0LCB3b3Vs ZCB3YWtlIHVwCndhbHdyaXRlciBldmVyeSB0aW1lIHRoZSBMU04gYWR2YW5jZXMsIGJ1dCB3YWx3 cml0ZXIgZG9lc24ndCBhY3R1YWxseQpkbyBhbnl0aGluZyB1bmxlc3MgaXQgaGFzIGF0IGxlYXN0 ICd3YWxfd3JpdGVyX2ZsdXNoX2FmdGVyJyBmdWxsCmJsb2NrcyBvZiBXQUwgdG8gd3JpdGUuIFJl cGVhdGVkbHkgd2FraW5nIHVwIHdhbHdyaXRlciB0byBkbyBub3RoaW5nCmlzIGEgd2FzdGUgb2Yg Q1BVIGN5Y2xlcyBpbiBib3RoIHdhbHdyaXRlciBhbmQgdGhlIGJhY2tlbmRzIGRvaW5nIHRoZQp3 YWtldXBzLiBUbyBmaXgsIGFwcGx5IHRoZSBzYW1lIGxvZ2ljIGluIFhMb2dTZXRBc3luY1hhY3RM U04oKSB0bwpkZWNpZGUgd2hldGhlciB0byB3YWtlIHVwIHdhbHdyaXRlciwgYXMgd2Fsd3JpdGVy IHVzZXMgdG8gZGV0ZXJtaW5lIGlmCml0IGhhcyBhbnkgd29yayB0byBkby4KCkluIHRoZSBwYXNz aW5nLCByZW5hbWUgbWlzbGVhZGluZ2x5IG5hbWVkICdmbHVzaGJ5dGVzJyBsb2NhbCB2YXJpYWJs ZQp0byAnZmx1c2hibG9ja3MnLgoKQXV0aG9yOiBBbmRyZXMgRnJldW5kLCBIZWlra2kgTGlubmFr YW5nYXMKRGlzY3Vzc2lvbjogaHR0cHM6Ly93d3cucG9zdGdyZXNxbC5vcmcvbWVzc2FnZS1pZC8y MDIzMTAyNDIzMDkyOS52c2MzNDJiYXFzN2ttYnRlQGF3b3JrMy5hbmFyYXplbC5kZQoKQnJhbmNo Ci0tLS0tLQptYXN0ZXIKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9y Zy9wZy9jb21taXRkaWZmLzFmMzk1MzU0ZDg3NDJkNTdjMTY2MTA0ODc0MTE0YjZlMGQwMWUxMDQK Ck1vZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2FjY2Vzcy90cmFuc2Ft L3hsb2cuYyB8IDQ5ICsrKysrKysrKysrKysrKysrKysrKysrKystLS0tLS0tLS0tLS0tLQoxIGZp bGUgY2hhbmdlZCwgMzEgaW5zZXJ0aW9ucygrKSwgMTggZGVsZXRpb25zKC0pCgo= --===============1423667658433791788==--