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 1rJjpu-00FKcb-EW for pgsql-hackers@arkaria.postgresql.org; Sun, 31 Dec 2023 00:37:50 +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 1rJjps-003uBI-T6 for pgsql-hackers@arkaria.postgresql.org; Sun, 31 Dec 2023 00:37:48 +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 1rJjps-003uB8-Ja for pgsql-hackers@lists.postgresql.org; Sun, 31 Dec 2023 00:37:48 +0000 Received: from wout4-smtp.messagingengine.com ([64.147.123.20]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rJjpq-00Cz7G-6X for pgsql-hackers@postgresql.org; Sun, 31 Dec 2023 00:37:47 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.47]) by mailout.west.internal (Postfix) with ESMTP id ACA2F3200A0C; Sat, 30 Dec 2023 19:37:43 -0500 (EST) Received: from mailfrontend2 ([10.202.2.163]) by compute6.internal (MEProxy); Sat, 30 Dec 2023 19:37:44 -0500 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:subject :subject:to:to; s=fm2; t=1703983063; x=1704069463; bh=CzJwkBVa3Y Lrmeo2CwUnyWsg3dX0fAGBmdldfdci3sY=; b=pu/0rdy7rcJJpPbw/PCEzw9qBV ZxPTTCtps7WWMe/CjIsOk0LgQjD0EnCQuYALR/uxb1EyxxCXB3tKfq90URJvh7jl 5flvVi/Sp+7DTw/GfCQQEB8i3Y8HqNkP+F1/HEwPjeGO6lGYpt4jN2ix9AWkR/uz rCR6BH7G4scUXschdHH2rl+O9mGQnGXU9qT0ZjiX4xaZAFaQvOiNguWNDpo1kXLG kZBJSOPWtIJ6fpojne3w/nElj0adZhEDUWd/7RJ+sI29oW6EYVw0bc2nU4G4VwdP iidYmYmFme/vuAq2ewGi1K0VfIaJomincuyLlVonWDtCIF1LyMbYQIvEDUIQ== 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:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1703983063; x=1704069463; bh=CzJwkBVa3YLrmeo2CwUnyWsg3dX0 fAGBmdldfdci3sY=; b=mFf/07ApcZRWjyCzzQSncM6QSCQK4d8cc4df0osONh9m WCfB8olfmLHxWCNvvttf8QQH8pEUczCdpdeEWARVjyvfwDDXSOpU2+17jW2xJgNj uqtSV1JderU6t7ntCNX0KOsZPYmX7hVuguebSyH8oS8mONikJWFj2jg53Si3yGUa DBCN2z77hdNjRMke88zUuUtukasv8Bq7M41iSsu2/BzrAHAFxSUqq7ZehnCAVDTG FtD92cN31/wvYMctES67HzANh6XPfNXbQROLdVTFRnJlamwFCVKkbzEjABnvZASd 7dBo7ohV+MWYeaRBXvMtDRli/4KaqWAFId8oiO7caw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrvdefiedgvdehucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdlfeehmdenucfjughrpeffhffvvefukfhfgggtuggjsehgtderredt tddvnecuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesph grqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvghrnhepteelieefudffhffhtdetleeg geegfffhkeeuveetiefgudduvedutefggeeivdejnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiih ii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 30 Dec 2023 19:37:40 -0500 (EST) Date: Sun, 31 Dec 2023 09:37:31 +0900 From: Michael Paquier To: Jelte Fennema-Nio Cc: Anthonin Bonnefoy , Anton Kirilov , Alvaro Herrera , Robert Haas , pgsql-hackers@postgresql.org Subject: Re: Add PQsendSyncMessage() to libpq Message-ID: References: <202311081620.s2a7ao5jtlpe@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="H1o0d3mq0G44Slih" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --H1o0d3mq0G44Slih Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Dec 29, 2023 at 12:52:30PM +0100, Jelte Fennema-Nio wrote: > On Mon, 13 Nov 2023 at 09:20, Anthonin Bonnefoy > wrote: > > \syncpipeline > > tps =3D 2607.587877 (without initial connection time) > > ... > > \endpipeline > > \startpipeline > > tps =3D 2290.527462 (without initial connection time) >=20 > Those are some nice improvements. And I think once this patch is in, > it would make sense to add the pgbench feature you're suggesting. > Because indeed that makes it see what perf improvements can be gained > for your workload. Yeah, that sounds like a good idea seen from here. (Still need to look at the core patch.) -- Michael --H1o0d3mq0G44Slih Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmWQt8sACgkQnvQgOdby QH10uw//ZehBzHNTSXLud2fe+I1LF7XcVGnvkpE1WaOrPGsH2FfM+Jxzi2qdgWez fAAjGGnmLvkoDp8nie4FfFblEJfDucu1XqWvfOaGwj51kD8WHU3OSzPicOYZhL/s XlzMlSGuGVKJz4X3d+zgrl6wQGywuKTuaYJ9LAxDQSYfct8e5tYIGcHs+tYZ3Art 7bADW78otXo5IL1k80+YkYGjyC1kYh/9FeaEJmst8uxwUGNVckrR2yB9EHt8UNtA 2FmNVwQKGOWMUx+SIZysQGiZL3M8xsrgyPTxcFQ9poJVJi0zgmTP0vWGW6xsEwFE NlzeXHJ5+07uz7sFzRC02UHcW+ShuL95KIz4VPavmSBc/zOc3IFENgU1BpSbxt1j lka8si7Rl+Vc/RnZpd5jaHGMI/n10sxGoFOXx228qebO+4uUymNUrNwt/F8OKhLf T2cv9cMICGpivLVL1ZnVh6WW0MmUF+Bd9rkx9uxRbEVIQjjfjKv4Ob8H/MckR0dK 1a9urhy+ScrmYyjhWZucesCKQ4GgPRGHU3Eln99apCAZxLUzyQ3gtzz73kKWPxbr 8BLPTJTgkVOqTervGpNR4vmhdqHpGpRNS78zhOw9PEz5HWWOjTk5UXtMBqUKHyrG Q86Vkj5WsUUvAooyfQ5W829GNUP1JLG0qRwiy8sJgMCpqLD8Nl0= =nn6p -----END PGP SIGNATURE----- --H1o0d3mq0G44Slih--