Re: pgbench: could not connect to server: Resource temporarily unavailable

2022-08-20 Thread Tom Lane
Kevin McKibbin writes: > What's limiting my DB from allowing more connections? > This is a sample of the output I'm getting, which repeats the error 52 > times (one for each failed connection) > -bash-4.2$ pgbench -c 200 -j 200 -t 100 benchy > ... > connection to database "benchy" failed: > coul

pgbench: could not connect to server: Resource temporarily unavailable

2022-08-20 Thread Kevin McKibbin
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