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 1tUuGz-003k0H-QF for pgsql-committers@arkaria.postgresql.org; Mon, 06 Jan 2025 21:04:30 +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 1tUuGy-00DBzd-Uy for pgsql-committers@arkaria.postgresql.org; Mon, 06 Jan 2025 21:04:28 +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 1tUuEo-00CufF-HF for pgsql-committers@lists.postgresql.org; Mon, 06 Jan 2025 21:02:14 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tUuEk-000DE4-2x for pgsql-committers@lists.postgresql.org; Mon, 06 Jan 2025 21:02:11 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=xWhmRVuTmKJw2v0ge8zXMya6saLMxIXIgHun672SNdw=; b=J04z8Xtkb8dA3IRL1Zor1FXT0J XKraWTNaP1aw2jIttqRwfIJORw4bTJRkqK+y5KaS8SiMzoqLZ5DsVqaT/cy16bbM90Twh9IcK8UsA 37RlCv3zBnqEg6ykkgyioc+JvroK/ID/mW89oukXN2QtT0lGbJOG6eXJwkXt1makfXiziP7RFw2hi JNbcz78XoRcMDqKTzlAn7dYAPldkO5cbeG/reIIuReYyjQq4H3QLptsHKboRnuBRiTwRlzACG90B9 7eyTfaKtzPRvQRA6HgHVNPTaVI1NEBFuEYN9rBgV3cLvE6f7/F3n8xFC+s9aTK1r0BK3UlLOGhR3k qZxOolzQ==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tUuEk-000ewT-8f for pgsql-committers@lists.postgresql.org; Mon, 06 Jan 2025 21:02:10 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tUuEj-000Cyr-TE for pgsql-committers@lists.postgresql.org; Mon, 06 Jan 2025 21:02:10 +0000 Content-Type: multipart/mixed; boundary="===============7522399513070838626==" MIME-Version: 1.0 From: Nathan Bossart To: pgsql-committers@lists.postgresql.org Subject: pgsql: Allow changing autovacuum_max_workers without restarting. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 06 Jan 2025 21:02:10 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============7522399513070838626== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 QWxsb3cgY2hhbmdpbmcgYXV0b3ZhY3V1bV9tYXhfd29ya2VycyB3aXRob3V0IHJlc3RhcnRpbmcu CgpUaGlzIGNvbW1pdCBpbnRyb2R1Y2VzIGEgbmV3IHBhcmFtZXRlciBuYW1lZAphdXRvdmFjdXVt X3dvcmtlcl9zbG90cyB0aGF0IGNvbnRyb2xzIGhvdyBtYW55IGF1dG92YWN1dW0gd29ya2VyCnNs b3RzIHRvIHJlc2VydmUgZHVyaW5nIHNlcnZlciBzdGFydHVwLiAgTW9kaWZ5aW5nIHRoaXMgbmV3 CnBhcmFtZXRlcidzIHZhbHVlIGRvZXMgcmVxdWlyZSBhIHNlcnZlciByZXN0YXJ0LCBidXQgaXQg c2hvdWxkCnR5cGljYWxseSBiZSBzZXQgdG8gdGhlIHVwcGVyIGJvdW5kIG9mIHdoYXQgeW91IG1p Z2h0IHJlYWxpc3RpY2FsbHkKbmVlZCB0byBzZXQgYXV0b3ZhY3V1bV9tYXhfd29ya2Vycy4gIFdp dGggdGhhdCBuZXcgcGFyYW1ldGVyIGluCnBsYWNlLCBhdXRvdmFjdXVtX21heF93b3JrZXJzIGNh biBub3cgYmUgY2hhbmdlZCB3aXRoIGEgU0lHSFVQCihlLmcuLCBwZ19jdGwgcmVsb2FkKS4KCklm IGF1dG92YWN1dW1fbWF4X3dvcmtlcnMgaXMgc2V0IGhpZ2hlciB0aGFuCmF1dG92YWN1dW1fd29y a2VyX3Nsb3RzLCBhIFdBUk5JTkcgaXMgZW1pdHRlZCwgYW5kIHRoZSBzZXJ2ZXIgd2lsbApvbmx5 IHN0YXJ0IHVwIHRvIGF1dG92YWN1dW1fd29ya2VyX3Nsb3RzIHdvcmtlcnMgYXQgYSBnaXZlbiB0 aW1lLgpJZiBhdXRvdmFjdXVtX21heF93b3JrZXJzIGlzIHNldCB0byBhIHZhbHVlIGxlc3MgdGhh biB0aGUgbnVtYmVyIG9mCmN1cnJlbnRseS1ydW5uaW5nIGF1dG92YWN1dW0gd29ya2VycywgdGhl IGV4aXN0aW5nIHdvcmtlcnMgd2lsbApjb250aW51ZSBydW5uaW5nLCBidXQgbm8gbmV3IHdvcmtl cnMgd2lsbCBiZSBzdGFydGVkIHVudGlsIHRoZQpudW1iZXIgb2YgcnVubmluZyBhdXRvdmFjdXVt IHdvcmtlcnMgZHJvcHMgYmVsb3cKYXV0b3ZhY3V1bV9tYXhfd29ya2Vycy4KClJldmlld2VkLWJ5 OiBTYW1pIEltc2VpaCwgSnVzdGluIFByeXpieSwgUm9iZXJ0IEhhYXMsIEFuZHJlcyBGcmV1bmQs IFlvZ2VzaCBTaGFybWEKRGlzY3Vzc2lvbjogaHR0cHM6Ly9wb3N0Z3IuZXMvbS8yMDI0MDQxMDIx MjM0NC5HQTE4MjQ1NDklNDBuYXRoYW54cHMxMwoKQnJhbmNoCi0tLS0tLQptYXN0ZXIKCkRldGFp bHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9wZy9jb21taXRkaWZmL2M3NTgx MTllNWJmYjQ3YjM4Y2Y5NTdmOWE1YTM3Y2VhZTk2ZmE5YjMKCk1vZGlmaWVkIEZpbGVzCi0tLS0t LS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9jb25maWcuc2dtbCAgICAgICAgICAgICAgICAgICAgICB8 IDI4ICsrKysrKysrLQpkb2Mvc3JjL3NnbWwvcnVudGltZS5zZ21sICAgICAgICAgICAgICAgICAg ICAgfCAgNCArLQpzcmMvYmFja2VuZC9hY2Nlc3MvdHJhbnNhbS94bG9nLmMgICAgICAgICAgICAg fCAgMiArLQpzcmMvYmFja2VuZC9wb3N0bWFzdGVyL2F1dG92YWN1dW0uYyAgICAgICAgICAgfCA4 MiArKysrKysrKysrKysrKysrKysrKystLS0tLS0Kc3JjL2JhY2tlbmQvcG9zdG1hc3Rlci9wbWNo aWxkLmMgICAgICAgICAgICAgIHwgIDQgKy0Kc3JjL2JhY2tlbmQvc3RvcmFnZS9sbWdyL3Byb2Mu YyAgICAgICAgICAgICAgIHwgIDYgKy0Kc3JjL2JhY2tlbmQvdXRpbHMvaW5pdC9wb3N0aW5pdC5j ICAgICAgICAgICAgIHwgIDYgKy0Kc3JjL2JhY2tlbmQvdXRpbHMvbWlzYy9ndWNfdGFibGVzLmMg ICAgICAgICAgIHwgMTEgKysrLQpzcmMvYmFja2VuZC91dGlscy9taXNjL3Bvc3RncmVzcWwuY29u Zi5zYW1wbGUgfCAgMyArLQpzcmMvaW5jbHVkZS9wb3N0bWFzdGVyL2F1dG92YWN1dW0uaCAgICAg ICAgICAgfCAgMSArCnNyYy90ZXN0L3BlcmwvUG9zdGdyZVNRTC9UZXN0L0NsdXN0ZXIucG0gICAg ICB8ICAxICsKMTEgZmlsZXMgY2hhbmdlZCwgMTE3IGluc2VydGlvbnMoKyksIDMxIGRlbGV0aW9u cygtKQoK --===============7522399513070838626==--