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