Re: Max_connection

On Fri, Feb 18, 2022 at 2:39 PM Daulat <daulat(dot)dba(at)gmail(dot)com> wrote:

> As I know, each PostgreSQL connection consumes RAM for managing the
> connection or the client using it. The more connections, the more RAM.
> I have a machine having 124 GB RAM and 16 CPU with SSD storage.
> Currently, 1200 connections are set but this value is low according to my
> application. hence, I am looking to know the criteria/thumb rule of
> deciding max_connection limit in postgres.
>
> I feel, we need to increase the shared buffer too while increasing the
> connections. I don't have idea still, we need to increase kernel.shmmax
> also?
>
>
> Thanks
>
>
> On Thu, Feb 17, 2022 at 10:47 PM Daulat <daulat(dot)dba(at)gmail(dot)com> wrote:
>
>> Hello,
>>
>> Any one can suggest the criteria/thumb rule of deciding max_connection
>> limit in postgres.
>>
>> Thanks
>>
>>
>>