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 1ruvLk-008Xui-Rk for pgsql-hackers@arkaria.postgresql.org; Thu, 11 Apr 2024 14:24:25 +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 1ruvLj-001G9o-Kd for pgsql-hackers@arkaria.postgresql.org; Thu, 11 Apr 2024 14:24:23 +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 1ruvLj-001G9g-Az for pgsql-hackers@lists.postgresql.org; Thu, 11 Apr 2024 14:24:23 +0000 Received: from smtp-fw-9102.amazon.com ([207.171.184.29]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1ruvLg-002MHh-UR for pgsql-hackers@postgresql.org; Thu, 11 Apr 2024 14:24:22 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1712845462; x=1744381462; h=from:to:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=OUUONWKtbXuFLd7vvmgL2WabfVKJmkE7Ogm2UES4CMw=; b=swUzavpbwFCwLMFQcsWsTrAkZpcN4aNa1AeRLWLZja/zby2soysUsdHx ydsyR3yQT31HMHqzgc8aGapSTtdyQl/W0KoW0sz9deSbPUVKx9CAnGgvS SVhTWS8Pi+j66s0RluUgizBG70MY0rBMOKMWZ9RAi6/SOZ7I/XsHTZT2K Y=; X-IronPort-AV: E=Sophos;i="6.07,193,1708387200"; d="scan'208";a="410835918" Subject: Re: allow changing autovacuum_max_workers without restarting Thread-Topic: allow changing autovacuum_max_workers without restarting Received: from pdx4-co-svc-p1-lb2-vlan3.amazon.com (HELO smtpout.prod.us-west-2.prod.farcaster.email.amazon.dev) ([10.25.36.214]) by smtp-border-fw-9102.sea19.amazon.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 11 Apr 2024 14:24:20 +0000 Received: from EX19MTAUWA001.ant.amazon.com [10.0.7.35:12826] by smtpin.naws.us-west-2.prod.farcaster.email.amazon.dev [10.0.59.40:2525] with esmtp (Farcaster) id b7e075ca-91d5-4650-8651-7f66b12ceba5; Thu, 11 Apr 2024 14:24:18 +0000 (UTC) X-Farcaster-Flow-ID: b7e075ca-91d5-4650-8651-7f66b12ceba5 Received: from EX19D013UWA003.ant.amazon.com (10.13.138.202) by EX19MTAUWA001.ant.amazon.com (10.250.64.218) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1258.28; Thu, 11 Apr 2024 14:24:18 +0000 Received: from EX19D013UWA001.ant.amazon.com (10.13.138.253) by EX19D013UWA003.ant.amazon.com (10.13.138.202) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA) id 15.2.1258.28; Thu, 11 Apr 2024 14:24:18 +0000 Received: from EX19D013UWA001.ant.amazon.com ([fe80::e912:ae5e:9427:9964]) by EX19D013UWA001.ant.amazon.com ([fe80::e912:ae5e:9427:9964%5]) with mapi id 15.02.1258.028; Thu, 11 Apr 2024 14:24:18 +0000 From: "Imseih (AWS), Sami" To: Nathan Bossart , "pgsql-hackers@postgresql.org" Thread-Index: AQHai4194clV5iFl8k6V2jygxdO7R7FizPMA Date: Thu, 11 Apr 2024 14:24:18 +0000 Message-ID: References: <20240410212344.GA1824549@nathanxps13> In-Reply-To: <20240410212344.GA1824549@nathanxps13> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.106.239.31] Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiBJIGZyZXF1ZW50bHkgaGVhciBhYm91dCBzY2VuYXJpb3Mgd2hlcmUgdXNlcnMgd2l0aCB0aG91 c2FuZHMgdXBvbiB0aG91c2FuZHMNCj4gb2YgdGFibGVzIHJlYWxpemUgdGhhdCBhdXRvdmFjdXVt IGlzIHN0cnVnZ2xpbmcgdG8ga2VlcCB1cC4gIFdoZW4gdGhleQ0KPiBpbmV2aXRhYmx5IGdvIHRv IGJ1bXAgdXAgYXV0b3ZhY3V1bV9tYXhfd29ya2VycywgdGhleSBkaXNjb3ZlciB0aGF0IGl0DQo+ IHJlcXVpcmVzIGEgc2VydmVyIHJlc3RhcnQgKGkuZS4sIGRvd250aW1lKSB0byB0YWtlIGVmZmVj dCwgY2F1c2luZyBmdXJ0aGVyDQo+IGZydXN0cmF0aW9uLiAgRm9yIHRoaXMgcmVhc29uLCBJIHRo aW5rICRTVUJKRUNUIGlzIGEgZGVzaXJhYmxlIGltcHJvdmVtZW50Lg0KPiBJIHNwZW50IHNvbWUg dGltZSBsb29raW5nIGZvciBwYXN0IGRpc2N1c3Npb25zIGFib3V0IHRoaXMsIGFuZCBJIHdhcw0K PiBzdXJwcmlzZWQgdG8gbm90IGZpbmQgYW55LCBzbyBJIHRob3VnaHQgSSdkIGdpdmUgaXQgYSB0 cnkuDQoNCkkgZGlkIG5vdCByZXZpZXcgdGhlIHBhdGNoIGluIGRldGFpbCB5ZXQsIGJ1dCArMSB0 byB0aGUgaWRlYS4gDQpJdCdzIG5vdCBqdXN0IHRob3VzYW5kcyBvZiB0YWJsZXMgdGhhdCBzdWZm ZXIgZnJvbSB0aGlzLg0KSWYgYSB1c2VyIGhhcyBhIGZldyBsYXJnZSB0YWJsZXMgaG9nZ2luZyB0 aGUgYXV0b3ZhYyB3b3JrZXJzLCB0aGVuIG90aGVyDQp0YWJsZXMgZG9uJ3QgZ2V0IHRoZSBhdXRv dmFjIGN5Y2xlcyB0aGV5IHJlcXVpcmUuIFVzZXJzIGFyZSB0aGVuIGZvcmNlZA0KdG8gcnVuIG1h bnVhbCB2YWN1dW1zLCB3aGljaCBhZGRzIGNvbXBsZXhpdHkgdG8gdGhlaXIgb3BlcmF0aW9ucy4N Cg0KPiBUaGUgYXR0YWNoZWQgcHJvb2Ytb2YtY29uY2VwdCBwYXRjaCBkZW1vbnN0cmF0ZXMgd2hh dCBJIGhhdmUgaW4gbWluZC4NCj4gSW5zdGVhZCBvZiB0cnlpbmcgdG8gZHluYW1pY2FsbHkgY2hh bmdlIHRoZSBnbG9iYWwgcHJvY2VzcyB0YWJsZSwgZXRjLiwgSSdtDQo+IHByb3Bvc2luZyB0aGF0 IHdlIGludHJvZHVjZSBhIG5ldyBHVUMgdGhhdCBzZXRzIHRoZSBlZmZlY3RpdmUgbWF4aW11bQ0K PiBudW1iZXIgb2YgYXV0b3ZhY3V1bSB3b3JrZXJzIHRoYXQgY2FuIGJlIHN0YXJ0ZWQgYXQgYW55 IHRpbWUuDQoNCm1heF93b3JrZXJfcHJvY2Vzc2VzIGRlZmluZXMgYSBwb29sIG9mIG1heCAjIG9m IGJhY2tncm91bmQgd29ya2VycyBhbGxvd2VkLg0KcGFyYWxsZWwgd29ya2VycyBhbmQgZXh0ZW5z aW9ucyB0aGF0IHNwaW4gIHVwIGJhY2tncm91bmQgd29ya2VycyBhbGwgdXRpbGl6ZSBmcm9tIA0K dGhpcyBwb29sLiANCg0KU2hvdWxkIGF1dG92YWN1dW1fbWF4X3dvcmtlcnMgYmUgYWJsZSB0byB1 dGlsaXplIGZyb20gbWF4X3dvcmtlcl9wcm9jZXNzZXMgYWxzbz8NCg0KVGhpcyB3aWxsIGFsbG93 IGF1dG92YWN1dW1fbWF4X3dvcmtlcnMgdG8gYmUgZHluYW1pYyB3aGlsZSB0aGUgdXNlciBvbmx5 IGhhcw0KdG8gZGVhbCB3aXRoIGFuIGFscmVhZHkgZXhpc3RpbmcgR1VDLiBXZSBtYXkgd2FudCB0 byBpbmNyZWFzZSB0aGUgZGVmYXVsdCB2YWx1ZQ0KZm9yIG1heF93b3JrZXJfcHJvY2Vzc2VzIGFz IHBhcnQgb2YgdGhpcy4NCg0KDQpSZWdhcmRzLA0KDQpTYW1pDQpBbWF6b24gV2ViIFNlcnZpY2Vz IChBV1MpDQoNCg==