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
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]: |