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 1nXZnY-0006Zz-8i for pgsql-hackers@arkaria.postgresql.org; Fri, 25 Mar 2022 02:35:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nXZnX-0007nN-4w for pgsql-hackers@arkaria.postgresql.org; Fri, 25 Mar 2022 02:35:31 +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 1nXZnV-0007nE-9G for pgsql-hackers@lists.postgresql.org; Fri, 25 Mar 2022 02:35:30 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nXZnS-0003dE-D2 for pgsql-hackers@postgresql.org; Fri, 25 Mar 2022 02:35:28 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 849375C01B2; Thu, 24 Mar 2022 22:35:25 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Thu, 24 Mar 2022 22:35:25 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anarazel.de; h= cc:cc: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=fm1; bh=gBu6ViDW/UbEJxpf7W9CqjYfJLBx3/d3J11Pcg jWJh8=; b=1DfwJF/lW+WvFaI2y2vrwEZICwPZtwF2y8RSzZqa7LXSZHfvBS3cCV 9wA0e32meA/oObkZZ0M/OTHDne3dX2hWI9qZPoBPB9txxV1MXL5lH2cxFzfDA0oa KWWd+BVGwXhnkU35gNVUM7o/Jt53PZ6nDcbf+bv2hK0NGKWh2wUL9maFLDB7qe4f 6J+NmY2Fkxo0DtqZGTic2M6FwuSKuY+UueseZoqzGFRx8KYKN7F7aCQnWwqn2Ar2 t6CLfc/0YMwgapqduZNovS9SV3nXObrkLfDph6A5R/d6SYtk6nXp4WIUtOfXvAvk lAZNgMa/RS+VP46oGkcSDtnd8EkAfrOg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:date:date: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; bh=gBu6ViDW/UbEJxpf7 W9CqjYfJLBx3/d3J11PcgjWJh8=; b=lMRgKjyciPeDCXRbI/3AzWzGYIyhxZOj7 /N9/A8UVCBXMu/zQBAEtSL4rTeH4tYtM92kDEZpp6yFtNjcRBbBRfNiFVLR3YIvq knsfLlj6STa7izYjv+wbhYcBTKVfcPgSAEipxTY22w1dmRazrpkW9kKe34NIw9xd afvkohfMRW6I5sopBYQfO3bu57kNzh0LwG99P9G0DEu0e/3dC26G+FCoqWNLaUtN w7ZyqfALcuyIRIrc5iAjje6OIKtIN2AJeOeA6qeYeo8kDBVEKly4cl+W9EO3DaYT GhuMO9uzEau1kY0SmBTXMrnZ7HtFN7xbQzaBY+9Zprsrl+PISZXMQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrudehtddggeegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvffukfhfgggtuggjsehttdertddttddvnecuhfhrohhmpeetnhgurhgv shcuhfhrvghunhguuceorghnughrvghssegrnhgrrhgriigvlhdruggvqeenucggtffrrg htthgvrhhnpedukefhkeelueegveetheelffffjeegleeuudelfeefuedtleffueejfffh ueffudenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpe grnhgurhgvshesrghnrghrrgiivghlrdguvg X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 24 Mar 2022 22:35:24 -0400 (EDT) Date: Thu, 24 Mar 2022 19:35:23 -0700 From: Andres Freund To: Thomas Munro Cc: Tom Lane , Robert Haas , Daniel Gustafsson , Kyotaro Horiguchi , deniel1495@mail.ru, Ibrar Ahmed , tejeswarm@hotmail.com, hlinnaka , Masahiko Sawada , "pgsql-hackers@postgresql.org" , Daniel Wood Subject: Re: Corruption during WAL replay Message-ID: <20220325023523.qege22k7mxddq3st@alap3.anarazel.de> References: <20220318.102109.162855329039722212.horikyota.ntt@gmail.com> <3152696.1648159485@sss.pgh.pa.us> <3167047.1648169107@sss.pgh.pa.us> <3170060.1648171358@sss.pgh.pa.us> <20220325021402.r22saxtwuqu3bbil@alap3.anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 2022-03-25 15:23:24 +1300, Thomas Munro wrote: > One random thing I've noticed about serinus is that it seems to drop > UDP packets more than others, but dragonet apparently doesn't: Serinus is built with optimization. Which I guess could lead to other backends reporting stats more quickly? And of course could lead to running more often (due to finishing before the next cron invocation). I think I've also configured my animals to run more often than many other owners. So I'm not sure how much can be gleaned from raw "failure counts" without taking the number of runs into account as well? - Andres