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.94.2) (envelope-from ) id 1ta8yr-00GfBH-LM for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Jan 2025 07:47:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1ta8xs-00CiUe-IY for pgsql-bugs@arkaria.postgresql.org; Tue, 21 Jan 2025 07:46:24 +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.94.2) (envelope-from ) id 1ta8xs-00CiTT-5P for pgsql-bugs@lists.postgresql.org; Tue, 21 Jan 2025 07:46:24 +0000 Received: from fout-b5-smtp.messagingengine.com ([202.12.124.148]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1ta8xp-000h3X-2t for pgsql-bugs@lists.postgresql.org; Tue, 21 Jan 2025 07:46:23 +0000 Received: from phl-compute-01.internal (phl-compute-01.phl.internal [10.202.2.41]) by mailfout.stl.internal (Postfix) with ESMTP id A216F114011A; Tue, 21 Jan 2025 02:46:20 -0500 (EST) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-01.internal (MEProxy); Tue, 21 Jan 2025 02:46:20 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1737445580; x=1737531980; bh=Fq4KTa3xS0 /XrTFREq1ErAF7HMZWapd9yWCsCeUhXbo=; b=hkzxb+rrGW1Ty6w0wzG7BXk+qm /oqBsfMCRTpnfhjnKxhwfYktvtRnzV6pWwU6nMfAtDH+aFTETqt74xMvoP5IDPqu h5OmO7Ni2sVI9H/qkTeU8k7JrsksIm6GduVtZO5Q5T4w2TMaWfQL1VwXMCjO7TTg GhxGyb9O8gTsl7GTruPZuDF3VK5njGxlutVIEb7ZVzSqo8BJY6lvOXREmKRPsfLB 8rkxcaETRM0eiW0AKKyEswsgpx8SiaD3YCumEjU8BekfHuZEqB0mQ98XS9ro/HNH YWuvp44EA2pQg0EVOL0pE0/iOPDtTcVon+Gew629h60rkRresJDt08Cyk6hA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t= 1737445580; x=1737531980; bh=Fq4KTa3xS0/XrTFREq1ErAF7HMZWapd9yWC sCeUhXbo=; b=Fn8xt004wDisVWficQpDfTMIJ8AZ2e48eANVAsaej2zrXFkYNNk XJqxFIhH9/BXTzw1bVd7NhYL2kLjfAZ1Z0drGKNVQw6t3AZAD0oaAp+4+FXJZu8i 4KDvHIGZSnG2B5XTv1LnVLxUikDoIprdauHxysPCFDSHdHL3DfT4r/NuDsBuq3DV D9XB/+3ElsDDR+LkZJ9gHFa9fo47kFb/aXB0i7gFubUDlCcXyji3ediU3XU2Y3QZ D44PLZu5mG/GYFINlwl3lPVVPptSZ6J119WCN8v3jbYNGo6NZ/AKsZCgi35RLS/2 OX83RrCNJRP1i6jHqW8VuxV6gbKRaDsj1yQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefuddrudejtddgudduudcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpggftfghnshhusghstghrihgsvgdp uffrtefokffrpgfnqfghnecuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivg hnthhsucdlqddutddtmdenfghrlhcuvffnffculdejtddmnecujfgurhepfffhvfevuffk fhggtggujgesghdtreertddtjeenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrh cuoehmihgthhgrvghlsehprghquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeev teejgfejveegudekheeiueeiueeiveeuiedugeehveeugffgudeuleegleeiteenucevlh hushhtvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghl sehprghquhhivghrrdighiiipdhnsggprhgtphhtthhopeegpdhmohguvgepshhmthhpoh huthdprhgtphhtthhopegrnhhtvghnghihnhhnnhhnheefieesghhmrghilhdrtghomhdp rhgtphhtthhopehmrghsrghordhfuhhjihhisehoshhsrdhnthhtuggrthgrrdgtohhmpd hrtghpthhtohepuggrnhhivghlseihvghsqhhlrdhsvgdprhgtphhtthhopehpghhsqhhl qdgsuhhgsheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhg X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 21 Jan 2025 02:46:17 -0500 (EST) Date: Tue, 21 Jan 2025 16:45:58 +0900 From: Michael Paquier To: =?utf-8?B?5YuH5qyhIOWuieiXpA==?= Cc: Fujii Masao , Daniel Gustafsson , "pgsql-bugs@lists.postgresql.org" Subject: Re: reltuples kept decreasing =?utf-8?Q?wi?= =?utf-8?B?dGggZWFjaCBhdXRvdmFjdXVtIHJ1biBSZTogQlVHICMxODc3Mzog44Kq44O8?= =?utf-8?B?44OI44OQ44Kt44Ol44O844Og44Gu44Oq44OI44Op44Kk5pmC44GrcmVsdHVw?= =?utf-8?B?bGVz44Gu5YCk44GM5rib5bCR44GZ44KL?= Message-ID: References: <18773-666a02177904ef98@postgresql.org> <35AB3EE5-C24B-476E-ACB5-B93981378773@yesql.se> <3dec196d-72a6-447f-ad2e-f2668f2907a9@oss.nttdata.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="MBhkXGF8P8zCrjIb" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --MBhkXGF8P8zCrjIb Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Jan 21, 2025 at 02:13:05AM +0000, =E5=8B=87=E6=AC=A1 =E5=AE=89=E8= =97=A4 wrote: > =E3=83=80=E3=83=8B=E3=82=A8=E3=83=AB=E3=81=95=E3=82=93 > =E3=81=8A=E4=B8=96=E8=A9=B1=E3=81=AB=E3=81=AA=E3=81=A3=E3=81=A6=E3=81=8A= =E3=82=8A=E3=81=BE=E3=81=99=E3=80=82 This is a mailing list in English, so it would be suited to reply in this language. > =E4=BB=8A=E5=9B=9E=E3=81=AE=E4=BA=8B=E8=B1=A1=E3=81=AFaurora=E3=81=A7=E7= =99=BA=E7=94=9F=E3=81=97=E3=81=A6=E3=81=84=E3=82=8B=E4=BA=8B=E8=B1=A1=E3=81= =AB=E3=81=AA=E3=82=8A=E3=81=BE=E3=81=99=E3=80=82 > =E5=8B=95=E3=81=8D=E3=81=A8=E3=81=97=E3=81=A6=E3=81=AF=E3=83=90=E3=82=B0= =E3=81=AE=E5=8F=AF=E8=83=BD=E6=80=A7=E3=81=8C=E9=AB=98=E3=81=84=E3=81=A8=E8= =80=83=E3=81=88=E3=81=A6=E3=81=84=E3=81=BE=E3=81=99=E3=80=82=E3=81=94=E7=A2= =BA=E8=AA=8D=E3=81=84=E3=81=9F=E3=81=A0=E3=81=91=E3=81=BE=E3=81=99=E3=81=A8= =E5=8A=A9=E3=81=8B=E3=82=8A=E3=81=BE=E3=81=99=E3=80=82 >=20 > =E5=BF=85=E8=A6=81=E3=81=AA=E8=B3=87=E6=96=99=E3=81=AA=E3=81=A9=E3=81=82= =E3=82=8C=E3=81=B0=E9=80=A3=E7=B5=A1=E3=81=8F=E3=81=A0=E3=81=95=E3=81=84=E3= =80=82 >=20 > =E3=81=BE=E3=81=95=E3=81=8A=E3=81=95=E3=82=93 > =E6=83=85=E5=A0=B1=E3=81=AE=E3=81=94=E9=80=A3=E6=90=BA=E3=81=82=E3=82=8A= =E3=81=8C=E3=81=A8=E3=81=86=E3=81=94=E3=81=96=E3=81=84=E3=81=BE=E3=81=99=E3= =80=82=E5=90=8C=E3=81=98=E4=BA=8B=E8=B1=A1=E3=81=8C=E5=86=8D=E7=8F=BE=E3=81= =A7=E3=81=8D=E3=81=9F=E3=81=A8=E3=81=AE=E3=81=93=E3=81=A8=E3=81=A7=E3=80=81 > =E7=8F=BE=E5=9C=A8=E3=81=AE=E3=81=A8=E3=81=93=E3=82=8D=E5=AF=BE=E5=BF=9C= =E3=81=AF=E3=80=81=E3=83=90=E3=82=AD=E3=83=A5=E3=83=BC=E3=83=A0=E3=81=AE=E3= =83=AA=E3=83=88=E3=83=A9=E3=82=A4=E3=81=8C=E7=99=BA=E7=94=9F=E3=81=97=E3=81= =9F=E5=A0=B4=E5=90=88=E3=81=AB=E3=80=81=E3=82=A2=E3=83=8A=E3=83=A9=E3=82=A4= =E3=82=BA > =E3=82=92=E5=AE=9F=E6=96=BD=E3=81=99=E3=82=8B=E6=89=8B=E7=AB=8B=E3=81=A6= =E3=81=97=E3=81=8B=E3=81=AA=E3=81=84=E8=AA=8D=E8=AD=98=E3=81=A7=E3=80=81=E5= =A4=9C=E9=96=93=E3=83=90=E3=83=83=E3=83=81=E6=99=82=E9=96=93=E5=B8=AF=E3=81= =AE=E6=9C=AC=E7=95=AA=E7=92=B0=E5=A2=83=E3=81=A7=E8=B5=B7=E3=81=8D=E3=81=A6= =E3=81=84 > =E3=82=8B=E3=81=93=E3=81=A8=E3=81=8B=E3=82=89=E3=80=81=E9=95=B7=E6=99=82= =E9=96=93=E7=A8=BC=E5=83=8D=E3=81=97=E3=81=9F=E3=82=82=E3=81=AE=E3=81=8C=E3= =81=82=E3=82=8C=E3=81=B0=E3=82=8C=E3=82=93=E3=82=89=E3=81=8F=E3=82=92=E3=82= =82=E3=82=89=E3=81=A3=E3=81=A6=E6=89=8B=E5=8B=95=E3=81=A7=E3=82=A2=E3=83=8A= =E3=83=A9 > =E3=82=A4=E3=82=BA=E3=82=92=E8=A1=8C=E3=81=86=E6=89=8B=E7=AB=8B=E3=81=A6= =E3=81=97=E3=81=8B=E3=81=8A=E3=81=93=E3=81=AA=E3=81=88=E3=81=9A=E3=80=81=E5= =BE=8C=E6=89=8B=E5=BE=8C=E6=89=8B=E3=81=AB=E3=81=AA=E3=81=A3=E3=81=A6=E3=81= =84=E3=81=BE=E3=81=99=E3=83=BB=E3=83=BB=E3=83=BB=E3=82=AA=E3=83=B3=E3=83=A9= =E3=82=A4 > =E3=83=B3=E5=89=8D=E3=81=AB=E3=81=99=E3=81=B9=E3=81=A6=E3=81=AE=E3=83=86= =E3=83=BC=E3=83=96=E3=83=AB=E3=81=AB=E5=AF=BE=E3=81=97=E3=81=A6=E3=82=A2=E3= =83=8A=E3=83=A9=E3=82=A4=E3=82=BA=E3=82=92=E8=A1=8C=E3=81=86=E3=81=93=E3=81= =A8=E3=81=A7=E3=82=AA=E3=83=B3=E3=83=A9=E3=82=A4=E3=83=B3=E3=81=B8=E3=81=AE= =E5=BD=B1 > =E9=9F=BF=E3=82=92=E3=81=AA=E3=81=8F=E3=81=99=E6=89=8B=E7=AB=8B=E3=81=A6= =E3=81=8C=E3=81=82=E3=82=8B=E3=82=8B=E3=81=8B=E3=81=A8=E6=80=9D=E3=81=86=E3= =81=AE=E3=81=A7=E3=81=99=E3=81=8C=E3=80=81=E3=83=86=E3=83=BC=E3=83=96=E3=83= =AB=E6=95=B0=E3=81=8C2000=E3=82=92=E8=B6=85=E3=81=88=E3=81=A6=E3=81=84 > =E3=82=8B=E3=81=AE=E3=81=A7=E3=80=81=E3=82=AA=E3=83=B3=E3=83=A9=E3=82=A4= =E3=83=B3=E9=96=8B=E5=A7=8B=E3=81=BE=E3=81=A7=E3=81=AB=E7=B5=82=E3=82=8F=E3= =82=89=E3=81=9B=E3=82=89=E3=82=8C=E3=82=8B=E3=81=8B=E3=81=AA=E3=81=A9=E6=A4= =9C=E8=A8=BC=E3=82=92=E9=80=B2=E3=82=81=E3=81=A6=E3=81=84=E3=82=8B=E7=8A=B6= =E6=B3=81 > =E3=81=A7=E3=81=99=E3=83=BB=E3=83=BB=20 I do read Japanese, FWIW, and I would recommend to limit yourself in using PostgreSQL rather than Aurora when doing such investigations for such reports. If limiting yourself with Aurora, please contact Aurora support at AWS first. -- Michael --MBhkXGF8P8zCrjIb Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmePULYACgkQnvQgOdby QH083A/9FKGbfZMpFsinDX2hHCS7tIoOnObJ0u+L8ep1fRPdF4eCAEhyF0Ep95/Z hC8/zZ70jVRfKnERvVUo7KNntIxthTzD1cDhpOVO6Ifm7sVOy1ehQsld/uGcQsdB T3gS2VIJLPAC4dPPdE4yopEylnNYPGN6kL0ZmUfQptqshJNsI+422vVlGT8RvK88 PqqhK2+gDFJrNt7DabN0/mKHD2e6uXhRIypKFEQFVWXWKGI5Q42r1uae0p1Yy2qA o87Lgkn81HaUTomFqZH1Os7K/G3gzwXxP1lfxVuvFEWR6CisAbvcB+dY7PrHpHER TD8Lpl7Rb1trDW6vE1/Xh0ET1PcT8MkrpWwUrTmqkgPHMxLU0Z4sEersJgPEkOL9 cwG7a4hcV8rmkZVwJqtFNioXdEwrn7nM/yuXGzSHedzKl/CE9HPB/yTvwooS0u17 Ii+H/8hPWViaXGLUMaKzJwOGbtzpsrI+Y7khZrRfSRO0WC9c/29nxuS0h8vIMBNk eoLGxAUPaHGn7GJEFxq7kNTxPKRPo+wMe/lv9se4DOaKf0TnxnhwAKn8V7qnQJvy /Fxg71glGoYaASA6VKMr6JGfg0dAAxOz4ezSKDETWR7Z/Y13sBDG3+FibaveZ2kH FXJFM3NhHzTSP14PliEbxKo5uK2SaMEcDnZ5XP2/QK79w5N2248= =8bij -----END PGP SIGNATURE----- --MBhkXGF8P8zCrjIb--