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 1rOPo2-003z8W-22 for pgsql-hackers@arkaria.postgresql.org; Fri, 12 Jan 2024 22:15:14 +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 1rOPo1-005sRp-9K for pgsql-hackers@arkaria.postgresql.org; Fri, 12 Jan 2024 22:15:13 +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 1rOPo0-005sRg-Vy for pgsql-hackers@lists.postgresql.org; Fri, 12 Jan 2024 22:15:12 +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.94.2) (envelope-from ) id 1rOPnt-001FKk-T7 for pgsql-hackers@lists.postgresql.org; Fri, 12 Jan 2024 22:15:11 +0000 Received: from coridan.postgresql.org ([2001:4800:3e1:1::213]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rOPns-003ibJ-8w for pgsql-hackers@lists.postgresql.org; Fri, 12 Jan 2024 22:15:05 +0000 Received: from localhost ([127.0.0.1] helo=coridan.postgresql.org) by coridan.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rOPns-002hVF-3r for pgsql-hackers@lists.postgresql.org; Fri, 12 Jan 2024 22:15:04 +0000 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Subject: Re: [DOC] Add detail regarding resource consumption wrt max_connections To: pgsql-hackers@lists.postgresql.org From: Cary Huang Cc: Roberto Mello Date: Fri, 12 Jan 2024 22:14:38 +0000 User-Agent: pgcommitfest X-cfsender: cary In-Reply-To: References: Message-ID: <170509767861.1131.15083983626399995184.pgcf@coridan.postgresql.org> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhlIGZvbGxvd2luZyByZXZpZXcgaGFzIGJlZW4gcG9zdGVkIHRocm91Z2ggdGhlIGNvbW1pdGZl c3QgYXBwbGljYXRpb246Cm1ha2UgaW5zdGFsbGNoZWNrLXdvcmxkOiAgdGVzdGVkLCBwYXNzZWQK SW1wbGVtZW50cyBmZWF0dXJlOiAgICAgICB0ZXN0ZWQsIHBhc3NlZApTcGVjIGNvbXBsaWFudDog ICAgICAgICAgIHRlc3RlZCwgcGFzc2VkCkRvY3VtZW50YXRpb246ICAgICAgICAgICAgdGVzdGVk LCBwYXNzZWQKCkkgdGhpbmsgaXQgaXMgZ29vZCB0byB3YXJuIHRoZSB1c2VyIGFib3V0IHRoZSBp bmNyZWFzZWQgYWxsb2NhdGlvbiBvZiBtZW1vcnkgZm9yIGNlcnRhaW4gcGFyYW1ldGVycyBzbyB0 aGF0IHRoZXkgZG8gbm90IGFidXNlIGl0IGJ5IHNldHRpbmcgaXQgdG8gYSBodWdlIG51bWJlciB3 aXRob3V0IGtub3dpbmcgdGhlIGNvbnNlcXVlbmNlcy4NCg0KSXQgaXMgdHJ1ZSB0aGF0IG1heF9j b25uZWN0aW9ucyBjYW4gaW5jcmVhc2UgdGhlIHNpemUgb2YgcHJvYyBhcnJheSBhbmQgb3RoZXIg cmVzb3VyY2VzLCB3aGljaCBhcmUgYWxsb2NhdGVkIGluIHRoZSBzaGFyZWQgYnVmZmVyLCB3aGlj aCBhbHNvIG1lYW5zIGxlc3Mgc2hhcmVkIGJ1ZmZlciB0byBwZXJmb3JtIHJlZ3VsYXIgZGF0YSBv cGVyYXRpb25zLiBJIGFtIHN1cmUgdGhpcyBpcyBub3QgdGhlIG9ubHkgcGFyYW1ldGVyIHRoYXQg YWZmZWN0cyB0aGUgbWVtb3J5IGFsbG9jYXRpb24uICJtYXhfcHJlcGFyZWRfeGFjdHMiIGNhbiBh bHNvIGFmZmVjdCB0aGUgc2hhcmVkIG1lbW9yeSBhbGxvY2F0aW9uIHRvbyBzbyB0aGUgc2FtZSB3 YXJuaW5nIG1lc3NhZ2UgYXBwbGllcyBoZXJlIGFzIHdlbGwuIE1heWJlIHRoZXJlIGFyZSBvdGhl ciBwYXJhbWV0ZXJzIHdpdGggc2ltaWxhciBlZmZlY3RzLiANCg0KSW5zdGVhZCBvZiBzdGF0aW5n IHRoYXQgaGlnaGVyIG1heF9jb25uZWN0aW9ucyByZXN1bHRzIGluIGhpZ2hlciBhbGxvY2F0aW9u LCBJdCBtYXkgYmUgYmV0dGVyIHRvIHRlbGwgdGhlIHVzZXIgdGhhdCBpZiB0aGUgdmFsdWUgbmVl ZHMgdG8gYmUgc2V0IG11Y2ggaGlnaGVyLCBjb25zaWRlciBpbmNyZWFzaW5nIHRoZSAic2hhcmVk X2J1ZmZlcnMiIHNldHRpbmcgYXMgd2VsbC4NCg0KdGhhbmsgeW91DQoNCi0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tDQpDYXJ5IEh1YW5nDQpIaWdoZ28gU29mdHdhcmUgQ2FuYWRhDQp3d3cuaGlnaGdv LmNh