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 1u9sct-007W4Z-RS for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Apr 2025 21:36:28 +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 1u9scq-00A6dE-K9 for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Apr 2025 21:36:25 +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 1u9scq-00A6d6-AN for pgsql-hackers@lists.postgresql.org; Tue, 29 Apr 2025 21:36:25 +0000 Received: from mail-il1-x132.google.com ([2607:f8b0:4864:20::132]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u9scp-000Evs-1r for pgsql-hackers@postgresql.org; Tue, 29 Apr 2025 21:36:24 +0000 Received: by mail-il1-x132.google.com with SMTP id e9e14a558f8ab-3d57143ee39so57022425ab.1 for ; Tue, 29 Apr 2025 14:36:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1745962583; x=1746567383; 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=ov7Rq9ketSrkUn+Q/sJJIz/3en7ciAVowMTUgtXeQmk=; b=L32u836URxMj3BW7QRpDBHq0zjIMfW6VshjhUU/gUquwhtr+/uG/o1QJhOy2j6esfJ TViyRMYgz7HzXIWKImqFS1YOjl+NKQqpIqHwuwNlu3LQ5gAzywLcrVBWCz6gOt3YhSIU a8tEptBq2viKl1ySPJFu+I48KvTkMWSmCkiLBBmCk5Q0pTEzJH2xdJ+x7HuPTvCzGEc6 gu9UO0p8NOOfp4rtavoDqGt5lfUnQ0XX5CSm8JvMmJu2JDuAUo+hZcIa3j6XvNDA5TrZ r0jt555o6i+k/eX9t+HWJZKMEjfw7YvWTtsIhHAls++w+GLOW6OaxjnbZ85XatV8dWkc vKIw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745962583; x=1746567383; 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=ov7Rq9ketSrkUn+Q/sJJIz/3en7ciAVowMTUgtXeQmk=; b=F0/jHhAbw77Vdbvxvb31mP7OZUx4zGWNWgKwD4YuZ5RuFXEDqEYO4ApbEISCnynhxM 6iiHeAgt8oPTZrSWEsl8N4KdEI2HG3Lplsib3R06aFw1/fi7frY/9b8VPIEbyWWc4fdr l3Ol89+angovi+90sRLpSz5i4DKaytWtOjfJnyBBe18uI/Ez5FnBQgB7MCViwpFqXKd8 jYLImoW+GmrEu2Buhxods+J95dx8W9pPHAPwPyuorw91eMeOG/3Xp7pQpf5bZFELqUiu itGPyCyQuj5rCi9n5JhJuROl5tM1qrjJOxSUOdcWEsQZPaNpd3TP5TqPWgyX4D3YUT+E KxHQ== X-Forwarded-Encrypted: i=1; AJvYcCUG3p3hRK7xRsARHmjubLg8QfaIyNSm8up38PmAFYj/sxDj6FiqHC6NfY2WgxrDzyQL+krNFQKNLLNPQrBO@postgresql.org X-Gm-Message-State: AOJu0YwpDPi0Dm5DmA1o2BpC80/MtOZRVUn3XbWKMx1B1uvLu0XyCGps vERlHrKAR5oNsHMi1nxfvUnIkkOduWfhyPjFVjpnmkf4zl/04M13 X-Gm-Gg: ASbGncsZqkDZYNETmkaIbHm6SKfDx625RVCDPokA+HJO4ybvluIUKObVoLYrFmCORgG dt56DwRMq0Wrqxupt0LKRZZLjNw+wejOl1X2IDGxGukLEFnv6x7DnIdu8kxztN7RKeZal/dCsTw 2c9FKrutQerruMrh3LOTzxWaz8HOH7SosBQb7NBcDB+IYftfeZ1ij66x0gskxWdckPQxCz+WXi4 9iCX5wVQr5R8jPeW2gpgEz9wZ/FK+JNtPSMsW8YfVYmI3tlM5u50uvuP9EChNwq/J9D7TwLJOx2 8P70e+u5KwVFik40Ulrj7QdoSBBSZK0GpLpJowxFmPiYKDZWZ/BXMMHMN/Dve63jDG0NA3J4hA2 Sp0GI/e7VjgVqTPn20sj+RC3BWFJU8lfiP/OQ X-Google-Smtp-Source: AGHT+IFJzwnpfW+vZDnG5Q6+05k1qEBIw/ByFLaA5offNQpaAHhtVaSPIKpvVj6LqRQsXb/qP+T3eA== X-Received: by 2002:a05:6e02:1c07:b0:3cf:c9ad:46a1 with SMTP id e9e14a558f8ab-3d967fc6b3fmr1775045ab.13.1745962582982; Tue, 29 Apr 2025 14:36:22 -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-4f862e89709sm466242173.56.2025.04.29.14.36.22 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 29 Apr 2025 14:36:22 -0700 (PDT) Date: Tue, 29 Apr 2025 16:36:20 -0500 From: Nathan Bossart To: Tom Lane Cc: Peter Eisentraut , Andres Freund , pgsql-hackers@lists.postgresql.org, "Imseih (AWS), Sami" , Justin Pryzby , "pgsql-hackers@postgresql.org" Subject: Re: allow changing autovacuum_max_workers without restarting Message-ID: References: <1386858.1736220547@sss.pgh.pa.us> <713236.1745846094@sss.pgh.pa.us> <15005c8c-7676-43b7-a440-787b101cfdf5@eisentraut.org> <1050120.1745947158@sss.pgh.pa.us> <1052019.1745947915@sss.pgh.pa.us> <1147121.1745962261@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1147121.1745962261@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Apr 29, 2025 at 05:31:01PM -0400, Tom Lane wrote: > Pushed. I realized that the text about SEMMNI/SEMMNS in runtime.sgml > needed some work too, since it still said that increasing them was > optional on NetBSD/OpenBSD. Thanks. Your updates look good to me. -- nathan