Thanks for your input everyone! I wanted to confirm that increasing the
somaxconn also fixed the issue for me.
Kevin
> $ cat /proc/sys/net/core/somaxconn
> 128
>
> by default, which is right about where the problem starts. After
>
> $ sudo sh -c 'echo 1000 >/proc/sys/net/core/somaxconn'
>
> *an
else could be limiting the connections?
>
> Kevin
>
>
> On Sat, 20 Aug 2022 at 21:20, Tom Lane wrote:
>
>> Kevin McKibbin writes:
>> > What's limiting my DB from allowing more connections?
>>
>> > This is a sample of the output I'm getting, whic
Hi Everyone,
I'm trying to run pgbench with various numbers of connections. However, my
DB seems to be hitting some limit around 147-150 connections. I'd like to
run with at least 500 and even up to 2000 if possible.
I've already increased the max_connections, shared_buffers
and kernel.shmmax. Al
