Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hAb4i-0005TS-RO for pgsql-hackers@arkaria.postgresql.org; Sun, 31 Mar 2019 14:04:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hAb4h-00047I-IE for pgsql-hackers@arkaria.postgresql.org; Sun, 31 Mar 2019 14:04:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hAb4g-0003x7-DN for pgsql-hackers@lists.postgresql.org; Sun, 31 Mar 2019 14:04:39 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hAb4c-0005Wr-5t for pgsql-hackers@lists.postgresql.org; Sun, 31 Mar 2019 14:04:37 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id DA98C20CB3; Sun, 31 Mar 2019 10:04:30 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Sun, 31 Mar 2019 10:04:30 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= date:from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=fm1; bh=5YTP85HjnHyPeGcq7Sq6Sdf/cz4 BWt4djJ0XoX1N+rQ=; b=CPPlNJTj0SBfvgEAgUQ4b2HwRe/ghjv/2tjSHEx+ijf j1DaPlRFKNpipU3e+3wrf3FTHtx6eDwXw+0G7mgp6lBpG64oDcRZ5c5w1FVTtMSR trgDEVoY8h1znkBOCE+wtb5YKdwa5fjMpyI7E1WjXWvmgjmqr7TKS0kE0jcLelLb TpDm/WyB01c2kCBGIxFw/+ZRz3aHxlMqYAin8jIun+8hEl9HiVOtLQYubQuX/wT6 Uey+rQUDlr7YXQ6mPmWWbAq9mp8GeK33jYMuYXQyXQDAecHZIRU4VFkgP1hFc+zN QY0x1c88hJUwiIb0g60IBwVCmw5oLB81rvWHcYJVbaA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=5YTP85 HjnHyPeGcq7Sq6Sdf/cz4BWt4djJ0XoX1N+rQ=; b=nXU8zkzfp3BZ6JnmvbSbxG IEAW4PNFX5oKjR2QUFX1vuNh5OsTXcPKByqjSCh6AeIk8DiiLtwqltxklH4R6v0P TrdK3J01S89XPP67TiVWEQJFhfghJIXA2d+vgsbVBile6zALT9YrGL+Kf5EZlvQY JyNN3zBvagN6UqgUQz1SksC5ZLJBijmoRF/qL3a93c86d7lMEG4HhUlTTyfiZMct 5pjpbJGhCPocB3nXWN/Ru0rZz/wcfb713sE8mgvSNSWziSYBIYQa8rVMt9t+Iycf 5Bk6s4u7B5xGP9yAeAda+R3woHWxVBQJIuul6i8YRsnHKdQgo3mGqYDVzUcFLkaw == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedutddrledvgdejgecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecukfhppeduuddurddutddvrddukedtrddukeehnecurfgrrhgr mhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiiinecuvehluh hsthgvrhfuihiivgeptd X-ME-Proxy: Received: from paquier.xyz (ee0822lan1.rev.em-net.ne.jp [111.102.180.185]) by mail.messagingengine.com (Postfix) with ESMTPA id E85BFE46AB; Sun, 31 Mar 2019 10:04:25 -0400 (EDT) Date: Sun, 31 Mar 2019 23:04:22 +0900 From: Michael Paquier To: Andrew Dunstan Cc: Alvaro Herrera , Kyotaro HORIGUCHI , sawada.mshk@gmail.com, tgl@sss.pgh.pa.us, sk@zsrv.org, nasbyj@amazon.com, andres@anarazel.de, robertmhaas@gmail.com, pgsql-hackers@lists.postgresql.org Subject: Re: pgsql: Improve autovacuum logging for aggressive and anti-wraparound ru Message-ID: <20190331140422.GA11799@paquier.xyz> References: <20190329140349.GI1954@paquier.xyz> <20190329142255.GA22447@alvherre.pgsql> <20190330010822.GL1954@paquier.xyz> <3627b6eb-3bfc-ccb3-45e7-a0c96d23abb3@2ndQuadrant.com> <20190330131233.GB28827@paquier.xyz> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="OgqxwSJOaUobr8KG" Content-Disposition: inline In-Reply-To: <20190330131233.GB28827@paquier.xyz> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --OgqxwSJOaUobr8KG Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sat, Mar 30, 2019 at 10:12:33PM +0900, Michael Paquier wrote: > Okay, I'll use that then. And finally committed. I have changed the debug1 message so as "to prevent wraparound" is used instead of "anti-wraparound". I have noticed something which was also missing from all the patches proposed on this thread: a reset of the progress state was not done, and we need to call pgstat_progress_end_command() in order to do that. -- Michael --OgqxwSJOaUobr8KG Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlygyOYACgkQnvQgOdby QH3oDg//UC6AXS9gJu6fu+oLG0IzNRuY4ihPCug4pRV8ptM0X5RBC4e655UwDTDH hmya3hkynucKjHe0oz+bBAJwGPDhSEdcyl7c7LrQd8hzeBF4+tqlODfCcNN2k4ii vGPX7l5HLCX5td7/BzkVE+FuKbeJZzqo3FnOkLfUV3s1e+L2KoT58V9yIeACYGH0 Cev+z2zYJtPnmQZ8T+0dAn9bBorR3qaAkcJdaU9gcxKPJIHlaF1hkFk5CWAj/hg6 3knSXSqKFoZvuXf/opDuxmurqUOdKsam3tRpJ2hRO9lfejDhj0hmjPgewkDXCkPw ITVNYGCsWNsBbHDNfCuyGnEIQNktkgpIzNbZqTT1nak9XNkDJ8DIFYfrlOTS2aDw +FCzDXKwaUgBsTsRCPcaV3HCDg+D1qpHsFVr1pUzuZvE42C7qRF6mQefQQ50RKVi +sDoVu/nygLOamYBNJg/WEoiui3Zevktz3fiTz5/2TMzd9PJuVU/h4GYazjHYZsS YoYlyfIWzl91LshA+oSNur0fvsPn/p3mo5qDGrcorb03OUT4RBgp5sjG2IgYnAcP zjWZf3XpNXoUT/jqaGDE8Ree9Yu787jeviFgMTkd1TXyzuFGpR5xxTjHDmsNJ5t5 nWw2zwdW7nvs6cdFA7H74u42AGdVmJ2YW3QNe9NEJ1Zx/bW2rLM= =WH0L -----END PGP SIGNATURE----- --OgqxwSJOaUobr8KG--