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 1pwE5L-00021c-1p for pgsql-hackers@arkaria.postgresql.org; Tue, 09 May 2023 03:32:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pwE5J-0000Uu-G8 for pgsql-hackers@arkaria.postgresql.org; Tue, 09 May 2023 03:32:17 +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 1pwE5J-0000Ul-7C for pgsql-hackers@lists.postgresql.org; Tue, 09 May 2023 03:32:17 +0000 Received: from out5-smtp.messagingengine.com ([66.111.4.29]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pwE5G-001UxE-LL for pgsql-hackers@lists.postgresql.org; Tue, 09 May 2023 03:32:16 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 972A25C00C4; Mon, 8 May 2023 23:32:12 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Mon, 08 May 2023 23:32:12 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm3; t=1683603132; x=1683689532; bh=dF AXBhoRo9kfHP1Tz3MYYavBOokcl1r0uAeMqHhXBvk=; b=x0iIIeo7yoCaVQvHHK Z/nfgcCbDjihPLgvwPWWDa9xxyxyeyMyrhUPpCKGRV14b+9tA6SsZf/WBT5EOt9e FMpC4gaMxkd7it+T3pzlpbIk0QByUUO54K3pKYbeRdZEGNqxLsiVxOGfTTMQ9uLY OyjYETSiL2FZKKxgB9ClMaOzkPORzM7PWYnz96dC9stXLIzEEosIFnw2I1sXv7eH 4ldYIfryr5QhAzBpe2JPZLCTfGNAldlgKMMPm9GnP+pTw9/kiEDY53lQDZWbWwMU 5afAa1+7YNM2D8BnnzJIickc6RVEt+ztDlQEX3pyWg+nIdYciMijRkVFJ+X3zu8f VZQQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm3; t=1683603132; x=1683689532; bh=dFAXBhoRo9kfH P1Tz3MYYavBOokcl1r0uAeMqHhXBvk=; b=f6b/Nxg0G3Yj0dT9T/i+QPghNLyaG 0iCWsIGWVV0+173m5L/QnEN1OltVKpJhzHppE7TIlA4FItuX8JVr6/zFrKxtX3NF XmuZ4EvRT3frOMlkH8Lf86dEwuvRgwfHpD40ujt+3SvM9hQnNjKmwbRK33250ExO wTBbzKhr35x6oKfsq2UAQ4nd6dq2YXwRfhuPiyrZcw1PIh8E7AJQ8kzJzTfkGlnX O2WtL3IVzv8eY2cV3uFfUjvqCBvwY03QyH2TEX+h3fcSM6s7HHcy89xiqDg2/+nd dEKnhdgOj+lUCVimW7ZVE6UIt41yO1mtaXfRPzZbhPgEiPiqNoo2F28AA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrfeefledgjeduucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeg geegfffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiih ii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 8 May 2023 23:32:10 -0400 (EDT) Date: Tue, 9 May 2023 12:32:07 +0900 From: Michael Paquier To: Nathan Bossart Cc: Bharath Rupireddy , Andres Freund , PostgreSQL Hackers Subject: Re: WAL Insertion Lock Improvements Message-ID: References: <20221203003158.GA2518778@nathanxps13> <20221205183007.s72oygp63s43dqyz@awork3.anarazel.de> <20230208220603.GA546776@nathanxps13> <20230221054948.GA2717@nathanxps13> <20230508230410.GA2423557@nathanxps13> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="NgUjIhqyxYc8+SgE" Content-Disposition: inline In-Reply-To: <20230508230410.GA2423557@nathanxps13> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --NgUjIhqyxYc8+SgE Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, May 08, 2023 at 04:04:10PM -0700, Nathan Bossart wrote: > On Mon, May 08, 2023 at 05:57:09PM +0530, Bharath Rupireddy wrote: >> test-case 1: -T5, WAL ~16 bytes >> test-case 1: -t1000, WAL ~16 bytes >=20 > I wonder if it's worth doing a couple of long-running tests, too. Yes, 5s or 1000 transactions per client is too small, though it shows that things are going in the right direction.=20 (Will reply to the rest in a bit..) -- Michael --NgUjIhqyxYc8+SgE Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmRZvrcACgkQnvQgOdby QH3xWBAAhflSzDoqRoFeEyNkCrXGjkLEcZwwSrrprTJWx9Ge0Y/cbPzq5X5pJGnb uJhCWnLhzmoc4DR73p/GbeX3a7PWBLjpseCo0cs4XwFwmCbYvdywYVKhoFKHRfJ/ VE2NZjtIEzyrAngtgCtHcKJHhBR2exvfm7AsWxGl1dNjsaqWL+mz60NNpOAx2XXQ /UuEdK+UMbgiLLGC2UwEquazAWHmSfYGse4eDtJNJpKBM7rQQK9InkGQEPjSzh8Z h5R318vPKsrDud46xVErJ4HBERxd62Py6tcMBcLAEt/s1vIWe9jHIXeWXJiOJYoD AQp1ydFsZ3HwEs9sry+0Y4s8MrAXufz58fPFNh5edbPbM4Y2ucyop4tAWKvCATg4 j2KEkmZYgSh/1PJ0yJfVltiDCyxjdzA4kuJeXRef5qtMZ0l14wgNvkGr1utuarH6 MQmwGfTlNO2DnX7YmD/JAzuXfOUFo0Qn8QmNFw8H9JX8R7m0JG3nFuhaDIY9HIWo G8/lYgmZBK35xiIgVjNyv0vosp3RrxErUFVHhFNOj597mMjNlsfeIlDHJjq3RwZx M5Q7IiPF1Qe6yFYd5qHS4X+LgZIMW6Gg8TMwlbS7fa6qhTcVVAbr64IhzkpKppIp nlS6wQ5QDIIzO1ouMPx87DjeeEtdwuKyJVPJDtY2dOeEdfs5Ykc= =RlfO -----END PGP SIGNATURE----- --NgUjIhqyxYc8+SgE--