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 1vIrMH-00HVOz-0n for pgsql-hackers@arkaria.postgresql.org; Tue, 11 Nov 2025 16:36:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vIrME-006zI5-32 for pgsql-hackers@arkaria.postgresql.org; Tue, 11 Nov 2025 16:36:38 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vIrME-006zHx-1F for pgsql-hackers@lists.postgresql.org; Tue, 11 Nov 2025 16:36:38 +0000 Received: from mail-io1-xd2c.google.com ([2607:f8b0:4864:20::d2c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vIrMC-006Zo0-0i for pgsql-hackers@postgresql.org; Tue, 11 Nov 2025 16:36:37 +0000 Received: by mail-io1-xd2c.google.com with SMTP id ca18e2360f4ac-93e7e87c21bso219025839f.3 for ; Tue, 11 Nov 2025 08:36:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1762878995; x=1763483795; 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=6XOFni1zi+XWK7eXNnL9E/f733lRphPkO8XKp3gxTcU=; b=BGORS4U0ycG656pij4Qs9bTp9nba9HQfzxO0yFl7DoCUmyxBn4Hyz6Fd+kAYr064wL fyLL8bboyh5aJG3UaEoGQKwcOSGvtwj05vNWKfNyGKOXGM10J26KUfxDu+8+kqwsfH7k nPNsjKKUpLwgGMIheD4TwrAQJuFxYlK8ChDsEgZL+C3YghTjCdgZ425AlHZleYnbR9jy 10QNkRn8dnHX96ppKDnbcmGtQwb8ZqyHRdcrBOasZCRz9aKYz0QM03oWEm41f1vgDbDJ xM/9GtDETD6rWZebNDQ+Ev/dOGwzSjl6S07igAvF1j2kDh7xERD++xlk+0hO4qLrMwKD F57g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1762878995; x=1763483795; 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=6XOFni1zi+XWK7eXNnL9E/f733lRphPkO8XKp3gxTcU=; b=wnpfSPJUUHj3Rbavs7V8TUfzq3C5C+AzePqxaF9lAfWacNiDB1hxSzUzEsuXPGXfed ziWCMqZDmarSAi95LYjwppe604gQxEFj18C7WetWA042vN+vTcx2nuUL15FeENOhxsDR ZiUFAGv2SfsTfASRyASECLQV8LUi2DR24Uwrhgahs+ApJAl8KSqtgVmwB5GYhZbaeEn/ 9mjsPicgyHpQyLg+bWYdaMFqylH0b+lLEsRJf8cNGtHsI2CsTSbV5o9/1E93WuIp109N XDq/mBKDpcdp7NQRJ284u77Cm4rDAsQtEhkkoiQ72iaimafnHQlnCc5MeV1jQIbM8bYf OsBg== X-Forwarded-Encrypted: i=1; AJvYcCXpU38FR+1e077ZgwI8IW5xabLBs3NuEBTRVX3W5+iTNawBmqlJTOBi/3GAKjMCDsOxTfeGqLAOmaxK/JUE@postgresql.org X-Gm-Message-State: AOJu0YxQzM+/Q5AHGrbxbxoarZDJANjVXPgstZ/VBnHCuPZbfDJ33vDW G737cjEZ6StvzqpOGVv96/LFfkBq8IVYBtwTf2f6Gfo8qD0eMnnqj2aq X-Gm-Gg: ASbGncv4zsRNCMxz80FjeMSL0o9EyGR6uBbez3T7GmaDYl9yNCKBm7O0KZuTEW0EvFq Y/M8LfH3R+Qr4w2OBGQjQxYxmBMC3vsjWU8RKcQrLcS+JP5Y0TNGhrbHqr6xurdVM3UOD8E7b6z TSn1KqDtxAWWLl1o2kmcgxPIpxMUSvrno1R92UEABNYsi+ZwgqS9T6IXJhyBZ7MFYKEIo7PhMO5 YkXepZoNiQwy+9uc9h3wLRFGDzqQo8DR1potGCaa3ZNgUApdD2XPNKt+1iO15s2+QsCd5ovVfpH t8gutkGqa9zUHynkO65lFwGk8zMhoXxiCmrihxSfcDa6ddC98ngOwQRGKUn1qVRLckRU9eiKj9x OFqFbmUluq7wgC3Xrn92MFUxwZhWAO7peHxCEJuzCEU/aKCLU4UyvzPzPubomarvbfwLRen+FeH 5QzaJcCM3tmpbnllGaKOafZoTq1dtGWzW19MiAY5/4dlO1tjnp5w6PvzAofJT4cqIgMQ== X-Google-Smtp-Source: AGHT+IGefaZx08TncmFhJ/l/hnCCOC2fJkQROC58R1xozB8+JLe6VMJutnS9/06620k6q7V0ECMyhg== X-Received: by 2002:a05:6602:6087:b0:887:638a:29b5 with SMTP id ca18e2360f4ac-9489602c03cmr1577359539f.9.1762878995238; Tue, 11 Nov 2025 08:36:35 -0800 (PST) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-5b7ab104fa6sm46067173.42.2025.11.11.08.36.34 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 11 Nov 2025 08:36:34 -0800 (PST) Date: Tue, 11 Nov 2025 10:36:32 -0600 From: Nathan Bossart To: David Rowley Cc: Sami Imseih , Robert Haas , Jeremy Schneider , pgsql-hackers@postgresql.org Subject: Re: another autovacuum scheduling thread Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="+ojkLxiwPo1IFxfN" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --+ojkLxiwPo1IFxfN Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Still catching up on the latest discussion, but here's a v8 patch that amends the DEBUG3 in relation_needs_vacanalyze() to also log the score. I might attempt to add some sort of brief documentation about autovacuum prioritization next.