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 1nKqyi-0006KD-Qk for pgsql-hackers@arkaria.postgresql.org; Fri, 18 Feb 2022 00:18:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nKqyh-00031m-FS for pgsql-hackers@arkaria.postgresql.org; Fri, 18 Feb 2022 00:18:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nKqyh-00031c-62 for pgsql-hackers@lists.postgresql.org; Fri, 18 Feb 2022 00:18:27 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nKqye-0008UV-Ud for pgsql-hackers@postgresql.org; Fri, 18 Feb 2022 00:18:26 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id D2AF85C00E6; Thu, 17 Feb 2022 19:18:23 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute3.internal (MEProxy); Thu, 17 Feb 2022 19:18:23 -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=tFrtACVszTC2UlwXPa4yGUz6rMuKjhPtPMb2cK W1bmY=; b=RBf28TbZYHV8tk862KDvOrrlsWpROUE4SOlK8S9gGQiGmUu2KsCmdC iAp745In9gKduEGZTP44d+b9BE9wcWnNP55vyU/YlHtHCBPH+mdf84AQXvg/qbu0 EqylaULx4bxrd5471C6sz0gcfFzyxjN7ndTOJobDRnMXRX3ANHe69ztDx3rVsoj1 6JyOCrRn4L/2cTSwl30B0jFqTLDHFy6ImpC3Ea9u2ihe62jTW/L4jh0deI/QD17D iQmBbufV6eZlCJ6EYcUEhqOAaHsi5cOyGIL+e28vgVAiBY3Oi9ApnVYPSzbhwYLd cUk8GiFoPdPis6G0XaMrb/uwSV9JVj/w== 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=tFrtACVszTC2UlwXP a4yGUz6rMuKjhPtPMb2cKW1bmY=; b=McHkynDtZtH7d6T8dDCrruaE+b7Nql0ft LyYGyZ2wrRgamtBx4gNDw+oyqj5BTwZB2R8KTC7sTPCREhgU03FkxRBPnUMmA4dR bhFqpZODLuQFQ67jx6rL3VSKnUa4QFiNtyjfcY4ZphFKmOv+lh+lzkSopIPkKHIe OxZtq6aolGc+BIqaFGrAYrn8Z6TXN6ffmn9qaMm2MvxXjbMBPHhxDgfJ0vZXlDQC 9sd77ZrnWWIjkcvoh9ejpf/0Y1tdgfRBS0W1c2WohtXLcJ3b88wFCXkFFdcHD6eo 0DCCstnr0+G7lyy4xAZ270R2+fHwP1MbnpUdhdjbCgxlH+p4i386Q== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvvddrjeelgddvtdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpeffhffvuffkfhggtggujgesthdtredttddtvdenucfhrhhomheptehnughrvghs ucfhrhgvuhhnugcuoegrnhgurhgvshesrghnrghrrgiivghlrdguvgeqnecuggftrfgrth htvghrnhepudekhfekleeugeevteehleffffejgeelueduleeffeeutdelffeujeffhfeu ffdunecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprg hnughrvghssegrnhgrrhgriigvlhdruggv X-ME-Proxy: Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 17 Feb 2022 19:18:23 -0500 (EST) Date: Thu, 17 Feb 2022 16:18:22 -0800 From: Andres Freund To: Peter Geoghegan Cc: PostgreSQL Hackers Subject: Re: Nonrandom scanned_pages distorts pg_class.reltuples set by VACUUM Message-ID: <20220218001822.oakqc6o4qbaxaudw@alap3.anarazel.de> References: <20220217030843.lobpksmgpqiifp2c@alap3.anarazel.de> <20220217183303.7ubhfndfveodfa5j@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-17 14:23:51 -0800, Peter Geoghegan wrote: > On Thu, Feb 17, 2022 at 10:33 AM Andres Freund wrote: > > On 2022-02-16 19:43:09 -0800, Peter Geoghegan wrote: > > > It makes the code in vacuumlazy.c much cleaner. In fact, that's how commit > > > 44fa8488 started off -- purely as refactoring work. > > > > The problem is that it didn't end up as that. You combined refactoring with > > substantial changes. And described it large and generic terms. > > What substantial changes are you referring to? The one thing that did > change was the commit message, which framed everything in terms of the > later work. It really is true that the patch that I committed was > essentially the same patch as the one posted on November 22, in both > style and substance. Before I really even began to think about the > freezing stuff. This is a matter of record. Here I was referencing your description of how the patch started ("purely as refactoring work"), and then evolved into something not just a refactoring. > > It's a contentious thread. I asked for things to be split. In that context, > > it's imo common curtesy for non-trivial patches to write something like > > I didn't see a way to usefully split up 0001 any further (having > already split it up into 0001 and 0002). That's not particularly > obvious, but it's true. If helpful I can give a go at showing how I think it could be split up. Or perhaps more productively, do that on a not-yet-committed larger patch. Greetings, Andres Freund