Postgres Pro
Downloads
Home   >   mailing lists

Re: Selecting RAM and CPU based on max_connections - Mailing list pgsql-performance

From Ganesh Korde
Subject Re: Selecting RAM and CPU based on max_connections
Date
Msg-id CAPNyb0WRsu=h4dOojTFy8VpoF1We6KW+a0iTk7Nv03WP18ON6g@mail.gmail.com
Whole thread Raw
In response to Selecting RAM and CPU based on max_connections  (aditya desai <admad123@gmail.com>)
List pgsql-performance
Tree view
You may also need to tune shmmax and shmmin kernel parameters.

Regards,
Ganesh Korde.

On Fri, 20 May 2022, 1:58 pm aditya desai, <admad123@gmail.com> wrote:
Hi,
One of our applications needs 3000 max_connections to the database. Connection pooler like pgbouncer or pgpool is not certified within the organization yet. So they are looking for setting up high configuration Hardware with CPU and Memory. Can someone advise how much memory and CPU they will need if they want max_conenction value=3000.

Regards,
Aditya.

pgsql-performance by date:

Previous
From: aditya desai
Date:
Subject: Re: Selecting RAM and CPU based on max_connections
Next
From: Jeff Janes
Date:
Subject: Re: Array of integer indexed nested-loop semi join