pgbench bug / limitation

From: "Jawarilal, Manish" <Manish(dot)Jawarilal(at)dell(dot)com>
To: "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: pgbench bug / limitation
Date: 2020-05-28 15:30:55
Message-ID: BL0PR1901MB1985F219C46C61EDE7036C34ED8E0@BL0PR1901MB1985.namprd19.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello Team,

I was using pgbench to run benchmarking tests on our postgres server and came across this issue which I feel is pgbench bug.
I had initialized the test DB with scale factor 200. And then started the test with clients (-c 150) but it never worked until I reduced the clients to 115.
Below is the error message.

OS: Windows 10
Version: pgbench (PostgreSQL) 12.2
Max Connection allowed on Server: 800

C:\Program Files\PostgreSQL\12\bin>pgbench.exe -i -s 200 -h <DBServerName> -p 9432 -U DBUser testdb

C:\Program Files\PostgreSQL\12\bin>pgbench.exe -c 122 -r -T 3600 -h <DBServerName> -p 9432 -U DBUser testdb
Password:
starting vacuum...end.
too many client connections for select()

C:\Program Files\PostgreSQL\12\bin>pgbench.exe -c 120 -r -T 3600 -h <DBServerName> -p 9432 -U DBUser testdb
Password:
starting vacuum...end.
too many client connections for select()

Thanks
Manish

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2020-05-28 17:31:30 Re: pgbench bug / limitation
Previous Message Tom Lane 2020-05-28 13:14:20 Re: Re[2]: