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 1nKOtC-0005bh-77 for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Feb 2022 18:18:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nKOtA-0002wV-J7 for pgsql-hackers@arkaria.postgresql.org; Wed, 16 Feb 2022 18:18:52 +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 1nKOtA-0002wM-9v for pgsql-hackers@lists.postgresql.org; Wed, 16 Feb 2022 18:18:52 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nKOt7-0001Br-Tp for pgsql-hackers@lists.postgresql.org; Wed, 16 Feb 2022 18:18:51 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 6F3955C0069; Wed, 16 Feb 2022 13:18:48 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Wed, 16 Feb 2022 13:18:48 -0500 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=fm3; bh=bj1zKdAH6CjZ7cVDHiFZgDfkX7dW+1zv64vOEn nB0g0=; b=H0oPZTbElwTQe44hYZiSCMpxCraIafC3izcP8RxcZkWO4yoS4xbuWa IUG2qC7U7eb/9XGgm9IJ/KfSQj4VjdPuRTGJ3FCTMa1dbpyy/whoZzcCnsLzZ/m2 gYiYjyml7h0lL3VxOTMM2nXfsWjEnIe2BqianOzh6bpAWL5oGNpDUZnu+x7ENY+Z aBPTCNLYL8xzKnqptFYl7GvNRZE3K6W+nMIqem548m6LZvWGIwAN7t9bX5O4A9yM gZ690u/Wz0XW/p1v8K26VZbssncBniWRU3kc4REWlQSAYrqdfaAD5k/i21wXObwo dRW8mrzi7PPa49rJHlufnjfmqkDlR/1w== 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=fm2; bh=bj1zKdAH6CjZ7cVDH iFZgDfkX7dW+1zv64vOEnnB0g0=; b=gCaNWv6FvQseP16lX41T4p53v/yC8jmYl g5LqF/j0fuGqG0Oj7MtaJ87L8u+EHEN/DPQNToHVhaYsjqV/j4OrjqdGLOezTruB ciRcMrqhu0+lvTJYkuroriqz+g/CTeQCDTejPApEU4B+XaXXWWsZjAKUYx6mEF9W sfDuSktgnCo0DXhZqjgpB8aTMGVmL0xvbpvYPPvMn4j2d8uqscLCmUzmQPwlV5+6 ql2yHgOek+jpyTnL8pA9y7dz6zJmFcxa2RkVLfigVnQ+y0Hh7/8ep3K5wejUftug /9wvCtIbEQfh+fd/1mHsEGUZUrnI5+0oYf2WrQUZJThCAc0NZzmJQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrjeeigdduuddtucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne cujfgurhepfffhvffukfhfgggtuggjsehttdertddttddvnecuhfhrohhmpeetnhgurhgv shcuhfhrvghunhguuceorghnughrvghssegrnhgrrhgriigvlhdruggvqeenucggtffrrg htthgvrhhnpedukefhkeelueegveetheelffffjeegleeuudelfeefuedtleffueejfffh ueffudenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpe grnhgurhgvshesrghnrghrrgiivghlrdguvg X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 16 Feb 2022 13:18:47 -0500 (EST) Date: Wed, 16 Feb 2022 10:18:46 -0800 From: Andres Freund To: Peter Geoghegan Cc: Robert Haas , Masahiko Sawada , John Naylor , PostgreSQL Hackers Subject: Re: do only critical work during single-user vacuum? Message-ID: <20220216181846.4syh3mnq5qzjrdiz@alap3.anarazel.de> References: <20220203215048.rmwjzixdzaetedxq@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-02-16 10:14:19 -0800, Peter Geoghegan wrote: > Absolutely -- couldn't agree more. Do you think it's worth targeting > 14 here, or just HEAD? I'd go for HEAD first, but wouldn't protest against 14. > I'm pretty sure that some people believe that wraparound can cause > actual data corruption Well, historically they're not wrong. And we've enough things stored in 32bit counters that I'd be surprised if we didn't have more wraparound issues. Of course that's not related to anti-wrap vacuums... Greetings, Andres Freund