enter image description here I was working on benchmark testing for pg10 and pg14.

I did the testing for 100 clients with 12 threads in pg14 I was getting following error,

"pgbench:too many client connections for select()" (screen shot attached)

The same was working fine in pg10, can anybody help me with this issue.

Below is the command used to test,

.\pgbench.exe -d -r -h localhost -U postgres -p 5434 -T 600 -c 100 -j 12 pgbench

  • 1
    Please do not post text info as an image. Dec 5, 2022 at 8:10
  • What is your operating system? Dec 5, 2022 at 11:32
  • At any rate, the error message is new in commit 60e612b6029. Dec 5, 2022 at 11:40
  • That looks like PowerShell, so probably Windows. Windows has a particularly low limit on the number of connections per thread, so increasing -j or reducing -c may avoid the error.
    – dwhitemv
    Dec 5, 2022 at 18:59


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.