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 1ubKwd-00H5T9-BV for pgsql-hackers@arkaria.postgresql.org; Mon, 14 Jul 2025 15:18:19 +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 1ubKwb-009Fs4-FM for pgsql-hackers@arkaria.postgresql.org; Mon, 14 Jul 2025 15:18:18 +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 1ubKwb-009Frv-5I for pgsql-hackers@lists.postgresql.org; Mon, 14 Jul 2025 15:18:17 +0000 Received: from bramsgout01.huawei.com ([119.8.89.135]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1ubKwZ-007Fv7-2c for pgsql-hackers@postgresql.org; Mon, 14 Jul 2025 15:18:16 +0000 dkim-signature: v=1; a=rsa-sha256; d=huawei.com; s=dkim; c=relaxed/relaxed; q=dns/txt; h=From; bh=65H01nGn+8HcVK0iucHvm4JMvc26386KZfk0QN3BbPI=; b=K7JQ+2XAqljVmmloaMzkBS1fN/7vO/runfrC76cfhWPyecSLNnlOEOZ9qDHoHmEsnALxcrgBU +NU7/4AyVmIPvz3rclNiEaUk935jX2IF71HHNmwWjJUrZLJdPFAp2Zf2dJ/RRYEHOc2XO6qBBAc HBtfyAmmiuLuDQ9aCWsrRyQ= Received: from mail.maildlp.com (unknown [172.18.210.252]) by bramsgout01.huawei.com (SkyGuard) with ESMTPS id 4bgm9t4c4fz3NNyt; Mon, 14 Jul 2025 23:16:18 +0800 (CST) Received: from ytopeml500002.china.huawei.com (unknown [7.184.16.163]) by mail.maildlp.com (Postfix) with ESMTPS id 1C6E0140275; Mon, 14 Jul 2025 23:18:12 +0800 (CST) Received: from ytopeml500001.china.huawei.com (7.184.16.223) by ytopeml500002.china.huawei.com (7.184.16.163) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.1.2507.39; Mon, 14 Jul 2025 11:18:10 -0400 Received: from ytopeml500001.china.huawei.com ([7.184.16.223]) by ytopeml500001.china.huawei.com ([7.184.16.223]) with mapi id 15.01.2507.039; Mon, 14 Jul 2025 11:18:10 -0400 From: Jack Ng To: Andres Freund , Dmitry Dolgov <9erthalion6@gmail.com> CC: Thom Brown , Ashutosh Bapat , Tomas Vondra , Thomas Munro , PostgreSQL-development , Ni Ku Subject: RE: Changing shared_buffers without restart Thread-Topic: Changing shared_buffers without restart Thread-Index: AQHb4czjArbykOnCnUaEQCqOWcY4q7QfGxSAgAJTTACAAPSigIADCKUAgAAFeACAC1ixAIAArMiAgAA2XgCAAARBgIAACBkAgAAIcACAAAIegIAAOSQAgAADOQCAAAGrAIAAAZKAgAAGWACAAAVUAIAABgaAgAAEhICAAAj0AP//vbtQ Date: Mon, 14 Jul 2025 15:18:10 +0000 Message-ID: References: <1ABF6EF8-8556-4C1D-BA34-142DC4813CED@anarazel.de> In-Reply-To: <1ABF6EF8-8556-4C1D-BA34-142DC4813CED@anarazel.de> Accept-Language: en-CA, zh-CN, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.218.176.22] Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk SnVzdCBicmFpbi1zdG9ybWluZyBoZXJlLi4uIHdvdWxkIG1vdmluZyBOQnVmZmVycyB0byBzaGFy ZWQgbWVtb3J5IHNvbHZlIHRoaXMgc3BlY2lmaWMgaXNzdWU/IFRob3VnaCBJJ20gcHJldHR5IHN1 cmUgdGhhdCB3b3VsZCBvcGVuIHVwIGEgbmV3IHNldCBvZiBzeW5jaHJvbml6YXRpb24gaXNzdWVz IGVsc2V3aGVyZSwgc28gSSdtIG5vdCBzdXJlIGlmIHRoZXJlJ3MgYSBuZXQgZ2Fpbi4NCg0KSmFj aw0KDQo+LS0tLS1PcmlnaW5hbCBNZXNzYWdlLS0tLS0NCj5Gcm9tOiBBbmRyZXMgRnJldW5kIDxh bmRyZXNAYW5hcmF6ZWwuZGU+DQo+U2VudDogTW9uZGF5LCBKdWx5IDE0LCAyMDI1IDExOjEyIEFN DQo+VG86IERtaXRyeSBEb2xnb3YgPDllcnRoYWxpb242QGdtYWlsLmNvbT4NCj5DYzogVGhvbSBC cm93biA8dGhvbUBsaW51eC5jb20+OyBBc2h1dG9zaCBCYXBhdA0KPjxhc2h1dG9zaC5iYXBhdC5v c3NAZ21haWwuY29tPjsgVG9tYXMgVm9uZHJhIDx0b21hc0B2b25kcmEubWU+Ow0KPlRob21hcyBN dW5ybyA8dGhvbWFzLm11bnJvQGdtYWlsLmNvbT47IFBvc3RncmVTUUwtZGV2ZWxvcG1lbnQgPHBn c3FsLQ0KPmhhY2tlcnNAcG9zdGdyZXNxbC5vcmc+OyBKYWNrIE5nIDxKYWNrLk5nQGh1YXdlaS5j b20+OyBOaSBLdQ0KPjxqYWtrdW5pa3VAZ21haWwuY29tPg0KPlN1YmplY3Q6IFJlOiBDaGFuZ2lu ZyBzaGFyZWRfYnVmZmVycyB3aXRob3V0IHJlc3RhcnQNCj4NCj5IaSwNCj4NCj5PbiBKdWx5IDE0 LCAyMDI1IDEwOjM5OjMzIEFNIEVEVCwgRG1pdHJ5IERvbGdvdiA8OWVydGhhbGlvbjZAZ21haWwu Y29tPg0KPndyb3RlOg0KPj4+IE9uIE1vbiwgSnVsIDE0LCAyMDI1IGF0IDEwOjIzOjIzQU0gLTA0 MDAsIEFuZHJlcyBGcmV1bmQgd3JvdGU6DQo+Pj4gPiBUaG9zZSBzdGVwcyBhcmUgc2VwYXJhdGVk IGluIHRpbWUsIGFuZCBJJ20gY3VycmVudGx5IHRyeWluZyB0bw0KPj4+ID4gdW5kZXJzdGFuZCB3 aGF0IGFyZSB0aGUgY29uc2VxdWVuY2VzIG9mIHBlcmZvcm1pbmcgdGhlbSBpbg0KPj4+ID4gZGlm ZmVyZW50IG9yZGVyIGFuZCB3aGV0aGVyIHRoZXJlIGFyZSBwb3NzaWJsZSBjb25jdXJyZW5jeSBp c3N1ZXMNCj4+PiA+IHVuZGVyIHZhcmlvdXMgc2NlbmFyaW9zLiBEb2VzIHRoaXMgbWFrZSBtb3Jl IHNlbnNlLCBvciBzdGlsbCBub3Q/DQo+Pj4NCj4+PiBJIHN0aWxsIGRvbid0IHVuZGVyc3RhbmQg d2h5IGl0J2QgZXZlciBtYWtlIHNlbnNlIHRvIHB1dCBhIGJ1ZmZlcg0KPj4+IG9udG8gdGhlIGZy ZWVsaXN0IGJlZm9yZSB1cGRhdGluZyBOQnVmZmVycyBmaXJzdC4NCj4+DQo+PkRlcGVuZGluZyBv biBob3cgTkJ1ZmZlcnMgaXMgdXBkYXRlZCwgZGlmZmVyZW50IGJhY2tlbmRzIG1heSBoYXZlDQo+ PmRpZmZlcmVudCB2YWx1ZSBvZiBOQnVmZmVycyBmb3IgYSBzaG9ydCB0aW1lIGZyYW1lLiBJbiB0 aGF0IGNhc2UgYQ0KPj5zY2VuYXJpbyBJJ20gdHJ5aW5nIHRvIGFkZHJlc3MgaXMgd2hlbiBvbmUg YmFja2VuZCB3aXRoIHRoZSBuZXcNCj4+TkJ1ZmZlcnMgdmFsdWUgYWxsb2NhdGVzIGEgbmV3IGJ1 ZmZlciBhbmQgcHV0cyBpdCBpbnRvIHRoZSBidWZmZXINCj4+bG9va3VwIHRhYmxlLCB3aGVyZSBp dCBjb3VsZCBiZWNvbWUgcmVhY2hhYmxlIGJ5IGFub3RoZXIgYmFja2VuZCwgd2hpY2gNCj4+c3Rp bGwgaGFzIHRoZSBvbGQgTkJ1ZmZlciB2YWx1ZS4gQ29ycmVjdCBtZSBpZiBJJ20gd3JvbmcsIGJ1 dA0KPj5pbml0aWFsaXppbmcgYnVmZmVyIGhlYWRlcnMgKyB1cGRhdGluZyBOQnVmZmVycyBtZWFu cyBjbG9jayBzd2VlcCBjYW4NCj4+bm93IHJldHVybiBvbmUgb2YgdGhvc2UgbmV3IGJ1ZmZlcnMs IG9wZW5pbmcgdGhlIHNjZW5hcmlvIGFib3ZlLCByaWdodD8NCj4NCj5UaGUgc2FtZSBpcyB0cnVl IGlmIHlvdSBwdXQgYnVmZmVycyBpbnRvIHRoZSBmcmVlbGlzdC4NCj4NCj5BbmRyZXMNCj4tLQ0K PlNlbnQgZnJvbSBteSBBbmRyb2lkIGRldmljZSB3aXRoIEstOSBNYWlsLiBQbGVhc2UgZXhjdXNl IG15IGJyZXZpdHkuDQo=