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 <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1vIuOb-002KQF-0T
	for pgsql-hackers@arkaria.postgresql.org;
	Tue, 11 Nov 2025 19:51:15 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1vIuOY-007S2c-2e
	for pgsql-hackers@arkaria.postgresql.org;
	Tue, 11 Nov 2025 19:51:14 +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 <pgsql@xzilla.net>)
	id 1vIuOY-007S2T-1h
	for pgsql-hackers@lists.postgresql.org;
	Tue, 11 Nov 2025 19:51:14 +0000
Received: from mail-ua1-x92c.google.com ([2607:f8b0:4864:20::92c])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.96)
	(envelope-from <pgsql@xzilla.net>)
	id 1vIuOT-007D3Z-0J
	for pgsql-hackers@postgresql.org;
	Tue, 11 Nov 2025 19:51:14 +0000
Received: by mail-ua1-x92c.google.com with SMTP id
 a1e0cc1a2514c-93539c5e2b5so11246241.0
        for <pgsql-hackers@postgresql.org>;
 Tue, 11 Nov 2025 11:51:08 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=xzilla-net.20230601.gappssmtp.com; s=20230601; t=1762890667;
 x=1763495467; darn=postgresql.org;
        h=content-transfer-encoding:cc:to:subject:message-id:date:from
         :in-reply-to:references:mime-version:from:to:cc:subject:date
         :message-id:reply-to;
        bh=EHFA8hbgeH9+GJKy9StAFT4/bfaY7duYLQnBoCA2Wko=;
        b=Id47QhrN932kZBVjPtUyysLRFmbolUavNzEWLa70/SLxzPcljoVi19e/Tpbm3lpYfo
         TBFG51OTM86iA28ar2GzxHNvnSuIR8wHHLp0sO7MOWTpTKgoTyeDNaio/iLa/4ryBODO
         v2I+BSQ8KzpfauG/KHh7Vk/ZND1QK9E2cD6r16QN1NNO1IDfJqYr2a3HrtcMIZ/pY/iP
         hJMSsXQNtmV6mhCSx/azMf7z3ARWa3cOgotxTb9gtPOEEqjJiYTRCBzMX5yQLPSth6h/
         bJg3bOFqim47fKjiTJevTD7Ht2lf+kwn02oZwBOsXhIGQu0kQE9TclEV/nSc4EmxSePl
         p0FQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1762890667; x=1763495467;
        h=content-transfer-encoding:cc:to:subject:message-id:date:from
         :in-reply-to:references:mime-version:x-gm-gg:x-gm-message-state:from
         :to:cc:subject:date:message-id:reply-to;
        bh=EHFA8hbgeH9+GJKy9StAFT4/bfaY7duYLQnBoCA2Wko=;
        b=XJqYmwLXDIm7bRczYHSdjC/6sLVztB5ZVzNj1py9TuUy8xdtB009pgXWYX/aiyU64Q
         KerwX65WkA7Fpihvt7fYy2z5jWKZkT/J58QoT6L4Lb1KozqhABOyCFSEGrgBYTsBOfKV
         Ojppv7Q+4i+VnjM/+omi2keYEjQ4zyeewkQAsQAUD0Y4ytwru8OIgpviWxPTYkBFjc3d
         V/7n2Yax8ZWK+6UGVRbmIocxm5lRaIlxHlS5qIXTGfBoCIecw+r4I4bEB2gD1s8LMv18
         bFJ/w8bmhZDSNVGl4P1aH7zO08xt4xV8esZe77z/a+FJrwYgASYVmog5clNrngZC/y0j
         qY3A==
X-Forwarded-Encrypted: i=1;
 AJvYcCWH7Lt6C0su4OosnbvidXGAXeEAmbYzRM/T2uBC/j3ukdSFAw6bKSSY9/jXwmJPrChHCUxIAb+Fz6vS38Ip@postgresql.org
X-Gm-Message-State: AOJu0YyqS3NcYS5zjNInVdxs7VFKnOb/zqsAtqhzj/QdERfpWHOKcpyo
	Jp0quV7xYnWz2JR1Ldi6lMPmOLmhNatD66hVwHMCCRfhTC+1d+vyb7B9PMiOprxXDLsnNyzdzuc
	zCGw9FdhVdnW9fc05rasV8qIggCvmw6YG12AR0+EPbw==
X-Gm-Gg: ASbGncsCoFKYxWO/aEGv3lxq/Z3lGIK5WMa61IK0xWhgIZXik00/THBj18WtkUAdlBU
	vPtrQFaPucu4DeuubS1GxBYjr4usbdtzTmzaymC/o+Hw5yty1lI++o0c4XY2ErZewCzztZ6Hfku
	Flkc0mvA5FIPf3JlqhBKIfilo2akn9d+S1iKE3FiAIU/9hTfZyATyJH4o+3VVWbXO2YmeBQDWvv
	rD0+2DmLZP8WKoxTvwU80CmVc5b3XtUQQqZI0NsXlHG12gqDSrZIuFy7TId
X-Google-Smtp-Source: 
 AGHT+IFxqM1RERbfvDqJQaNVZL2FCw0rgDDs9iR4ygzHhTlb1IPjRukrpnNnb7RTxrZqMjr+/5f6TSGKui64FM9KJ+E=
X-Received: by 2002:a05:6102:5092:b0:5b8:e08f:eb38 with SMTP id
 ada2fe7eead31-5ddf3edcd87mr1688098137.14.1762890667006; Tue, 11 Nov 2025
 11:51:07 -0800 (PST)
MIME-Version: 1.0
References: 
 <CAA5RZ0tpV3PRHejTGG5-LSsqNKKV0qP=SDvurs8wj7pTk7jYJw@mail.gmail.com>
 <aQUYP1WjrEP3buQz@nathan>
 <CAApHDvqe7ee=vobWe4GVAt2gm_H6eiGNZeo_dEMptvHYAkibBA@mail.gmail.com>
 <CAApHDvoCFQxaQjUncTAtCRFAeANe2tpc-WCkJue=FaXRYOkV=Q@mail.gmail.com>
 <CAA5RZ0sw+9rEaW9taNpRZWvuLYMjRa9iibneGfB2ftNSUHT0Ww@mail.gmail.com>
 <CAApHDvq_j+GVqX_ZAmvn236Mgg5OYQ6_s9kVsyoo1tJa2RJ=2w@mail.gmail.com>
 <CAA5RZ0udjEYJupob5tv3286e28bMpajgsy+4nAbxg73YyigZFw@mail.gmail.com>
 <CAApHDvq9ecYSetXUhjMc7E_Jcc7gxxRkA0LosX9PP1-jM_Ak8A@mail.gmail.com>
 <aRNmEPQ18qZlLowV@nathan>
 <CABV9wwM_Q9+-AXga=t=RPXMYHRNoRK_UEqXy-Q8_=WcOjJ=iAw@mail.gmail.com>
 <aROTJV90-PUY1OZj@nathan>
In-Reply-To: <aROTJV90-PUY1OZj@nathan>
From: Robert Treat <rob@xzilla.net>
Date: Tue, 11 Nov 2025 14:50:55 -0500
X-Gm-Features: AWmQ_bkkunOls1ucWJSa6rFJPAGdxphPXfSiujgYNWWhaVD15H8amGbjqi0Wrcs
Message-ID: 
 <CABV9wwP1TjLk4ZKuf4s0r_HWtny+ZK4DQr2BUFnUseQPwx5P9w@mail.gmail.com>
Subject: Re: another autovacuum scheduling thread
To: Nathan Bossart <nathandbossart@gmail.com>
Cc: David Rowley <dgrowleyml@gmail.com>, Sami Imseih <samimseih@gmail.com>,
	Robert Haas <robertmhaas@gmail.com>,
 Jeremy Schneider <schneider@ardentperf.com>,
	pgsql-hackers@postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Archived-At: 
 <https://www.postgresql.org/message-id/CABV9wwP1TjLk4ZKuf4s0r_HWtny%2BZK4DQr2BUFnUseQPwx5P9w%40mail.gmail.com>
Precedence: bulk

On Tue, Nov 11, 2025 at 2:49=E2=80=AFPM Nathan Bossart <nathandbossart@gmai=
l.com> wrote:
> On Tue, Nov 11, 2025 at 02:43:19PM -0500, Robert Treat wrote:
> > FWIW, when I have built these types of systems in the past, and when I
> > wanted an aggressive recheck-type mechanism, the most common methods
> > involved tying it to autovacuum_max_workers.
>
> Would you mind elaborating on this point?  Do you mean that you'd rebuild
> the list every a_m_w tables, or something else?
>

Yes.


Robert Treat
https://xzilla.net