[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Max_connection
From:       Daulat <daulat.dba () gmail ! com>
Date:       2022-02-18 12:48:31
Message-ID: CALfOM6+k6+3zAZq80qZCBvAw5B5iT0GGu2LnDqC4caMKLU6yBg () mail ! gmail ! com
[Download RAW message or body]

On Fri, Feb 18, 2022 at 2:39 PM Daulat <daulat.dba@gmail.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.dba@gmail.com> wrote:
>
>> Hello,
>>
>> Any one can suggest the criteria/thumb rule of deciding max_connection
>> limit in postgres.
>>
>> Thanks
>>
>>
>>

[Attachment #3 (text/html)]

<div dir="ltr"><div dir="ltr"><br></div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">On Fri, Feb 18, 2022 at 2:39 PM Daulat &lt;<a \
href="mailto:daulat.dba@gmail.com">daulat.dba@gmail.com</a>&gt; \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div \
dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">As I know, each PostgreSQL \
connection consumes RAM for managing the connection or the client using it. The more \
connections, the more RAM.</div><div>I have a machine having 124 GB RAM and 16 CPU  \
with SSD storage.  </div><div>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.  </div><div \
dir="ltr"><div><br></div><div>I feel, we need to increase the shared buffer too while \
increasing the connections. I don&#39;t have idea still, we need to increase \
kernel.shmmax also?</div><div><br></div><div><br></div><div>Thanks</div><div><br></div></div></div></div></div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Feb 17, 2022 at 10:47 \
PM Daulat &lt;<a href="mailto:daulat.dba@gmail.com" \
target="_blank">daulat.dba@gmail.com</a>&gt; wrote:<br></div><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="auto">Hello,  <div \
dir="auto"><br></div><div dir="auto">Any one can suggest the criteria/thumb rule of \
deciding max_connection limit in postgres.  </div><div dir="auto"><br></div><div \
dir="auto">Thanks</div><div dir="auto"><br></div><div dir="auto"><br></div></div> \
</blockquote></div> </blockquote></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]