Answer the question
In order to leave comments, you need to log in
How many connections can postgresql-9 handle?
Hello
When testing through pgbench, I noticed that the maximum number of connections that can be installed during the test is 1000:
/usr/pgsql-9.6/bin/pgbench -p 5432 -h localhost -c 900 -C -T 60 -P 1 -U dbuser
Answer the question
In order to leave comments, you need to log in
And how many cores do you have on a piece of iron to run 1000 requests in parallel? Is there at least a hundred CPU cores for this, so that only a dozen processes fight and interfere with each other for each core?
If you want to reduce latency - save already open connections.
If you want to increase throughput - reduce the number of active processes.
Much better than both. So yes, pgbouncer. Or at least a reasonable pool on the application.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question