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.94.2) (envelope-from ) id 1vCJPO-00BxS9-RR for pgsql-hackers@arkaria.postgresql.org; Fri, 24 Oct 2025 15:08:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vCJPN-00HNgN-4q for pgsql-hackers@arkaria.postgresql.org; Fri, 24 Oct 2025 15:08:48 +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.94.2) (envelope-from ) id 1vCJPM-00HNgF-Nt for pgsql-hackers@lists.postgresql.org; Fri, 24 Oct 2025 15:08:47 +0000 Received: from mail-il1-x131.google.com ([2607:f8b0:4864:20::131]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vCJPJ-003Ye0-27 for pgsql-hackers@postgresql.org; Fri, 24 Oct 2025 15:08:46 +0000 Received: by mail-il1-x131.google.com with SMTP id e9e14a558f8ab-430bf3b7608so21295605ab.3 for ; Fri, 24 Oct 2025 08:08:45 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761318525; x=1761923325; 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=0SqWMEz9oz6Oe9/Kngeclxx+pVBBMARoo9VI0ONnizw=; b=U5131VR4IW4Giyu+Yyw8f4vizrNKRaOrkszShsH8+cKzMBcMyYqpO+JgQuMlt2To45 vDnTPqYxsvB9hfSleFTnbHOhbVqsCmgJRwGktlF2bkvOsWK6JKhxj73OlG/6fVOrv3Zs h1FA8KdUloqFy1mgzBEhB/qbznklcPHS79bwqKJ4LyWIRct1wMPUUs00+Gsgabpt4G3R sNr6e71JG2mKCb6auuk8zqZeG6kyXGZ6bHdY94KXquuvIGWUeaAgnj2Hk1qHH4MNsrWK WIxUj8MozQWZoiNrO2LxtutB/LH/GQx74RqYTkf5WF5EeTJAJgHVsLUk4N3qsO3KW93f XdMw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761318525; x=1761923325; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=0SqWMEz9oz6Oe9/Kngeclxx+pVBBMARoo9VI0ONnizw=; b=sVpNRbU0oltM1YzwvMr9NYA8JFJgEhSPivVlfeumuXOnirOa014jVQcCk3aW2yoouk XlaQNjYNWZyK05UaPwm49Fu32PkPrPF6WaX+Ji2yIUC1HZBZ21RwP4xsrMvQbG0Be5Sa 98Bosesu195s4/zxjWYO1KhBe5k/GIkkwJQfSRGRVlRtyPxSuIMW54PuQFKJptDogpip kg3DBhGS9QGM/9Y44+fMNlBjLx37Vo4Vt81uTAdzRkZ23otHquUgXWhSvdJnEBIIIHBx GhlccoZznvp+RBTOpASFlMH5ksQw5MpdeB1BnfEzACZA4M13aontNVaPyfNjExrulzB9 09yA== X-Forwarded-Encrypted: i=1; AJvYcCUBcGL98jZ+WxfXV9NTZrI2WNqJgcGE9WjKyGBd1vbNzi5vWE3ceE6OJG83jT1e/sqd7rCYU4596gLoWsev@postgresql.org X-Gm-Message-State: AOJu0Ywndf+RXU8VXLhyPO8GMHJyFwznlDt0aVIWLf/T2HISiMVosNON cQTaxNgzcvDubjRzrbv/Ywg+4IR3mPlIwYZMYO7YtXGm0b7rsCt9UJub X-Gm-Gg: ASbGncu3ynRzG5XL00LTvwmQrJsd5AZekd/Qdr9Q4dIH3N4rxWRoNVjiOUHsrJguVy7 fFsaNa28gkoMLsc592VsGXOz6r9ZUsRt6jN9oEKglYqlw0xtg0BIA/YEmCXJtpO9GkpvRDloTeb 4exZMw1cUDvdSUDt5Q7zuSdsKO3VZWo6XVNH0I3CEyF5nOu5KneZ1uCi9dLzyIhSnYUNWCSEKRe +5NVAsH3KsNsxKKFDNHJQG0eG3pCVt+ip8XtitabrDo7nlXBnkcAfaIg3dN6WzzF1tKKXev8jzP 7QSrNKk3ND16qWMtakgGLE1ikaa5yO4GA2zJZxA+0baGcEY1bU5PH6XhMevNDA88qoppk9Ihtz/ 1ONcLoTTLxc0enGxoSCY0axHw0jmDmCm7SOv76/1E4qLQOhQQsqEHr3E8ar9Kqyr9Y5hBoUc951 eYwg4N2m3E9oyIrxPPGCJMMEvM7qkhUAq/fAFhlAxJGr1aTWcc0ADN4+XDWtYdHTwjk4seCZrT1 2ur X-Google-Smtp-Source: AGHT+IGr1DEV1SJHHcIv9mpQsQgNNe6J9cYDHA7J0JglJivlXIWtOI+gV51n71SmW1xCSKOXC7ICeg== X-Received: by 2002:a05:6e02:16c5:b0:430:b7c4:6617 with SMTP id e9e14a558f8ab-430c527bc80mr411655845ab.15.1761318524867; Fri, 24 Oct 2025 08:08:44 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-5abb5835db2sm2208086173.29.2025.10.24.08.08.44 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 24 Oct 2025 08:08:44 -0700 (PDT) Date: Fri, 24 Oct 2025 10:08:42 -0500 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="xmBCfiLlsDtO4qW+" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --xmBCfiLlsDtO4qW+ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Here is an updated patch based on the latest discussion. -- nathan --xmBCfiLlsDtO4qW+ Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename=v4-0001-autovacuum-scheduling-improvements.patch