Re: BUG #13819: What is maximum limit on max_connections?

Hello Ashish,

Technically speaking, your doubts are not bugs! But, I will answer you with
two links below:

1 - https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
2 - https://wiki.postgresql.org/wiki/PgBouncer

In the first link, you will have a very good information about tuning
PostgreSQL and of course they talk about max_connections.
In my case, I need to work with more than 5,000 transactions/minute, I
think this is more than you need! Thanks the second link that I gave here,
I could fix my problem with connections. There are more connections pooler
for PostgreSQL, but I did not test them, so I prefer do not comment.

Regards,

On Tue, Dec 15, 2015 at 6:21 PM, <ashish.chauhan@support.com> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      13819
> Logged by:          Ashish Chauhan
> Email address:      ashish.chauhan@support.com
> PostgreSQL version: 9.4.1
> Operating system:   Ubuntu
> Description:
>
> Hi,
>
> I am new to this community and not sure this is right place to ask question
> so please guide me if I have to ask question some other place.
>
> Currently, we have 300 max_connection on production and we are feeling we
> need to increase it to 500. I want to know what is recommended maximum
> limit
> for max_connection? Do we need to start thinking of pooling?
>
> Thanks for your help in advance.
>
> Thanks
> -Ashish
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>



--
Thiago Ferreira
Linux User #487560 (counter.li.org)