Re: Selecting RAM and CPU based on max_connections

2022-05-20 Thread Ganesh Korde
You may also need to tune shmmax and shmmin kernel parameters. Regards, Ganesh Korde. On Fri, 20 May 2022, 1:58 pm aditya desai, wrote: > Hi, > One of our applications needs 3000 max_connections to the database. > Connection pooler like pgbouncer or pgpool is not certified within the > organiza

Re: Selecting RAM and CPU based on max_connections

2022-05-20 Thread aditya desai
Thanks! I will run these suggestions with App team. On Fri, May 20, 2022 at 4:01 PM Laurenz Albe wrote: > On Fri, 2022-05-20 at 12:15 +0200, Andreas Kretschmer wrote: > > On 20 May 2022 10:27:50 CEST, aditya desai wrote: > > > One of our applications needs 3000 max_connections to the database.

Re: Selecting RAM and CPU based on max_connections

2022-05-20 Thread Laurenz Albe
On Fri, 2022-05-20 at 12:15 +0200, Andreas Kretschmer wrote: > On 20 May 2022 10:27:50 CEST, aditya desai wrote: > > 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 look

Re: Selecting RAM and CPU based on max_connections

2022-05-20 Thread Andreas Kretschmer
On 20 May 2022 10:27:50 CEST, aditya desai 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