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 1s2YsK-0044l0-Uv for pgsql-hackers@arkaria.postgresql.org; Thu, 02 May 2024 16:01:36 +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 1s2YsG-0027cI-Ct for pgsql-hackers@arkaria.postgresql.org; Thu, 02 May 2024 16:01:33 +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 1s2YsF-0027c9-Vu for pgsql-hackers@lists.postgresql.org; Thu, 02 May 2024 16:01:32 +0000 Received: from smtp-fw-52005.amazon.com ([52.119.213.156]) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s2Ys9-0016YM-UX for pgsql-hackers@lists.postgresql.org; Thu, 02 May 2024 16:01:31 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=amazon.com; i=@amazon.com; q=dns/txt; s=amazon201209; t=1714665686; x=1746201686; h=from:to:cc:date:message-id:references:in-reply-to: content-id:content-transfer-encoding:mime-version:subject; bh=1XqfSBTA2l664sjvAYhx7flj8oax8wtT0rZTLBPTCSc=; b=iDr1tI9DgKK9rl3rnHGW8N/EeRXZdOKmP5l84xL8hzpFRHtaH3LCSS9x VOSxS2valJHJnjFtVbfET9r60MAsNxexZJGU+k72BDmQddPo2RAaU07dR 0tasH/opC9KxD2YrFzCZ+Kvwp0/Q4L6plTp/nNGYmi66uRw01CIi2IkIL Y=; X-IronPort-AV: E=Sophos;i="6.07,247,1708387200"; d="scan'208";a="651604564" Subject: Re: New GUC autovacuum_max_threshold ? Thread-Topic: New GUC autovacuum_max_threshold ? Received: from iad12-co-svc-p1-lb1-vlan3.amazon.com (HELO smtpout.prod.us-west-2.prod.farcaster.email.amazon.dev) ([10.43.8.6]) by smtp-border-fw-52005.iad7.amazon.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 02 May 2024 16:01:24 +0000 Received: from EX19MTAUWA002.ant.amazon.com [10.0.7.35:27094] by smtpin.naws.us-west-2.prod.farcaster.email.amazon.dev [10.0.12.153:2525] with esmtp (Farcaster) id f5673fb4-1091-4811-8071-5479f0a480f0; Thu, 2 May 2024 16:01:23 +0000 (UTC) X-Farcaster-Flow-ID: f5673fb4-1091-4811-8071-5479f0a480f0 Received: from EX19D013UWA002.ant.amazon.com (10.13.138.210) by EX19MTAUWA002.ant.amazon.com (10.250.64.202) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.2.1258.28; Thu, 2 May 2024 16:01:23 +0000 Received: from EX19D013UWA001.ant.amazon.com (10.13.138.253) by EX19D013UWA002.ant.amazon.com (10.13.138.210) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA) id 15.2.1258.28; Thu, 2 May 2024 16:01:23 +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, 2 May 2024 16:01:23 +0000 From: "Imseih (AWS), Sami" To: Robert Haas CC: Joe Conway , Michael Banck , "Laurenz Albe" , =?utf-8?B?RnLDqWTDqXJpYyBZaHVlbA==?= , Nathan Bossart , Melanie Plageman , PostgreSQL Hackers , David Rowley Thread-Index: AQHalkAhHsg8dwXlOUOaryi6n+yLBrF3yaGAgAANOoCAAXqqgIAAg8iAgABWzACAAAvnAIAAVV3SgAACMoCAAAJugIAACSQAgAfMoYCAAFy+gIABDviA Date: Thu, 2 May 2024 16:01:23 +0000 Message-ID: <58F319D2-13A3-4D29-AA12-D4C25F142DEF@amazon.com> References: <956435f8-3b2f-47a6-8756-8c54ded61802@dalibo.com> <20240424195747.GA861150@nathanxps13> <662b6941.5d0a0220.ea153.4178@mx.google.com> <06b361a6-094c-4d78-b4c9-b102e270d97e@joeconway.com> <7c91df80-ef1b-426a-a2b3-e11ffb31bcc7@joeconway.com> <6B3881B9-29C4-4649-BEB7-0782C9595CBB@amazon.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.13.138.196] 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 PiBBbmQgYXMgZmFyIGFzIHRoYXQgZ29lcywgSSdkIGxpa2UgeW91IC0gYW5kIG90aGVycyAtIHRv IHNwZWxsIG91dCBtb3JlDQo+IHByZWNpc2VseSB3aHkgeW91IHRoaW5rIDEwMCBvciAyMDAgbWls bGlvbiB0dXBsZXMgaXMgdG9vIG11Y2guIEl0DQo+IG1pZ2h0IGJlLCBvciBtYXliZSBpdCBpcyBp biBzb21lIGNhc2VzIGJ1dCBub3QgaW4gb3RoZXJzLiBUbyBtZSwNCj4gdGhhdCdzIG5vdCBhIHRl cnJpYmx5IGxhcmdlIGFtb3VudCBvZiBkYXRhLiBVbmxlc3MgeW91ciB0dXBsZXMgYXJlDQo+IHZl cnkgd2lkZSwgaXQncyBhIGZldyB0ZW5zIG9mIGdpZ2FieXRlcy4gVGhhdCBpcyBiaWcgZW5vdWdo IHRoYXQgSSBjYW4NCj4gYmVsaWV2ZSB0aGF0IHlvdSAqbWlnaHQqIHdhbnQgYXV0b3ZhY3V1bSB0 byBydW4gd2hlbiB5b3UgaGl0IHRoYXQNCj4gdGhyZXNob2xkLCBidXQgaXQncyBkZWZpbml0ZWx5 IG5vdCAqb2J2aW91cyogdG8gbWUgdGhhdCB5b3Ugd2FudA0KPiBhdXRvdmFjdXVtIHRvIHJ1biB3 aGVuIHlvdSBoaXQgdGhhdCB0aHJlc2hvbGQuDQoNCg0KVmFjdXVtaW5nIHRoZSBoZWFwIGFsb25l IGdldHMgZmFzdGVyIHRoZSBtb3JlIEkgZG8gaXQsIHRoYW5rcyB0byB0aGUgDQp2aXNpYmlsaXR5 IG1hcC4gSG93ZXZlciwgdGhlIG1vcmUgaW5kZXhlcyBJIGhhdmUsIGFuZCB0aGUgbGFyZ2VyICgg aW4gdGhlIFRCcyksDQp0aGUgaW5kZXhlcyBiZWNvbWUsIGF1dG92YWN1dW0gd29ya2VycyB3aWxs IGJlIA0KbW9ub3BvbGl6ZWQgdmFjdXVtaW5nIHRoZXNlIGluZGV4ZXMuDQoNCg0KQXQgNTAwayB0 dXBsZXMsIEkgYW0gY29uc3RhbnRseSB2YWN1dW1pbmcgbGFyZ2UgaW5kZXhlcw0KYW5kIG1vbm9w b2xpemluZyBhdXRvdmFjdXVtIHdvcmtlcnMuIEF0IDEwMCBvciAyMDANCm1pbGxpb24gdHVwbGVz LCBJIHdpbGwgYWxzbyBtb25vcG9saXplIGF1dG92YWN1dW0gd29ya2Vycw0KYXMgdGhleSB2YWN1 dW1zIGluZGV4ZXMgZm9yIG1hbnkgbWludXRlcyBvciBob3Vycy4gDQoNCg0KQXQgMTAwIG9yIDIw MCBtaWxsaW9uLCB0aGUgbW9ub3BvbGl6YXRpb24gd2lsbCBvY2N1ciBsZXNzIG9mdGVuLCANCmJ1 dCBpdCB3aWxsIHN0aWxsIG9jY3VyIGxlYWRpbmcgYW4gb3BlcmF0b3IgdG8gbWF5YmUgaGF2ZSB0 byB0ZXJtaW5hdGUNCnRoZSBhdXRvdmFjdXVtIGFuIGtpY2sgb2YgYSBtYW51YWwgdmFjdXVtLiAN Cg0KDQpJIGFtIG5vdCBjb252aW5jZWQgYSBuZXcgdHVwbGUgYmFzZWQgdGhyZXNob2xkIHdpbGwg YWRkcmVzcyB0aGlzLCANCmJ1dCBJIG1heSBhbHNvIG1heSBiZSBtaXN1bmRlcnN0YW5kaW5nIHRo ZSBpbnRlbnRpb24gb2YgdGhpcyBHVUMuDQoNCg0KPiBUbyBtYWtlIHRoYXQgY29uY3JldGU6IElm IHRoZSB0YWJsZSBpcyAxMFRCLCBkbyB5b3Ugd2FudCB0byB2YWN1dW0gdG8NCj4gcmVjbGFpbSAy MEdCIG9mIGJsb2F0PyBZb3UgbWlnaHQgYmUgdmFjdXVtaW5nIDVUQiBvZiBpbmRleGVzIHRvDQo+ IHJlY2xhaW0gMjBHQiBvZiBoZWFwIHNwYWNlIC0gaXMgdGhhdCB0aGUgcmlnaHQgdGhpbmcgdG8g ZG8/IElmIHllcywNCj4gd2h5Pw0KDQoNCk5vLCBJIHdvdWxkIG5vdCB3YW50IHRvIHJ1biBhdXRv dmFjdXVtIG9uIDVUQiBpbmRleGVzIHRvIHJlY2xhaW0gDQphIHNtYWxsIGFtb3VudCBvZiBibG9h dC4NCg0KDQoNCg0KUmVnYXJkcywNCg0KDQpTYW1pDQoNCg0KDQoNCg0K