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 1u9o3A-006WfN-Se for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Apr 2025 16:43:17 +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 1u9o38-008fAI-T2 for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Apr 2025 16:43:15 +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 1u9o38-008fA9-Dv for pgsql-hackers@lists.postgresql.org; Tue, 29 Apr 2025 16:43:15 +0000 Received: from mail-io1-xd32.google.com ([2607:f8b0:4864:20::d32]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u9o37-000CuT-2E for pgsql-hackers@lists.postgresql.org; Tue, 29 Apr 2025 16:43:14 +0000 Received: by mail-io1-xd32.google.com with SMTP id ca18e2360f4ac-85b3f92c866so128715639f.3 for ; Tue, 29 Apr 2025 09:43:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1745944993; x=1746549793; darn=lists.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=Vxpy5bmXqtJZO5qkyv24NoWmEiUtk1dfeXA/opaGtaI=; b=PKTirwdAVZwuNArB1cVWSSNYwcV4hZnomfN/AL7lmZyNTdPYmqL8Mgbuyg5uJvLfm3 oNX2vuDVjGrqTzxtjjAnMyQdR69XlvjNtwlEk9lEmQGudvJdCakFv8uqwxzC88fHovkR V+KrDgtBJ1AzfsgvwdtAPwjAroY4Pgn0uOhAQetvtqr+647+KNUQbrl8Kd73o6V5I/of JMiXz6hqFZ3uomLvDdHeYHxH5YdNn1yUvpqEOZuuO1mhCXQP9X18fmGspJiYa2J/dFRp 41UZTfC9KzihsyYMI0DhviLc9LZHpDsDShyrCz8giwjp2Kig/92RheMsx++U8xdf191B 2Pzg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745944993; x=1746549793; 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=Vxpy5bmXqtJZO5qkyv24NoWmEiUtk1dfeXA/opaGtaI=; b=i+mQP5VqAgGzSBRdAaKwGfp+MfG64qN425+hMk+StzboRUrAyqrkqo4IctY5D6QMtu pxPm9+83sd4gRrsnoLn7mkX0nyMUAXPM57q53+BrCyx4RlUpt9VH17I7NvQlDEu2/FPg 72rMLNkawEZD3Cgfx71c9uQTrdzGM+puufikFhL1LOatp/9iCg+aIuoH5dceN/Xv6X98 ECoUdB+fRlgBGg9JTUc8yeEgnkRQVaAndbwf77tJXMH4O2bl3iMSOfd2KJypMk3GVWzO KTc00XCoLmJeUNkmGydL9aSW3960kNfUB3bdCrRBzCSRONtvk/rct7qhmjdW/5fcTi3J M4IQ== X-Forwarded-Encrypted: i=1; AJvYcCXjkn75lDpexB+CLl2LtM5/s689qN0o6jwv5JJcu5Wwn8+gwXDPmYIHO3il0cxDnK9VeQDODE4iybFfB7oT@lists.postgresql.org X-Gm-Message-State: AOJu0YzBjwKqDwzBupvwVH2Gj7+wee30sbgvKc1Wau5XGr89kgcbhyIF 6WvuS/cwFMdelTOAiX1OyqNOFUj9LI4BPmDg4t8SorK/jMujU71Y X-Gm-Gg: ASbGnctgYmbG0DDg9HRaB6Pm8x+yc6nh8PlAkehACiAikEtdisOKeb9p4Gj88mxdkKn IxdKGgPKkMMyPyCqq+OLEO0fPaP7ThfOl1wVkBZd31FXqJUxqhKb+zdu2D8svP6PdqYQ6c6lhAs vQGpmYLKgd23gqaBNkA4MCdzffguX8MbcmZae4B86hddBtTVn824gfwXcQmOZwAFQW/IiH88yP9 DcZycKCXRguLUDyeGc/rZXqOTAVI6hbnRWoft6c92ygWch4CR/XHRKCRNgHitKG24atYK5wY8ig fCiNgC8MPZthvzUWiBWm4CofilcPAWUV2hCs2b4E7KHTw8QNtfptYqxyCTs8g6VKChHjkiGuAZ4 UbXtVy0Bw2G9dclxxWnyV77/l/nJS64g= X-Google-Smtp-Source: AGHT+IGBVbBPkqK+//j865RxvC339BQunSgQ55vHbIitvNBhl7i1SXWR10WtM276h8CP4yH3yzSiIw== X-Received: by 2002:a05:6602:1583:b0:864:4a24:3e90 with SMTP id ca18e2360f4ac-86467faf5abmr1310081639f.10.1745944993004; Tue, 29 Apr 2025 09:43:13 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id ca18e2360f4ac-8648bf2d892sm35699639f.11.2025.04.29.09.43.11 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 29 Apr 2025 09:43:12 -0700 (PDT) Date: Tue, 29 Apr 2025 11:43:10 -0500 From: Nathan Bossart To: Peter Eisentraut Cc: Tom Lane , 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: <1353350.1736202977@sss.pgh.pa.us> <1359669.1736206603@sss.pgh.pa.us> <1386858.1736220547@sss.pgh.pa.us> <713236.1745846094@sss.pgh.pa.us> <15005c8c-7676-43b7-a440-787b101cfdf5@eisentraut.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <15005c8c-7676-43b7-a440-787b101cfdf5@eisentraut.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Tue, Apr 29, 2025 at 08:36:48AM +0200, Peter Eisentraut wrote: > On 28.04.25 16:41, Nathan Bossart wrote: >> On Mon, Apr 28, 2025 at 09:14:54AM -0400, Tom Lane wrote: >> > My own proposal given the way it works now is to just print >> > max_connections and not mention autovacuum_worker_slots at all. >> > Our choice for max_connections is worth reporting, but I don't >> > feel that everything derived from it needs to be reported. >> >> I'm fine with either of these ideas. If I had to choose one, I'd just >> remove the autovacuum_worker_slots report for the reasons Tom noted. > > Yes, removing the report is also fine by me. Committed. -- nathan