Re: Selecting RAM and CPU based on max_connections

From: Ganesh Korde <ganeshakorde(at)gmail(dot)com>
To: aditya desai <admad123(at)gmail(dot)com>
Cc: Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: Selecting RAM and CPU based on max_connections
Date: 2022-05-20 17:59:40
Message-ID: CAPNyb0WRsu=h4dOojTFy8VpoF1We6KW+a0iTk7Nv03WP18ON6g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)gmail(dot)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.
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Janes 2022-05-23 02:45:14 Re: Array of integer indexed nested-loop semi join
Previous Message aditya desai 2022-05-20 15:40:37 Re: Selecting RAM and CPU based on max_connections