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 1k2LYs-0001hm-0z for pgsql-hackers@arkaria.postgresql.org; Sun, 02 Aug 2020 21:30:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1k2LYq-0006LB-M2 for pgsql-hackers@arkaria.postgresql.org; Sun, 02 Aug 2020 21:30:28 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k2LYq-0006L3-Ex for pgsql-hackers@lists.postgresql.org; Sun, 02 Aug 2020 21:30:28 +0000 Received: from smtp.outgoing.loopia.se ([93.188.3.37]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1k2LYo-0002HM-2t for pgsql-hackers@postgresql.org; Sun, 02 Aug 2020 21:30:27 +0000 Received: from s807.loopia.se (localhost [127.0.0.1]) by s807.loopia.se (Postfix) with ESMTP id 8F822218F9F for ; Sun, 2 Aug 2020 23:30:22 +0200 (CEST) Received: from s630.loopia.se (unknown [172.22.191.5]) by s807.loopia.se (Postfix) with ESMTP id 70ADC308E355; Sun, 2 Aug 2020 23:30:22 +0200 (CEST) Received: from s473.loopia.se (unknown [172.22.191.5]) by s630.loopia.se (Postfix) with ESMTP id 5C72713ABF1B; Sun, 2 Aug 2020 23:30:22 +0200 (CEST) X-Virus-Scanned: amavisd-new at amavis.loopia.se X-Spam-Flag: NO X-Spam-Score: -1 X-Spam-Level: X-Spam-Status: No, score=-1 tagged_above=-999 required=6.2 tests=[ALL_TRUSTED=-1] autolearn=disabled Received: from s645.loopia.se ([172.22.191.5]) by s473.loopia.se (s473.loopia.se [172.22.190.13]) (amavisd-new, port 10024) with LMTP id LpXPE9wohj0H; Sun, 2 Aug 2020 23:30:22 +0200 (CEST) X-Loopia-Auth: user X-Loopia-User: daniel@yesql.se X-Loopia-Originating-IP: 81.224.181.40 Received: from daniels-mbp.lan (81-224-181-40-no272.tbcn.telia.com [81.224.181.40]) (Authenticated sender: daniel@yesql.se) by s645.loopia.se (Postfix) with ESMTPSA id D8D2A156E4B2; Sun, 2 Aug 2020 23:30:21 +0200 (CEST) Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 12.4 \(3445.104.14\)) Subject: Re: MultiXact\SLRU buffers configuration From: Daniel Gustafsson In-Reply-To: <2ECE132B-C042-4489-930E-DBC5D0DAB84A@yandex-team.ru> Date: Sun, 2 Aug 2020 23:30:21 +0200 Cc: Kyotaro Horiguchi , pgsql-hackers Content-Transfer-Encoding: quoted-printable Message-Id: <90C1AC09-75E9-4998-8D14-2CFF419EDF0B@yesql.se> References: <3B099683-ECCD-43CD-A3D6-F08C3745002A@yandex-team.ru> <20200514.151659.1224056315528271804.horikyota.ntt@gmail.com> <102F673B-C9C5-4823-A92F-96799FC61ED0@yandex-team.ru> <20200515.090333.24867479329066911.horikyota.ntt@gmail.com> <2ECE132B-C042-4489-930E-DBC5D0DAB84A@yandex-team.ru> To: "Andrey M. Borodin" X-Mailer: Apple Mail (2.3445.104.14) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk > On 8 Jul 2020, at 09:03, Andrey M. Borodin = wrote: >=20 >=20 >=20 >> 2 =D0=B8=D1=8E=D0=BB=D1=8F 2020 =D0=B3., =D0=B2 17:02, Daniel = Gustafsson =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0= =B0): >>=20 >>> On 15 May 2020, at 02:03, Kyotaro Horiguchi = wrote: >>=20 >>> Generally in such cases, condition variables would work. In the >>> attached PoC, the reader side gets no penalty in the "likely" code >>> path. The writer side always calls ConditionVariableBroadcast but = the >>> waiter list is empty in almost all cases. But I couldn't cause the >>> situation where the sleep 1000u is reached. >>=20 >> The submitted patch no longer applies, can you please submit an = updated >> version? I'm marking the patch Waiting on Author in the meantime. > Thanks, Daniel! PFA V2 This version too has stopped applying according to the CFbot. I've = moved it to the next commitfest as we're out of time in this one and it was only = pointed out now, but kept it Waiting on Author. cheers ./daniel=