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.96) (envelope-from ) id 1w90JA-0016bJ-12 for pgsql-hackers@arkaria.postgresql.org; Sat, 04 Apr 2026 12:41:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w90J8-00GHc4-1S for pgsql-hackers@arkaria.postgresql.org; Sat, 04 Apr 2026 12:40:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w90J7-00GHbj-1s for pgsql-hackers@lists.postgresql.org; Sat, 04 Apr 2026 12:40:58 +0000 Received: from fout-a1-smtp.messagingengine.com ([103.168.172.144]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w90J5-00000000WHX-0olJ for pgsql-hackers@postgresql.org; Sat, 04 Apr 2026 12:40:56 +0000 Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44]) by mailfout.phl.internal (Postfix) with ESMTP id EC475EC01DF; Sat, 4 Apr 2026 08:40:53 -0400 (EDT) Received: from phl-frontend-03 ([10.202.2.162]) by phl-compute-04.internal (MEProxy); Sat, 04 Apr 2026 08:40:53 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm3; t=1775306453; x= 1775392853; bh=RKV5qZ/gH2Qjyj8TxROFw0E19jjSubgDudli+u4XRTI=; b=m Rc0ZS240Ih7tFKjXqDI1vz2v4HwpF45DBWNU8E0EZ+MfMew2bBh2bgy71orhlnva r+ugtOlRScAhZRCrGjHUGWldPB93npbrG5/+aNRQoJKczAUZhDWep+sWmsNDJ1gm OySsRAJeLh9G/LWLG2J/SVqtdVCyOBe8N21ly0XNz9/VI/1D/sSlECdyxBf1SGfP SowBPBZt7KS1J2I91hq7bJcLou94zrc7hmImOW5aVUXiMQ+uqOjTk49VXJ/3ykxV PWFyTjMn3DMg7zR+lN9bZY9xhBtaZD3POm1Cb94cXRSnc6nd0UjbJKQZk2awDtfz s1F8KUJu2KB6xbGq4s/iw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1775306453; x=1775392853; bh=R KV5qZ/gH2Qjyj8TxROFw0E19jjSubgDudli+u4XRTI=; b=r7HUjtwGteQMyR+/u zOoNXSBLbPQWLjQh1S9Z2A+rWARN+Rp2mwgEBoOUJCn4DqCuhPIwYK9xF7Vu6FwO 8C85xUhBjGasgZxll+ZCRIg2H0PnByawcbdgy19vTYDZ94aCtDGB2h9y5uZ67aR6 sbM1JjngtUDx3D3ofmNAvWNe2Mag4iNPOHdA3c962hGE8tYYJoHEzRoGfTShuWwF HtOgV3FawzHAyqUjjQmA62Kch+b+SK+FSoNqYNH+qdd5S1UaMuYc86NcSsMtvyxh HB78MdBTH7Ov5+1CQJ6KiD6HGJ95lXcdHLlgPa5j8PlfVt7z8dOPFb+JJGNdUQN+ UdC6A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefhedrtddtgdduudekkecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug hrpeffhffvvefukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpemllhhvrghrohcu jfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgeskhhurhhilhgvmhhurdguvgeqnecuggftrf grthhtvghrnhepteeuvdehffekvefgueehveetveekgfegtddtueefueehuddutdfhfeff hfejfeffnecuffhomhgrihhnpegvnhhtvghrphhrihhsvggusgdrtghomhenucevlhhush htvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvges khhurhhilhgvmhhurdguvgdpnhgspghrtghpthhtohepiedpmhhouggvpehsmhhtphhouh htpdhrtghpthhtohepsghhrghrrghthhdrrhhuphhirhgvugguhihfohhrphhoshhtghhr vghssehgmhgrihhlrdgtohhmpdhrtghpthhtohepnhgrthhhrghnuggsohhsshgrrhhtse hgmhgrihhlrdgtohhmpdhrtghpthhtohepshgrmhhimhhsvghihhesghhmrghilhdrtgho mhdprhgtphhtthhopehsrghthigrnhgrrhhlrghpuhhrrghmsehgmhgrihhlrdgtohhmpd hrtghpthhtohepphhgshhqlhdqhhgrtghkvghrshesphhoshhtghhrvghsqhhlrdhorhhg pdhrtghpthhtoheprhhosgesgiiiihhllhgrrdhnvght X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 4 Apr 2026 08:40:53 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1775306451; bh=KAnAIf7DxPBI8kjIq/tz5fJ/aLf62HKn4p+40I0mxbA=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=n06sOYjW8lOXmJKc0bxZ2VuxVjW+liQHDrRIn+CfBjDU2/nzG5QHrijWObub1lyS2 TDwO3fF5DIkO77e4+2ytpu31febfZSWX+qSIA21vlwbW3FbUA7f4jidHSlQZE7HKNi Tuh+jXI7odgK55UZAnasA56JaFg1cfNUXKGtXOPqrhwqDWZlPOJw4eLyNlC1GzHxB9 32T2ogcDRC+HXB2BqOqtg9XduUdXcN0dkEqd8GdWTNzFYgeZOvGDnejjZg2iTMH7dE 7ZsgGhvIWQTpH/dbxz2G2R+lxIsP7ZWirR8B4bz81EJPICFlldAcN8TdzuQz9sd1dJ R3HeoztR7IIcw== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id 5DB2F7C; Sat, 04 Apr 2026 14:40:51 +0200 (CEST) Date: Sat, 4 Apr 2026 14:40:51 +0200 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Robert Treat Cc: Nathan Bossart , Sami Imseih , Bharath Rupireddy , satyanarlapuram@gmail.com, pgsql-hackers Subject: Re: remove autoanalyze corner case Message-ID: <202604041240.p3x7ghuwvtbs@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2026-Apr-04, Robert Treat wrote: > AFAICS, near misses on wraparound in and of itself have no correlation > with statistical changes in your data, so I'd agree it isn't > necessary, and the fact that it behaves differently in this more > narrow case than it would in the more general case, when these two > cases are (as far as I've ever known) supposed to behave the same way, > I'd be +1 to remove this. Yeah, that matches my impression. +1 to remove it. -- Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/ "La verdad no siempre es bonita, pero el hambre de ella sí"