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 1wArEl-000T4B-11 for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Apr 2026 15:24:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wArEj-006Nuh-1Z for pgsql-hackers@arkaria.postgresql.org; Thu, 09 Apr 2026 15:24:06 +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 1wArEj-006NuY-0h for pgsql-hackers@lists.postgresql.org; Thu, 09 Apr 2026 15:24:06 +0000 Received: from mail-oa1-x2f.google.com ([2001:4860:4864:20::2f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wArEi-00000000CYE-0jPf for pgsql-hackers@postgresql.org; Thu, 09 Apr 2026 15:24:05 +0000 Received: by mail-oa1-x2f.google.com with SMTP id 586e51a60fabf-40ede943bf0so640193fac.2 for ; Thu, 09 Apr 2026 08:24:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1775748242; x=1776353042; 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=mcruk2N7gHjvqKpPzZx96pfU1rl74ZE9tX6NHEj5pOA=; b=Cnb8r5Vzqch6orRvdpZO+htSEuTRpjVbIXkQTFSUlFv5eIEwABOIKsZNMK9Z9Qyiia tOy9kXkvQSSvZ1RQzM1nAdKNUAe80Q8bMy3Q9JFfiHKmDQ9LmSFQKHnTNdBQiuP/tkZx iIIzLO1urt87m7P4iu8mafCz84rN/wjRd4DDJVxn7Ss4UMu7wjA3heECjKlfT9CTPBDH ZDMgT6bkTb2oaYAEvwAnCwXFOg36i9h3gf6ld3t9x0yNc57sthj/ZSukkLJ93CZtjNEs 2i4f7ALs138I8fPh8tn7vIZUDd6gJOLqbpEsM3ZYg6itwM3+PR/t3u9/xfLpDclDknyT y53g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1775748242; x=1776353042; 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=mcruk2N7gHjvqKpPzZx96pfU1rl74ZE9tX6NHEj5pOA=; b=eDUumxl2Uebe/rUvFXckgYEHPQ8iVA27cEZ9n4PFiQyFGnKQLtwZImFikQknvI2d62 JyzFOK0uEyivOS7qsTUU7JU5eQGcBamP71SthWha7zrU6tDDDZuOSyOGk2ipt7voy0z4 YrwzstWcSFl8BC/jNiT7DTa0PQhoPmH0UT8tYj4Y06NU+wLRpRcn+mVoCLqF2lTA80eC 5Sp1wiVZ4JWfwnWVz2Amxg4SSPuRsTqifTaE2rCpAAoqxjz9vREN9rRr5cJn4jYF7y+H JNV40eJkNrAOPxYfeBq8ZUGbWaHNjKAp9p0iDcEQ7oLiOQQsjBaabHnf1RH/cniGYeJU ctUQ== X-Forwarded-Encrypted: i=1; AJvYcCXn4KhElB1KA1OA1QN5x8uZrA2MYxtwJPcxgtlEZsJl1ckGV3HCO9BM0F1yBUMyAa1fu/i0HBjXhOS5N3MU@postgresql.org X-Gm-Message-State: AOJu0YzAgDGpolwq0tt6OCO3Ise6FWu79PUfZCvqUaeTl8AIAKbmXLsL mlGY+mJKtQqNsZdWX3JCRVrl+esBgOIt14uaJfMZptSxpHENrdMjsQB7 X-Gm-Gg: AeBDieuMjy8Cf+jRIxklIGafTYB1OmNY6DInsJ+3TX5soheCB9LLd3lENyK29eAarr7 B/gniVaakMFh+vZr010k4q1Bi9lxs/t7bEfbso/cYn/rYEZ9Aq+IN9iVJbRkrujU2c21K36wg14 lVF3ZQYejV30lY2w0t42SxFKYz2LDWaDUZR+AV+NSwBMHETTwdVKodefDiRGomABiQ66AACibKD EETApF1yI8q3m783bbFngBvN0OCJ+5yRCKSA1nRwKvxGP3ET8iolW8HptFsf758lOZ5cjNrgT/V uUrgGd1UMLHks/imO0hbBIwW172K6mgQFppjjZ8TB8QHIhqlavVejkeiTY+fOl3bb/u4WHeRha7 hJKebtPcfGS5SfnXXDkLV4191/fDe9V9pfXezi9M4mAQhKzxKLiyy4TB8CvxALs0iz0EHCEYqk7 ucn99mce8UIJlpcjILl2znPGk0qrc2PO/x+tfZIj8GYVU2G4dkol6tJFAOGB6sNC9B/RqGx1Dy3 mwe6295+Eh6ZqCjapK+yg== X-Received: by 2002:a05:6871:780b:b0:423:29e1:909d with SMTP id 586e51a60fabf-423bdb1307dmr2286500fac.23.1775748242089; Thu, 09 Apr 2026 08:24:02 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 586e51a60fabf-4232eb3d0e4sm14739205fac.6.2026.04.09.08.24.00 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 09 Apr 2026 08:24:00 -0700 (PDT) Date: Thu, 9 Apr 2026 10:23:59 -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: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, Apr 08, 2026 at 04:19:57PM -0500, Nathan Bossart wrote: > 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. Committed. Working on Sami's patch next. -- nathan