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 1h2Qao-0000e2-HS for pgsql-hackers@arkaria.postgresql.org; Sat, 09 Mar 2019 01:16:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h2Qan-0003IM-Ax for pgsql-hackers@arkaria.postgresql.org; Sat, 09 Mar 2019 01:16:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h2Qal-0003IF-CH for pgsql-hackers@lists.postgresql.org; Sat, 09 Mar 2019 01:16:01 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h2Qah-0002Ae-NO for pgsql-hackers@lists.postgresql.org; Sat, 09 Mar 2019 01:15:58 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id E033421C57; Fri, 8 Mar 2019 20:15:54 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Fri, 08 Mar 2019 20:15:54 -0500 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=noRrP3oAThZELPt0ZqSXzU/zIsg 7m62KCWJVsSZ75Qc=; b=A8r1vTLKx/pcvWXK8lb911OGS7dyCZ/agFy2tb3hFGB 6IZu9BSvfMceR4gB1S1svT5wME9Up1pe4DOttuj+ywKCWFT2REMmIltBQYVAac0w Y8KrZ+Dm92IWEuUs5XrCR9LANFNAJmYt52G1het0YixaLApB/Iv2cCGP3h13mZmV r49SbwpmiG2FGV8eCKBRZ6rcONO5PwPeOq6bmbVK7WYCcdoz18IPos9851UkpKnH r8oaOw12NTF3Ba5nmaRlNliQadXPwZA0ys3HuREACFDu7J58ITqbTnHDeiGIGyus quApTnPa+/mct48y/BRgN0O2n5QCh5LeAGECX0pGa6A== 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=noRrP3 oAThZELPt0ZqSXzU/zIsg7m62KCWJVsSZ75Qc=; b=jrOPm/mqO+4je0csc/Qqh1 1fb74H07ww6Sut1VMCN29s69gLbJ0xxyMWNFPSuchiUB5gx6NiTaoP/e+eK7KF5f UY4+3YiB1wJbFC70EAn80i62yc+ExYPy0JCWqbUTSW5ou8G7AL62+03mqnWiy8fy Pir16NEaKRZz/lGvHeGVXSy29BNW/ZeYySZGP6rHPY3/kyc/V/PCKjgtLQ5syx7y a21wwXqxs38oA/gvJC9T4+StPifE9fQzkHiyP++t4RuxmOG4fykZCeishOa+kj5W EHGuZdmrWm3FaFcNuUKDsK/UNbYu/LytCnqTYk+T4y6SviF8F+Y+JtKBduirZVNA == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedutddrgedugdefudcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvffukfhfgggtuggjsehgtderredttddv necuhfhrohhmpefoihgthhgrvghlucfrrghquhhivghruceomhhitghhrggvlhesphgrqh huihgvrhdrgiihiieqnecukfhppeduudekrddvgedurddvhedurddvtdenucfrrghrrghm pehmrghilhhfrhhomhepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiienucevlhhush htvghrufhiiigvpedt X-ME-Proxy: Received: from paquier.xyz (mp76f1fb14.ap.nuro.jp [118.241.251.20]) by mail.messagingengine.com (Postfix) with ESMTPA id 888EEE4383; Fri, 8 Mar 2019 20:15:49 -0500 (EST) Date: Sat, 9 Mar 2019 10:15:37 +0900 From: Michael Paquier To: Andrew Dunstan Cc: Kyotaro HORIGUCHI , sawada.mshk@gmail.com, tgl@sss.pgh.pa.us, alvherre@2ndquadrant.com, 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: <20190309011537.GD9266@paquier.xyz> References: <20181005031603.GF1629@paquier.xyz> <20181005063504.GB14664@paquier.xyz> <20181009.181536.142257785.horiguchi.kyotaro@lab.ntt.co.jp> <920b7f84-407c-005c-4b7d-e8266a17d22b@2ndQuadrant.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="pQhZXvAqiZgbeUkD" Content-Disposition: inline In-Reply-To: <920b7f84-407c-005c-4b7d-e8266a17d22b@2ndQuadrant.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --pQhZXvAqiZgbeUkD Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Fri, Mar 08, 2019 at 05:05:53PM -0500, Andrew Dunstan wrote: > I notice that this seems never to have been acted on. I think we should > apply this and remove the (confusing) message setting for the case we'll > now be avoiding. If not we should at least comment there that this is a > case we only expect to see in pathological cases. Sorry for dropping the ball, I would have assumed that Robert would handle it as he is at the origin of the introduction of the aggressive option via fd31cd26. + elog(DEBUG1, "relation %d has been vacuumd ocncurrently, skip", The proposed patch has two typos in two words. I am adding an open item about that. I think I could commit the patch, but I need to study it a bit more first. -- Michael --pQhZXvAqiZgbeUkD Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlyDE7kACgkQnvQgOdby QH1LHA//d+sORgwSaFd5JySFu49a3FeLQlmUMDZ7eOC7ylYX/cHnzhkgcko5oEwv va+UrFiditqOyL6CL5BCJQpj5RrMfeG1hmt1iAyRTUMolRvKSBnueELO0FL+yv+R Ijf6RPqTeriwwa9qrJDX1D3hdRdzMAwd6rtmyLrzfjaYgeuJPiiEc2xkUGHvFsIx jvYzF0fcO9+k40VV10E6m0V4IBPK36lkF0I3POgz5lnefCCCMoam5J9QpLBDb7r7 jMXm2cocgKsqYUq+gQOD/rJpU4LkPJ4TRZGoXKfFHbNybiOrf9YRlJXaofaReL5U EoM065tZcS83lwe8BSoGNfoN6We0vNnIolk9UeNnhLtm41L/dv6XYfUm7G8rrwPY X7m7ybYNv6L105JtC98UkmD/pko1Hj7wOinZaV9hDNuLT+7dLR+50BR6Ik25Fs0P MsCEQDUEI6OSjUkhOt2GLQ2LMFe1qff2WsOZW6mJRbufmBpC19Wjc3MEa/qPL7RF hSSqerYLrQS4Ms9Ok3mPje3v4nz5zRTkYd9qb/9Wz6hwG88r5OpmVwIdPnWpeOeF 4isvFkXsTsD7PO0+2D8SxSDnSs84kbXUbPR/Nm47qoImfrXjVpeaJd7aED119kD7 TTg62ynD5WdOAEraKDOdM8pRIMIjrgugJCet11y5H98QjndNK74= =0kZn -----END PGP SIGNATURE----- --pQhZXvAqiZgbeUkD--