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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1rtaVu-00Fu3M-Ft
	for pgsql-hackers@arkaria.postgresql.org; Sun, 07 Apr 2024 21:57:23 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1rtaVs-00CiOB-04
	for pgsql-hackers@arkaria.postgresql.org; Sun, 07 Apr 2024 21:57:20 +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 <m.melihmutlu@gmail.com>)
	id 1rtaVr-00CiO2-KJ
	for pgsql-hackers@lists.postgresql.org; Sun, 07 Apr 2024 21:57:19 +0000
Received: from mail-oo1-xc29.google.com ([2607:f8b0:4864:20::c29])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <m.melihmutlu@gmail.com>)
	id 1rtaVj-001SDC-N4
	for pgsql-hackers@lists.postgresql.org; Sun, 07 Apr 2024 21:57:18 +0000
Received: by mail-oo1-xc29.google.com with SMTP id 006d021491bc7-5aa1e9527d1so899926eaf.1
        for <pgsql-hackers@lists.postgresql.org>; Sun, 07 Apr 2024 14:57:11 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20230601; t=1712527030; x=1713131830; darn=lists.postgresql.org;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=z1TPWEp9muFuuLu2Pv1XFzR+AycqG20N3yoBRXsASFE=;
        b=FNrxAln47gRqQpMqOTH8UdQtGRLW2w+23mWVPsVRDSCb/s9rujY/PvR0P9NpPwZddL
         BYMNdAVXg7TYVKuVOUt3xAK53NC5VuViuauNFx+zs33pCkw14CBXz+ctxJR/8Nvj+JGD
         3zQD3aSVqS6lLTjugM+u2mLjP/btjgmMBWs+CPaRal48HHcRUvWUkUewcrrm6/wwva/1
         VxB//OGEBch0F7dMNd+TLlCYNN8+9o3UU1xDElStlzWtwBOo2zWe77Sjk3tnjFNqcSUm
         VNq98faY8ELwdX1FHjtBACozJXyFEDDNWe/5/6p3hRuBSXUrp0W9bAk9NuX24hmXi8WJ
         Kddg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1712527030; x=1713131830;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=z1TPWEp9muFuuLu2Pv1XFzR+AycqG20N3yoBRXsASFE=;
        b=dInL1/qzZCmLHQa17g7Ln5g45XvqtwPPZTUfmm0aAMg2tHXv9NNrdySjcTBJxbiy1y
         WwqBqxE9jNoXeR5hL9Wleb1AYz3PqJBiH4IIpsbLIkNBqtIhrJTtS7tkew+g1stTqr1+
         9l0TdSOzU4ERSN0D+DytInj+DrcR5qbeP1n94Ol6ntP1FVtH0bZZaynbP2EUiCbwdR3X
         HXrsw3M+/f0G+B8k1FJbYjh0pNUhJ4i1XSYKaewujVHqAHuS6y1fCLtt69G1RhfTGVww
         xAqVjEhhH8dH9zcuBDoEnLTR9KgFFz6NhYnvuUYSakoFBYG/y9RagHmLiJw4G+yMdAWR
         i48A==
X-Forwarded-Encrypted: i=1; AJvYcCU+SBCv26jsw4Azzs+As5eSfquSa8r9ynJrsMvEqZhrzSZxaYwANnI5dN102x4JFT3UQ+D5eLgpCXXYDe/NOeY1IV0qIqMCmIEKGcuNm9MUHuB3
X-Gm-Message-State: AOJu0Yy6H0t9iMl0leY+so+vqc3bmg/ZbZDxjVLxzBEhU8Bb8RPqiaRQ
	a1CHa1mN7yuSI3mWMs4CRCzu2FFppTOX1G49TuqEpjHsTrsktgwRWlWhrHw+gpsVf3BlyBYQWDF
	Q6AflTrvQ3HaedxSMF7QcHVC/Smw=
X-Google-Smtp-Source: AGHT+IE+CEdbBDdHaI7lFy9sts48GA+7mrbe8dcH2hPZeXM73Zyi4DlTTR4Qsv7xejKf1pewe/2AmkZ+JuSTwQ5EfTU=
X-Received: by 2002:a05:6808:2791:b0:3c5:f4f4:82ce with SMTP id
 es17-20020a056808279100b003c5f4f482cemr1024585oib.57.1712527029707; Sun, 07
 Apr 2024 14:57:09 -0700 (PDT)
MIME-Version: 1.0
References: <CA+TgmoZDm5LHyLcRm2RTak_xbOcbiMyZvddZ7HSH+x-Lp9+BrQ@mail.gmail.com>
 <CAGPVpCSPoks12A1Hv_XHKTozYbtRp7uAMOag64-v_wfRkWqNxw@mail.gmail.com>
 <CA+TgmoZYS32e_t10Br3KD50vjUgr4i5yEtmcBKMeaX5AacYJDA@mail.gmail.com>
 <CAGECzQTYUhnC1bO=zNiSpUgCs=hCYxVHvLD2doXNx3My6ZAC2w@mail.gmail.com>
 <CA+TgmobpDvzyjQYX7_Y+gJFW=1_TLZt_EB71y30b0gtLBwfgAQ@mail.gmail.com>
 <CAGPVpCTN-Z9F5Wsq+LEirAv5OYZWPj1j7mE_Yumqxebsdu8YKw@mail.gmail.com>
 <CA+TgmoaMgFMkZZ7MJ=y=7rx195dZ1cViLGCVB8PP=oTGJ0eT=w@mail.gmail.com>
 <20240201032442.v3vd52kzu3hynamf@awork3.anarazel.de> <CA+TgmoagV=W=fyY2Ln_8As+Z8QJSVvnoxbgE3u+ohggxo-cMZg@mail.gmail.com>
 <CA+TgmoYs7QssFjJDUFtPkJk9U3Q_98NxWvq4sXeREZVdAyh2LQ@mail.gmail.com>
 <20240202223827.5odxkvnh4x6coe7y@awork3.anarazel.de> <CAGPVpCSX8bTF61ZL9jOgh1AaY3bgsWnQ6J7WmJK4TV0f2LPnJQ@mail.gmail.com>
 <CA+TgmoYr+ThbKThynszV1UyosewyvUF8vqY-vKeSPGXCbgoniQ@mail.gmail.com>
 <CAGECzQT9gH6uUd9pnTC=NB7TSwiTsO3kxYH5BXraSy3549Oe_g@mail.gmail.com>
 <CAApHDvoHJYcv+RCeaXM3VL6_44CgfjLLzvBbVAPvVLEMDxUdDA@mail.gmail.com>
 <CAGPVpCSCV7qtc4wjWCz2=Dad-OnJsr4zM_8Nv2qTO0HyFToNBA@mail.gmail.com>
 <CAGECzQTgup-uK9YXTM+24ib4VVk93RW_Stsh3KtHGZnrCybdyA@mail.gmail.com>
 <CAGPVpCQ-265P-DY8hZADEKE5GO0-1NVB9kn7dH82BQgEUbdv1g@mail.gmail.com>
 <CAApHDvoxAnbaxRnn=uEZow_xMK=dEqHHKksTHVRMtK4sNRt2_Q@mail.gmail.com>
 <CAGPVpCSJN5sdSB6bjGCuP5v_6=zPhTeZef_VhsRStiyHci+rLg@mail.gmail.com>
 <CAGPVpCRc1vE4reowMynubn09Y2KKuK3OdVrPySGUkgJwYmse7g@mail.gmail.com>
 <CAGECzQRbn5iq7LFhFSjywO2Aa9qQKzAGYeXH0M2M4t9edsbF7Q@mail.gmail.com>
 <CAGPVpCQWUz=VGAjycSw_1aRLRXj5wp8hubZHq992KBxp25veSQ@mail.gmail.com> <CAApHDvomWMAHVEUJL0bXE4Og9qwAeqdehP9gcWS6Px0yc6aH+Q@mail.gmail.com>
In-Reply-To: <CAApHDvomWMAHVEUJL0bXE4Og9qwAeqdehP9gcWS6Px0yc6aH+Q@mail.gmail.com>
From: Melih Mutlu <m.melihmutlu@gmail.com>
Date: Mon, 8 Apr 2024 00:56:56 +0300
Message-ID: <CAGPVpCT_nSLGkrSYYhrPH_0-4wDR1W57PeTMLoY7=bGCYTuPyg@mail.gmail.com>
Subject: Re: Flushing large data immediately in pqcomm
To: David Rowley <dgrowleyml@gmail.com>
Cc: Jelte Fennema-Nio <postgres@jeltef.nl>, 
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Andres Freund <andres@anarazel.de>, 
	Heikki Linnakangas <hlinnaka@iki.fi>, Robert Haas <robertmhaas@gmail.com>, 
	Thomas Munro <thomas.munro@gmail.com>
Content-Type: multipart/alternative; boundary="0000000000004630c0061588c53b"
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: <https://www.postgresql.org/message-id/CAGPVpCT_nSLGkrSYYhrPH_0-4wDR1W57PeTMLoY7%3DbGCYTuPyg%40mail.gmail.com>
Precedence: bulk

--0000000000004630c0061588c53b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

David Rowley <dgrowleyml@gmail.com>, 6 Nis 2024 Cmt, 04:34 tarihinde =C5=9F=
unu
yazd=C4=B1:

> Does anyone else want to try the attached script on the v5 patch to
> see if their numbers are better?
>

I'm seeing the below results with your script on my machine (). I ran it
several times, results were almost similar each time.

master:
Run 100 100 5000000: 1.627905512
Run 1024 10240 200000: 1.603231684
Run 1024 1048576 2000: 2.962812352
Run 1048576 1048576 1000: 2.940766748

v5:
Run 100 100 5000000: 1.611508155
Run 1024 10240 200000: 1.603505596
Run 1024 1048576 2000: 2.727241937
Run 1048576 1048576 1000: 2.721268988

--0000000000004630c0061588c53b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,sans-serif"><span style=3D"font-family:Arial,Helvetica,sans-=
serif">David Rowley &lt;<a href=3D"mailto:dgrowleyml@gmail.com">dgrowleyml@=
gmail.com</a>&gt;, 6 Nis 2024 Cmt, 04:34 tarihinde =C5=9Funu yazd=C4=B1:</s=
pan><br></div></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_q=
uote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,2=
04);padding-left:1ex">
Does anyone else want to try the attached script on the v5 patch to<br>
see if their numbers are better?<br></blockquote><div><br></div><div><div c=
lass=3D"gmail_default" style=3D"font-family:arial,sans-serif">I&#39;m seein=
g the below results with your script on my machine (). I ran it several tim=
es, results were almost similar each time.</div><div class=3D"gmail_default=
" style=3D"font-family:arial,sans-serif"><br></div><div class=3D"gmail_defa=
ult" style=3D"font-family:arial,sans-serif">master:</div><div class=3D"gmai=
l_default" style=3D"font-family:arial,sans-serif">Run 100 100 5000000: 1.62=
7905512<br>Run 1024 10240 200000: 1.603231684<br>Run 1024 1048576 2000: 2.9=
62812352<br>Run 1048576 1048576 1000: 2.940766748<br><br></div><div class=
=3D"gmail_default" style=3D"font-family:arial,sans-serif">v5:</div><div cla=
ss=3D"gmail_default" style=3D"font-family:arial,sans-serif">Run 100 100 500=
0000: 1.611508155<br>Run 1024 10240 200000: 1.603505596<br>Run 1024 1048576=
 2000: 2.727241937<br>Run 1048576 1048576 1000: 2.721268988<br></div><br></=
div><div>=C2=A0</div><div><br></div></div></div>

--0000000000004630c0061588c53b--