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 1w3gVO-001S9y-2t for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Mar 2026 20:31:39 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w3gVN-008DmY-1R for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Mar 2026 20:31:37 +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 1w3gVM-008DmP-2t for pgsql-hackers@lists.postgresql.org; Fri, 20 Mar 2026 20:31:37 +0000 Received: from mail-ot1-x32f.google.com ([2607:f8b0:4864:20::32f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w3gVJ-00000000DzP-3uZT for pgsql-hackers@postgresql.org; Fri, 20 Mar 2026 20:31:36 +0000 Received: by mail-ot1-x32f.google.com with SMTP id 46e09a7af769-7d4be94eeacso2464007a34.2 for ; Fri, 20 Mar 2026 13:31:33 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1774038693; x=1774643493; 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=bZ63o2E3QTov0LvmaadYFrdzs59wGxQA8s8OmNRBKic=; b=AiVVDSC0+PjKbMAbD1p/5jyXcvux439kqWQib0hEiO/ozsNPOLB9pjrUJKdI9Hu9O+ Ujr+OtwGwbC/mbJSo7LOm91IM5svUrDU5b7kdKbl6acAfs3p/qWwMK0qoB3FZn3ECif1 nV/as3JRgCvHZSbvR5uE3UkzwE67h6H2u0306mAR8rxsg6lxhiDru1H+YjCBGBQ8L8ry V+VFY8KVujYSQRzdkezL2z77ni1zT7ahiiCY9n43KgiCULdS0Rlcz8cUkyJDASihFNim YjbfQFsjNco6vG/WppfMTK2hwIv8ZWo6NaSCjqyeijSclKwPg4M4Ppv1PKFwaGxxs1FN cKhg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774038693; x=1774643493; 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=bZ63o2E3QTov0LvmaadYFrdzs59wGxQA8s8OmNRBKic=; b=BdpY+PltB1MfBqtaSUj2m4tWiRBvSYnOqi5/jGN8yPv1JC3jMHCPFsIm1ESITqgYg+ 7NaNci1IwJYdsJPTnnpdAdB0CIXarHklCKqvgrSNOfwTX9FtC+pbIMSkZ0HKhKEzwqyd XweGUyrl35Vr1JB9t5iqz6k+7lhHJf9rQRoAPWJR6QP0448EYRSEsTTvKIlvSndTlH+q HFhRQDoRXxfUSHicMZWgny14ETbJTxghM5Q5wC4AT0f6Z3EUWjNNO7nIXsRsYT0HxLeP P6W3v1mWrJuMp5bYzf3mVE3tarVTwqSLe7TomvL9I+du65jO1nU56ZkdctzZUOpXLzJt aKjQ== X-Forwarded-Encrypted: i=1; AJvYcCVSs8ejodZxl9MuQBV9WItJJk9zUVLuW/6QX7ByTUUVMura0eWd7qm3PCVkQklQyWHxhXA9SAJgj8mea1L8@postgresql.org X-Gm-Message-State: AOJu0YzeXAWtIKV3PMVn4Ht27O6aN794qmrzIs1GngWs4rgrtXDipJ1P WqvCpsdKlHDUycIQPpxsOZ71yX3pXEuytDx0GyEkDwffPIaWqZ/ldlVe X-Gm-Gg: ATEYQzzxvbPJqVq3sNEaiYpAofnCCk4Mm9HLCkxQGs6peeo3OkOTqV1gQibGIz/7XPN bvj9KTKqGlQoqjV2orToNKE62j7b5DWD4f9/4WEzYOxBLzCO38llI3XzKe6LDeyvDiRekCHdM+y FTqkSh+6Pv4M3Z87ugvhNKBcoxuZLA8fCHZ38pXadA31+53o60X2na+tGrsSN4k4EyZaXy/MaLt 1VvR9k5Nu1ZmYOW5BVex/LBL8d6W87CQ1/MKNrRIfYmSLTH43OXu14veRDkHBd3Ma9Uepf9bG2w /zV3NVRXFFg7gbKZYfNKDVnD9U/1ImifGW10eJOGJEGxbL6m+hnrQMv8IoqPpjXcqA1fUaFB8wI Ya1TMJtjdnZuuiXlcfz7lKDt6KAr7gXGJBalSmthrPdPIiCbJmB3IZP85Kn2ip9bSTAr7xXsGTn 6E/H0H2VLu1oDr4HFgSu3aWNd3Vmv1+UW17+SGLUsDE8Z/Zfq9qcZnb1//p4ZCO2xPl630FE9zu R8BoV33OmdylGMH+rppYQ== X-Received: by 2002:a05:6830:6d28:b0:7d7:cc2f:babb with SMTP id 46e09a7af769-7d7eae42752mr2805666a34.2.1774038693234; Fri, 20 Mar 2026 13:31:33 -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-41c148a5f99sm3191805fac.2.2026.03.20.13.31.31 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 20 Mar 2026 13:31:31 -0700 (PDT) Date: Fri, 20 Mar 2026 15:31:30 -0500 From: Nathan Bossart To: Sami Imseih Cc: David Rowley , Greg Burd , Robert Haas , Robert Treat , Jeremy Schneider , pgsql-hackers Subject: Re: another autovacuum scheduling thread Message-ID: References: <3ca1e398-c787-47e9-9afc-8e298b94dac0@app.fastmail.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="8nM4OwS3c2IxZRuL" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --8nM4OwS3c2IxZRuL Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Thanks for the feedback. Here is an updated patch. I kept the comment about the weight parameters in autovacuum.c. Since there's a bunch of code related to them, IMHO we should have an explanatory note somewhere. -- nathan --8nM4OwS3c2IxZRuL Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename=v14-0001-autovacuum-scheduling-improvements.patch