Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g7bkz-0002O4-LW for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Oct 2018 07:39: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 1g7bky-0004AI-7f for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Oct 2018 07:39:40 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g7bkx-000499-QT for pgsql-hackers@lists.postgresql.org; Wed, 03 Oct 2018 07:39:40 +0000 Received: from mail-ed1-x541.google.com ([2a00:1450:4864:20::541]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1g7bkv-0002RG-53 for pgsql-hackers@lists.postgresql.org; Wed, 03 Oct 2018 07:39:38 +0000 Received: by mail-ed1-x541.google.com with SMTP id c22-v6so4412358edc.4 for ; Wed, 03 Oct 2018 00:39:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=uECk4SPHZ980tLFzSvahIEDSD6ymktMcj7iRrG/NKHo=; b=EQpTwepepZQgAwkA3c+Nw3vImAeLQDk/BWPwdRCH/jobgrXNZY+GRj5QOP3ERaqmuy 4z745Wm8S92GOZ7W+IUbL5tICnOgOBmiCqWJaavwsPB9/BxzKQCO6rx522qIGTmNqH/Q 6epcwxCxfOlZAw3THba0E5iSTe1nr0K9orHgz/4GLPcIEUmWbelO0qnKa/ERYAM/mT4Y Nh0ZQ2weKW9v1Fu8rCVGMfqcZHO/pXpQVJU4mdb+obueWzU12Fne32B/YbMow6CTkEJQ 5Xzp0YGGL1Ciqv78IdaE7LSRZzn8BwJqA6htJg1zHLneaf4suRHjSTD299kFUG0mGpzQ HK+g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=uECk4SPHZ980tLFzSvahIEDSD6ymktMcj7iRrG/NKHo=; b=LhmoGCcFUhXrrFnRAfguj52u/3UxbWyXH/+MhkMZvzbk2cSCJjwe3KuG3BwpdT0hrj /yMKzb9EAy+M8EnRXVB7ANmMFkAUsDmxFynnyNL+wzv5B66eWAVOS8XNtgnUS/7VUytH SSJXiC2MtcM8lldoUIvaQGyosKIS6UbpJCrxiBf0qVswMpoQZgBnAUUTIdzXzs/82kJI MX2jC8WYl37Nifq+4+OMscrpeqKmljPeicv4CkSDLkavgDm9hK/gx7ZZ+l0LbhP0fAAG a8h8GMj39GYpRYHQV2Ddk6DbwiGxeqsfiA4nwbFkKRqFpSXMZUUz1gS0u2g5xmBXjHcs oD9Q== X-Gm-Message-State: ABuFfoiFsjFRejGYjhQjeDEotVnJDRiDgyeDmXJ1k9bzx+g6NNjrynCZ v0pkIu7GvmgYUrpYiMfDV0tZMQ3Ts+HferJYnWc= X-Google-Smtp-Source: ACcGV63XI027DZKm1QMQtYslqHgRgkTda2xqCf6RabHihplMW8qs9l4jd50KECFQarbmNqbAdKJlRmII6XCiFP6FSq0= X-Received: by 2002:a17:906:4946:: with SMTP id f6-v6mr644150ejt.129.1538552374864; Wed, 03 Oct 2018 00:39:34 -0700 (PDT) MIME-Version: 1.0 References: <23209391537822541@iva4-6d7004ac8463.qloud-c.yandex.net> <20180924211117.tpwxemzd3372nagj@alvherre.pgsql> <20181002001151.GP11712@paquier.xyz> <20181002065508.GC17642@paquier.xyz> <338.1538489728@sss.pgh.pa.us> In-Reply-To: <338.1538489728@sss.pgh.pa.us> From: Masahiko Sawada Date: Wed, 3 Oct 2018 16:37:29 +0900 Message-ID: Subject: Re: pgsql: Improve autovacuum logging for aggressive and anti-wraparound ru To: Tom Lane Cc: Michael Paquier , Alvaro Herrera , Sergei Kornilov , nasbyj@amazon.com, Andres Freund , Robert Haas , PostgreSQL Hackers Content-Type: multipart/mixed; boundary="000000000000c5c94e05774e230b" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000c5c94e05774e230b Content-Type: text/plain; charset="UTF-8" On Tue, Oct 2, 2018 at 11:15 PM Tom Lane wrote: > > Michael Paquier writes: > > My brain is rather fried for the rest of the day... But we could just > > be looking at using USE_ASSERT_CHECKING. Thoughts from other are > > welcome. > > I'd go with folding the condition into a plain Assert. Then it's > obvious that no code is added in a non-assert build. I can see that > some cases might be so complicated that that isn't nice, but this > case doesn't seem to qualify. > Thank you for the comment. Attached the updated patch. Regards, -- Masahiko Sawada NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center --000000000000c5c94e05774e230b Content-Type: application/octet-stream; name="fix_autovacuum_log_v2.patch" Content-Disposition: attachment; filename="fix_autovacuum_log_v2.patch" Content-Transfer-Encoding: base64 Content-ID: X-Attachment-Id: f_jmsua38z0 ZGlmZiAtLWdpdCBhL3NyYy9iYWNrZW5kL2NvbW1hbmRzL3ZhY3V1bWxhenkuYyBiL3NyYy9iYWNr ZW5kL2NvbW1hbmRzL3ZhY3V1bWxhenkuYwppbmRleCA4OTk2ZDM2Li43NjlmZDBlIDEwMDY0NAot LS0gYS9zcmMvYmFja2VuZC9jb21tYW5kcy92YWN1dW1sYXp5LmMKKysrIGIvc3JjL2JhY2tlbmQv Y29tbWFuZHMvdmFjdXVtbGF6eS5jCkBAIC0yNDksNiArMjQ5LDEwIEBAIGxhenlfdmFjdXVtX3Jl bChSZWxhdGlvbiBvbmVyZWwsIGludCBvcHRpb25zLCBWYWN1dW1QYXJhbXMgKnBhcmFtcywKIAlp ZiAob3B0aW9ucyAmIFZBQ09QVF9ESVNBQkxFX1BBR0VfU0tJUFBJTkcpCiAJCWFnZ3Jlc3NpdmUg PSB0cnVlOwogCisJLyogU2FuaXR5IGNoZWNrOiBhbiBhbnRpLXdyYXBhcm91bmQgdmFjdXVtIG11 c3QgYmUgYW4gYWdncmVzc2l2ZSB2YWN1dW0gKi8KKwlpZiAocGFyYW1zLT5pc193cmFwYXJvdW5k KQorCQlBc3NlcnQoYWdncmVzc2l2ZSk7CisKIAl2YWNyZWxzdGF0cyA9IChMVlJlbFN0YXRzICop IHBhbGxvYzAoc2l6ZW9mKExWUmVsU3RhdHMpKTsKIAogCXZhY3JlbHN0YXRzLT5vbGRfcmVsX3Bh Z2VzID0gb25lcmVsLT5yZF9yZWwtPnJlbHBhZ2VzOwpAQCAtMzc2LDEwICszODAsOCBAQCBsYXp5 X3ZhY3V1bV9yZWwoUmVsYXRpb24gb25lcmVsLCBpbnQgb3B0aW9ucywgVmFjdXVtUGFyYW1zICpw YXJhbXMsCiAJCQlpbml0U3RyaW5nSW5mbygmYnVmKTsKIAkJCWlmIChwYXJhbXMtPmlzX3dyYXBh cm91bmQpCiAJCQl7Ci0JCQkJaWYgKGFnZ3Jlc3NpdmUpCi0JCQkJCW1zZ2ZtdCA9IF8oImF1dG9t YXRpYyBhZ2dyZXNzaXZlIHZhY3V1bSB0byBwcmV2ZW50IHdyYXBhcm91bmQgb2YgdGFibGUgXCIl cy4lcy4lc1wiOiBpbmRleCBzY2FuczogJWRcbiIpOwotCQkJCWVsc2UKLQkJCQkJbXNnZm10ID0g XygiYXV0b21hdGljIHZhY3V1bSB0byBwcmV2ZW50IHdyYXBhcm91bmQgb2YgdGFibGUgXCIlcy4l cy4lc1wiOiBpbmRleCBzY2FuczogJWRcbiIpOworCQkJCS8qIGF1dG92YWN1dW0gY2Fubm90IGJl IGFudGktd3JhcGFyb3VuZCBhbmQgbm90IGFnZ3Jlc3NpdmUgdmFjdXVtICovCisJCQkJbXNnZm10 ID0gXygiYXV0b21hdGljIGFnZ3Jlc3NpdmUgdmFjdXVtIHRvIHByZXZlbnQgd3JhcGFyb3VuZCBv ZiB0YWJsZSBcIiVzLiVzLiVzXCI6IGluZGV4IHNjYW5zOiAlZFxuIik7CiAJCQl9CiAJCQllbHNl CiAJCQl7Cg== --000000000000c5c94e05774e230b--