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 1wAaJh-0006pT-2G for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Apr 2026 21:20:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wAaJf-002BZ1-2H for pgsql-hackers@arkaria.postgresql.org; Wed, 08 Apr 2026 21:20:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wAaJf-002BYp-1A for pgsql-hackers@lists.postgresql.org; Wed, 08 Apr 2026 21:20:04 +0000 Received: from mail-ot1-x334.google.com ([2607:f8b0:4864:20::334]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wAaJe-000000004KJ-0gdZ for pgsql-hackers@postgresql.org; Wed, 08 Apr 2026 21:20:04 +0000 Received: by mail-ot1-x334.google.com with SMTP id 46e09a7af769-7dbba5076c8so112299a34.0 for ; Wed, 08 Apr 2026 14:20:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775683200; x=1776288000; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=d0g7pMxxKvu8XeipbMu/4m+W7w6JfdWc8j9PmuObEyY=; b=UFsZR7O0V1PODBonQjUU0dPNJcSGfddkYyaldpvzGIXw6EbvTt0IZtQo4iYw5fvqAA o0igWOkTXmMJRMviSnvH9E8IfEBGiuqjq92CMfNbWlDwFk2NVe0Fu8lrw6Xz79kstPhK kboYw9WEAZaRfrlUZ/Ym+ekAIyStV60iw1Y+61Cv2gjvMRJWz2/X335SRpZMUyEbkmek BcnPaba8C7rivpV3FiW90zcmio+jZdWiSbJIn+0TtocdchW6eW71NO84OU6zPaw5/7lL r7Qamoy3FLCBLb0dbee74ZVMjndEvzN/LKRZGh6voWgsPoQOkYeQ8BGVKHjBmzwB2NVr QbDw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775683200; x=1776288000; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-gg:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=d0g7pMxxKvu8XeipbMu/4m+W7w6JfdWc8j9PmuObEyY=; b=helDuYXxHSaqtFX6z4Agmja7ZYA3EGjrMoKjDO+VC6AlLMl8oEpmYlcf4jI9GvKjJr nSuHUMMhJ8P2bjmUYgdoGItz8AtWuwUbQ7HR4jzEHaYcOUtQtmP6Jp1NLvU+EWpONNo1 aMne777DzIyYzEf6GFCSlIFDuCsKeSKvIyyB1EbDf1t/zBjSJ50jboA24oARqoOR1LrZ wGlVl8t+PJdQFldn8OtYczEAlGqE9ivC1MRQCXqfIzIWlyj3jeT0vhV0FEyOeeJEQ4Vi /mWvv/6R7Gh4fveCF7ntaAwRm2TGOhVMSrYVVFzUfnvnwKCVlm5tjyTvC7V6Lje0ZPVp +KCw== X-Forwarded-Encrypted: i=1; AJvYcCVeO9ypdlRSSKmb4AT4s2fPpZr7XFlRMZQu4C825oLLd9WI1z4+8+w8LbTV6A+vGwIKxraXSfbCboJRj25/@postgresql.org X-Gm-Message-State: AOJu0YxwUXWMUhnk71HWufm8nF18+hyzaW+j+M/V7SzphlOy93LkHDtY xPJcIMtWDCt0BvsJ1SkLcvq2sX1b/3BpLoIB/oWBnohDJHAtOf9folwb X-Gm-Gg: AeBDieuKOTzEz2d3y71p9vCcDBAAaYQJq/DuOUuYatCYFzlNb1PYj7hBgsNoV3scIp5 qYPHYBeCFCLn3XWMt65hXC4jSbrf63TWuKOfLn6R2aPm4LVWpksjB/PAKJQUeF+99uDsCC4K59P rqkCGmSNnNy59CAutZPXXShBC2ZE+L5TjpzKpOJbBSRVAkFD4V5EyJR2aFhCKGCWNQkIIEZZWrU Gc8wHpiBZRSrBqKQN7sv2ROSXKWEXcXf4HuwZBc+j3c8/6CXg2MF+eraEc/nu1n9+bkzbVa1vRs YLpMyGTWgtaCMH2sV+4Oe020qHJfps1zjQL3kwnYB3hSlHT5fZeY2ODpdjZjCSDv0CwwSPdtmCc 6h7wMZpBVZsx4FUQx1Q9EnajiC6eSkb0lBrljwXNMhIHgkOrPHqrd2ac0W8+L9HVIQ3eFVkHx/x cB1UbtdcrKbY/LIqpON2zblyvGIvx/NO2aEfQ9ZkCYhj252O8iTlJoF3efXuurv3RMTxmvR5CNy zxdGTQhs4BAxxwQV7JMJw== X-Received: by 2002:a05:6830:380b:b0:7d7:e831:a455 with SMTP id 46e09a7af769-7dbb75174bbmr13617634a34.18.1775683200062; Wed, 08 Apr 2026 14:20:00 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 46e09a7af769-7dba7159fd9sm14913845a34.7.2026.04.08.14.19.58 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 08 Apr 2026 14:19:59 -0700 (PDT) Date: Wed, 8 Apr 2026 16:19:57 -0500 From: Nathan Bossart To: Tom Lane Cc: Alexander Lakhin , Sami Imseih , Bharath Rupireddy , Robert Treat , satyanarlapuram@gmail.com, pgsql-hackers , tndrwang@gmail.com Subject: Re: Add pg_stat_autovacuum_priority Message-ID: References: <5684f479-858e-4c5d-b8f5-bcf05de1f909@gmail.com> <3077290.1775668665@sss.pgh.pa.us> <3097984.1775674400@sss.pgh.pa.us> <3101163.1775676098@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="UiApWdCMawwHIchR" Content-Disposition: inline In-Reply-To: <3101163.1775676098@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --UiApWdCMawwHIchR Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Wed, Apr 08, 2026 at 03:21:38PM -0400, Tom Lane wrote: > Nathan Bossart writes: >> FWIW that elog() shouldn't be emitting anything from the view, unless >> something is broken. > > [ looks again... ] Oh, you mean because pg_stat_get_autovacuum_scores > passes 0 for elevel instead of any of the valid elevel constants. > Can you say "undocumented cowboy hack"? I'd be happier if we added > something like "#define LOG_NEVER 0 /* Never emit this message */" > to elog.h and used that. Yeah... I should've done that originally. Here's a patch that I'll apply in the next day or so, barring objections. -- nathan --UiApWdCMawwHIchR Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename=0001-add-LOG_NEVER.patch