Re: [HACKERS] pgbench unable to scale beyond 100 concurrent connections

2016-06-30 Thread Sachin Kotwal
Hi All, Sorry for trouble you with small environment setup for testing. I should to test this with large machine. What I was testing were involved multiple things same time so quite confusing . possible reason for this testing failure is : 1. small hardware 2. haproxy not able to balance

Re: [HACKERS] pgbench unable to scale beyond 100 concurrent connections

2016-06-29 Thread Craig Ringer
On 29 June 2016 at 21:49, Sachin Kotwal wrote: > Hi, > > > On Wed, Jun 29, 2016 at 6:29 PM, Craig Ringer > wrote: > >> On 29 June 2016 at 18:47, Sachin Kotwal wrote: >> >> >>> I am testing pgbench with more than 100 connections.

Re: [HACKERS] pgbench unable to scale beyond 100 concurrent connections

2016-06-29 Thread Fabien COELHO
Hello, I am testing it with 9.6-beta1 binaries. For server and client it is same. I am using pgbench on top of postgres_fdw. Hmmm... So pgbench is connected to some pg instance, and this pg instance is connected to something else on another host? Or to the same instance, in which case you

Re: [HACKERS] pgbench unable to scale beyond 100 concurrent connections

2016-06-29 Thread Jeff Janes
On Wed, Jun 29, 2016 at 5:36 AM, Sachin Kotwal wrote: > Hi Fabien, > > Sorry for very short report. > I feel pgbench is not so complex tool. > > Please see below answers to your questions. > > > On Wed, Jun 29, 2016 at 5:07 PM, Fabien COELHO wrote: >> >>

Re: [HACKERS] pgbench unable to scale beyond 100 concurrent connections

2016-06-29 Thread Robert Haas
On Wed, Jun 29, 2016 at 8:36 AM, Sachin Kotwal wrote: > postgresql does not give any error. > > pgbench says: > client 36 aborted in state 2: ERROR: could not connect to server "server_1" > DETAIL: FATAL: sorry, too many clients already The error message that you are

Re: [HACKERS] pgbench unable to scale beyond 100 concurrent connections

2016-06-29 Thread Sachin Kotwal
Hi, On Wed, Jun 29, 2016 at 6:29 PM, Craig Ringer wrote: > On 29 June 2016 at 18:47, Sachin Kotwal wrote: > > >> I am testing pgbench with more than 100 connections. >> also set max_connection in postgresql.conf more than 100. >> >> Initially

Re: [HACKERS] pgbench unable to scale beyond 100 concurrent connections

2016-06-29 Thread Craig Ringer
On 29 June 2016 at 18:47, Sachin Kotwal wrote: > I am testing pgbench with more than 100 connections. > also set max_connection in postgresql.conf more than 100. > > Initially pgbench tries to scale nearby 150 but later it come down to 100 > connections and stable there. >

Re: [HACKERS] pgbench unable to scale beyond 100 concurrent connections

2016-06-29 Thread Sachin Kotwal
Hi Fabien, Sorry for very short report. I feel pgbench is not so complex tool. Please see below answers to your questions. On Wed, Jun 29, 2016 at 5:07 PM, Fabien COELHO wrote: > > Hello Sachin, > > Your report is very imprecise so it is hard to tell anything. > > What

Re: [HACKERS] pgbench unable to scale beyond 100 concurrent connections

2016-06-29 Thread Fabien COELHO
Hello Sachin, Your report is very imprecise so it is hard to tell anything. What version of client and server are you running? On what hardware ? (200 connections => 200 active postgres processes, how many processes per core are you expecting to run? the recommanded value is about 2

[HACKERS] pgbench unable to scale beyond 100 concurrent connections

2016-06-29 Thread Sachin Kotwal
Hi, I am testing pgbench with more than 100 connections. also set max_connection in postgresql.conf more than 100. Initially pgbench tries to scale nearby 150 but later it come down to 100 connections and stable there. It this limitation of pgbench? or bug? or i am doing it wrong way? --- I