From: | Kevin McKibbin <kevinmckibbin123(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)lists(dot)postgresql(dot)org |
Subject: | pgbench: could not connect to server: Resource temporarily unavailable |
Date: | 2022-08-21 02:08:47 |
Message-ID: | CADc_NKg2d+oZY9mg4DdQdoUcGzN2kOYXBu-3--RW_hEe0tUV=g@mail.gmail.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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. All by 20 times.
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:
could not connect to server: Resource temporarily unavailable
Is the server running locally and accepting
connections on Unix domain socket
"/var/run/postgresql/.s.PGSQL.5432"?
transaction type: <builtin: TPC-B (sort of)>
scaling factor: 50
query mode: simple
number of clients: 200
number of threads: 200
number of transactions per client: 100
number of transactions actually processed: 14800/20000
latency average = 165.577 ms
tps = 1207.895829 (including connections establishing)
tps = 1255.496312 (excluding connections establishing)
Thanks,
Kevin
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2022-08-21 03:20:02 | Re: pgbench: could not connect to server: Resource temporarily unavailable |
Previous Message | Rick Otten | 2022-08-12 20:17:02 | Re: to_jsonb performance on array aggregated correlated subqueries |